Friday, 3 April 2015

DBMS Basics and ER Model Quiz 7

Entity-Relationship Modeling Quiz 1


1. In a Entity-Relationship data model, an entity becomes a(n) _____________
    Attribute
    Table
    Constraint
    Column

2. The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
    Procedural DML
    Non-Procedural DML
    Procedural DDL
    Non-Procedural DDL

3. Which of the following data model is widely applied in many real world database applications?
    Network model
    Relational model
    Hierarchical model
    None of the above

4. The logical design of the database is database __________, a snapshot of the data in the database at a given instant in time is database ________.
    Instance, Schema
    Relation, Schema
    Relation, Domain
    Schema, Instance

5. The tuples (records) of the relations (tables) can be of ________ order.
    Any
    Ascending
    Sorted
    Descending

6. Which of the following is the collection of interrelated data and set of program to access them?
    Data structure
    Database
    DBMS
    Programming Language

7. Database management systems are intended to
    Eliminate data redundancy
    Establish relationships among records in different files
    Manage file access
    All of the above

8. ________________defines the database schema, Interacts continuously with users, defines integrity and security checks, defines procedures for backup and recovery
    Sophisticated User
    Naïve User
    DBA
    Application Programmer

9. The number of tuples in a relation is called __________ of a relation.
    Cardinality
    Degree
    Tuple
    Key

10. The number of attributes (columns) in a relation is called __________ of a relation.
    Cardinality
    Degree
    Tuple
    Key

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