Current Affairs APP

Computer Quiz : DBMS Set – 10

Dear Aspirants,
Welcome to Online Computer Quiz in Affairscloud.com. Here we are providing sample questions in DBMS. It will be very useful for all SBI/IBPS/LIC exams and other competitive exams. We have also included some important questions that are repeatedly asked in previous exams.

  1. Which of the following Normal Form(NF) is considered adequate for relational database design?
    A. 2NF
    B. 3NF
    C. 4NF
    D. BCNF
    Answer
    B. 3NF

  2. Which is a special type of stored procedure that is automatically invoked whenever the data in the table is modified?
    A. Procedure
    B. Trigger
    C. Cursor
    D. None of the above
    Answer
    B. Trigger

  3. Which of the following is the most powerful language for working with RDBMS?
    A. Embedded Programs
    B. Dynamic Programs
    C. Query Language
    D. Static Language Programs
    Answer
    C. Query Language

  4. DML stands for _______
    A. Data Markup Language
    B. Data Manipulation Language
    C. Data Marking Language
    D. Data Multiple Language
    Answer
    B. Data Manipulation Language

  5. Which of the following language is used to define the integrity constraints?
    A. DCL
    B. DML
    C. DDL
    D. All of the above
    Answer
    C. DDL

  6. A transaction state changes from active to______, after the transaction has been rolled back and the database restored to its state prior to the start of the transaction.
    A. Partially committed
    B. Committed
    C. Aborted
    D. Failed
    Answer
    C. Aborted

  7. The problem caused by independent multivalued dependencies is eliminated in which of the normal form?
    A. 3NF
    B. BCNF
    C. 4NF
    D. 5NF
    Answer
    C. 4NF

  8. DDL stands for __________
    A. Data Define Language
    B. Data Description Language
    C. Data Definition Language
    D. Data Design Language
    Answer
    C. Data Definition Language

  9. When a primary key is define in the table, DBMS automatically creates a(n) _________ on a primary key column.
    A. Unique index
    B. Sequence
    C. Trigger
    D. Synonym
    Answer
    A. Unique index

  10. What is the full form of DCL?
    A. Data Code Language
    B. Data Common Language
    C. Data Control Language
    D. Data Clear Language
    Answer
    C. Data Control Language





Exit mobile version