DBMS General - Quiz

Relational Database Design Quiz

1. In the relational modes, what do we mean by the term “Cardinality”?

Number of tuples
Number of attributes
Number of tables
Number of constraints

2. In relational algebra, Cartesian product is a ___________ operator?

Unary operator
Binary operator
Ternary operator
None of the above

3. Which of the following is an example of procedural language?

Relational calculus
Relational algebra
SQL
All of the above

4. ODBC stands for _________ .

Object Database Connectivity
Open Database Connectivity
Oracle Database Connectivity
Orient Database Connectivity

5. A database schema can be defined using which of the following languages?

DML
DCL
DDL
TCL

6. ________ is used as the defacto standard language to interact with the database.

SQL
DDL
NoSQL
None of the above

7. A Cartesian product of two relations is the same as their union. TRUE/FALSE.

TRUE
FALSE

8. Data independence means

Data is defined separately and not included in programs
Programs are not dependent on the physical attributes of data
Programs are not dependent on the logical attributes of data
Both B and C

9. Which of the following is used to represent the relationships between two relations (tables)?

Primary key
Secondary key
Foreign key
Surrogate key

10. The file organization that provides very fast access to any arbitrary record of a file is ___ .

Hashed file
Unordered file
Ordered file
Clustered file

Score =

Correct answers: