Scribd Logo
Upload

Welcome to Scribd!

  • 62 views

    MCQ For Database

    Uploaded by

    ronics123
    The document contains 15 multiple choice questions testing database fundamentals. The questions cover topics such as data abstraction levels, database administrators, database structure including tables, rows and keys, data manipulation languages, transactions, schemas and altering database objects.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    MCQ For Database

    Uploaded by

    ronics123
    62 views3 pages
    The document contains 15 multiple choice questions testing database fundamentals. The questions cover topics such as data abstraction levels, database administrators, database structure including tables, rows and keys, data manipulation languages, transactions, schemas and altering database objects.

    Original Title

    mcq for database

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains 15 multiple choice questions testing database fundamentals. The questions cover topics such as data abstraction levels, database administrators, database structure including tables, rows and keys, data manipulation languages, transactions, schemas and altering database objects.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    62 views3 pages

    MCQ For Database

    Uploaded by

    ronics123
    The document contains 15 multiple choice questions testing database fundamentals. The questions cover topics such as data abstraction levels, database administrators, database structure including tables, rows and keys, data manipulation languages, transactions, schemas and altering database objects.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 3

    1.

    Which of the following refers to the level of data abstraction that describes exactly
    how the data actually stored?
    a. Conceptual Level
    b. Physical Level
    c. File Level
    d. Logical Level

    2. To which of the following the term "DBA" referred?


    a. Data Bank Administrator
    b. Database Administrator
    c. Data Administrator
    d. None of the above

    3. In general, a file is basically a collection of all related______.


    a. Rows & Columns
    b. Fields
    c. Database
    d. Records

    4. Rows of a relation are known as the _______.


    a. Degree
    b. Tuples
    c. Entity
    d. All of the above

    5. Which one of the following is a type of Data Manipulation Command?


    a. Create
    b. Alter
    c. Delete
    d. All of the above

    6. Which of the following command is a type of Data Definition language command?


    a. Create
    b. Update
    c. Delete
    d. Merge

    7. The term "TCL" stands for_____.


    a. Ternary Control Language
    b. Transmission Control Language
    c. Transaction Central Language
    d. Transaction Control Language

    8. Which of the following is used in the application programs to request data from the
    database management system?
    a. Data Manipulation language
    b. Data Definition Language
    c. Data Control Language
    d. All of the above

    9. Which of the following commands is used to save any transaction permanently into
    the database?
    a. Commit
    b. Rollback
    c. Savepoint
    d. None of the above

    10. The term "SQL" stands for


    a. Standard query language
    b. Sequential query language
    c. Structured query language
    d. Server-side query language

    11. Which of the following keys is generally used to represents the relationships between
    the tables?
    a. Primary key
    b. Foreign key
    c. Secondary key
    d. None of the above
    12. Which one of the following keyword is used to find out the number of values in a
    column?
    a. TOTAL
    b. COUNT
    c. SUM
    d. ADD

    13. Which one of the following is commonly used to define the overall design of the
    database?
    a. Application program
    b. Data definition language
    c. Schema
    d. Source code

    14. Which one of the following commands is used to modify a column inside a table?
    a. Drop
    b. Update
    c. Alter
    d. Set
    15.

    You might also like