Data Base Questions :-

1. The level of data abstraction which describes how the data is actually stored is?

[A] Physical level

[B] Conceptual level

[C] Storage Level

[D] File level

2. The level of abstraction describes only part of the entire database is called?

[A] Conceptual level

[B] View Level

[C] Procedural Level

[D] None of above

3. Object based data models are used in describing the abstraction of the following levels?

[A] Conceptual and view

[B] Only physical

[C] Physical and conceptual

[D] Only conceptual

4. An association of several structure of a data base can be expressed graphically by?

[A] Tuple

[B] Record

[C] Relationship

[D] Field

5. The overall logical structure of data base can be expressed graphically by?

[A] Data flow chart

[B] Flow chart

[C] Directed Graph

[D] Entity relationship diagram

6. In an object oriented model, one object can access data of another object by passing?

[A] Instance variable

[B] Variable

[C] Message

[D] Function

7. The collection of information stored in a database at a particular moment is?

[A] View

[B] Instance

[C] Scheme

[D] None of these

8. The overall design of a database is called?

[A] Scheme of the database

[B] The screen of database

[C] Structure of the database

[D] View of the database

9. The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

[A] entity integrity rule

[B] referential integrity constraint

[C] action assertion

[D] composite attribute

10. Three SQL, DDL, CREATE commands are ________ .

[A] Schema, Base and Table

[B] Key, Base and Table

[C] Base, Table and Schema

[D] Schema, Table and View