Wednesday, 10 September 2014

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:

SQL exercises for beginners one

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