Current Affairs PDF

Computer Quiz : DBMS Set – 10

AffairsCloud YouTube Channel - Click Here

AffairsCloud APP Click Here

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
    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
    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
    C. Query Language

  4. DML stands for _______
    A. Data Markup Language
    B. Data Manipulation Language
    C. Data Marking Language
    D. Data Multiple Language
    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
    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
    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
    C. 4NF

  8. DDL stands for __________
    A. Data Define Language
    B. Data Description Language
    C. Data Definition Language
    D. Data Design Language
    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
    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
    C. Data Control Language