Thursday, 21 January 2016

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:

No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...