Advanced Database Management System - Tutorials and Notes: DBMS General - Quiz

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
    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?

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

7. A Cartesian product of two relations is the same as their union. 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

Featured Content

Multiple choice questions in Natural Language Processing Home

MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...

All time most popular contents