RDBMS

In the architecture of the Database System, external level is the

• Physical level

• Logical level

• Conceptual level

• View level

In Hierarchical Model records are organized as

• Graph

• List

• Links

• Tree

In an ER diagram, attributes are represented by?

• Rectangle

• Square

• Ellipse

• Triangle

A logical Schema

• is the entire database.

• is a standard way of organizing the information into accessible parts.

• describes how data actually stores on the disc

• options 1 & 3

In an ER diagram, Entity types are represented by

• rectangle

• ellipse

• diamond box

• circle

A relational database developer refers to a record as

• Criteria

• a relation

• a tuple

• an attribute

An advantage of DBMS approach is

• data is dependent on programs

• data redundancy increases

• data can be integrated and can be accessed by multiple programs

• none of the above

Which of the following are the properties of entities?

• Groups

• Tables

• Attributes

• Switchboards

In ER diagram relationship type is represented by

• Ellipse

• Dashed Ellipse

• Rectangle

• Diamond

What database level is closest to the user

• External

• Internal

• Physical

• Conceptual