Relational Model – Exercise – 1

Relational Model » Exercise – 1

1. A relational database is :

(a) the same as a flat file database.
(b) one that consists of two or more tables.
(c) one that consists of two or more tables that are joined in some way.
(d) a database that is able to process tables, queries, forms, reports and macros.

2. The ER model is meant to :

(a) replace relational design.
(b) enable low level descriptions of data.
(c) be close to a users perception of the data.
(d) enable detailed descriptions of data query processing.

3. A Foreign Key is :

(a) A field in a table that matches a key field in another table.
(b) A field in a table that has the same name as a key field in another table.
(c) A field in a table that contains data that is also contained elsewhere in another table.
(d) None of these

4. The full form of DDL is :

(a) Dynamic Data Language
(b) Detailed Data Language
(c) Data Definition Language
(d) Data Derivation Language

5. DML is provided for :

(a) Description of logical structure of database.
(b) Addition of new structures in the database system.
(c) Manipulation & processing of database.
(d) Definition of physical structure of database system.

Related Posts