DBMS Basics Quiz

Database System Architectures - Quiz

1. What do you mean by Cardinality in Relational database?

Number of Tables
Number of Tuples (Records)
Number of Attributes
Number of Integrity Constraints

2. The view of a complete database is

Conceptual View
Physical View
Internal View
External View

3. In relational algebra, Cartesian product is ________________ operator.

an Unary operator
a Binary operator
a Ternary operator
All of the above

4. In Relational database, a relation is called as

Tables
Tuples
Attributes
None of the above

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

DML
DDL
TCL
RDL

6. External level of the database system architecture is termed as

Logical Level
View Level
Conceptual Level

7. An entity set that does not have sufficient attributes to form a Primary key is _________

Simple entity set
Strong entity set
Weak entity set
Not an entity set

8. The DBMS language component which can be embedded in an application program is

DDL
DML
TCL
RDL

9. Which of the following is used in SQL to redefine/modify the definition of a table which already exists?

UPDATE
SET
ALTER

10. Relational Algebra is a ________________ language.

Data Definition Language
Procedural Language
Non-Procedural Language
Data Manipulation Language

Score =

Correct answers: