Current Affairs PDF Sales

DBMS Questions – Set 18

AffairsCloud YouTube Channel - Click Here

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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    C. Where
    Explanation:
    “Where” clause allows you to specify exact rows to select based on a particular filtering condition