DBMS Questions – Set 18

Dear Aspirants,
Welcome to the Professional Knowledge Section in Affairscloud.com. Here we are providing sample questions in Computer Networking. It will be useful for the upcoming SBI Assistant Manager(System) and IBPS SO(IT Officer) examinations. We have also included some important questions that are repeatedly asked in previous exams.

1. Which of the following uniquely identifies each record in the table?
   A. Foreign Key
   B. Secondary Key
   C. Primary Key
   D. All of the Above
   E. None of the Above
   
   Answer & Explanation

   C. Primary Key
   Explanation:
   The primary key of a relational table uniquely identifies each record in the table.
   
   
2. Which of the following is also referred to as an EQUIJOIN?
   A. Inner Join
   B. Left Outer Join
   C. Right Outer Join
   D. Natural Join
   E. None of the Above
   
   Answer & Explanation

   A. Inner Join
   Explanation:
   Inner Join, one of the most frequently used joins is also referred to as an EQUIJOIN.
   
   
3. The multivalued dependency plays a role in the ________ database normalization.
   A. 1NF
   B. 2NF
   C. 3NF
   D. 4NF
   E. None of the Above
   
   Answer & Explanation

   D. 4NF
   Explanation:
   The multivalued dependency plays a role in the 4NF database normalization.
   
   
4. Which of the following normal form is considered adequate for normal relational database design?
   A. 1NF
   B. 2NF
   C. 3NF
   D. 4NF
   E. None of the Above
   
   Answer & Explanation

   C. 3NF
   Explanation:
   3NF is considered adequate for normal relational database design
   
   
5. Which of the following key is also known as minimal super key ?
   A. Foreign Key
   B. Secondary Key
   C. Primary Key
   D. Candidate Key
   E. None of the Above
   
   Answer & Explanation

   D. Candidate Key
   Explanation:
   A candidate key is a minimal set of attributes necessary to identify a tuple. It is also known as minimal super key.
   
   
6. BCNF stands for ______
   A. Binary–Coded Normal Form
   B. Boyce–Codd Normal Form
   C. Binary–Codd Normal Form
   D. Boyce–Code Normal Form
   E. Binary–Code Normal Form
   
   Answer & Explanation

   B. Boyce–Codd Normal Form
   Explanation:
   Boyce–Codd normal form (or BCNF or 3.5NF) is a normal form used in database normalization.
   
   
7. Which of the following is considered a special condition of third Normal form?
   A. 4NF
   B. BCNF
   C. 5NF
   D. 3NF
   E. None of these
   
   Answer & Explanation

   B. BCNF
   Explanation:
   Boyce Codd Normal Form (BCNF) is considered a special condition of third Normal form.
   
   
8. Which of the following is an aggregate function in MySQL
   A. COUNT
   B. AVG
   C. SUM
   D. MAX
   E. All of the Above
   
   Answer & Explanation

   E. All of the Above
   Explanation:
   MySQL provides aggregate functions that include AVG, COUNT, SUM, MIN, MAX, etc.,
   
   
9. Which of the following statement allows you to get the data from tables or views?
   A. Select
   B. Distinct
   C. Where
   D. In
   E. Like
   
   Answer & Explanation

   A. Select
   Explanation:
   Select statement allows you to get the data from tables or views
   
   
10. Which of the following clause allows you to specify exact rows to select based on a particular filtering condition?
    A. Select
    B. Distinct
    C. Where
    D. In
    E. Like
    
    Answer & Explanation

    C. Where
    Explanation:
    “Where” clause allows you to specify exact rows to select based on a particular filtering condition