Online Tests 2017

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