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.

Answer
Answer : (c)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

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.

Answer
Answer : (c)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

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

Answer
Answer : (a)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

4. The full form of DDL is :

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

Answer
Answer : (c)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

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.

Answer
Answer : (c)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

Related Posts

  • Relational Model - 3Relational Model » Exercise - 13. 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
    Tags: table, field, key, relational, model, exercise, data, computer, science
  • Relational Model – 4Relational Model » Exercise - 14. The full form of DDL is : (a) Dynamic Data Language (b) Detailed Data Language (c) Data Definition Language (d) Data Derivation Language
    Tags: language, data, relational, model, exercise, ddl, detailed, definition, computer, science
  • Relational Model - 6Relational Model » Exercise - 16. The database schema is written in : (a) HLL (b) DML (c) DDL (d) DCL
    Tags: relational, model, exercise, database, dml, ddl, computer, science
  • Relational Model - 5Relational Model » Exercise - 15. 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. 
    Tags: database, structure, system, model, relational, dml, exercise, processing, definition, computer
  • Relational Model - 9Relational Model » Exercise - 19. The language used in application programs to request data from the DBMS is referred to as the : (a) DML (b) DDL (c) VDL (d) SDL
    Tags: relational, model, exercise, language, data, dml, ddl, computer, science