Scribd Logo
Upload

Welcome to Scribd!

  • 3K views

    Rdbms MCQ Quiz

    Uploaded by

    Shahzada Ali
    This document contains a quiz on relational database management systems (RDBMS) with 21 multiple choice questions. The questions test fundamental RDBMS concepts like the components of an RDBMS, the definition of attributes, tuples and relations, primary keys and foreign keys, normalization, and relational algebra operations. The quiz is intended to assess the taker's basic knowledge of RDBMS concepts.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Rdbms MCQ Quiz

    Uploaded by

    Shahzada Ali
    3K views5 pages
    This document contains a quiz on relational database management systems (RDBMS) with 21 multiple choice questions. The questions test fundamental RDBMS concepts like the components of an RDBMS, the definition of attributes, tuples and relations, primary keys and foreign keys, normalization, and relational algebra operations. The quiz is intended to assess the taker's basic knowledge of RDBMS concepts.

    Original Title

    rdbms-mcq

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a quiz on relational database management systems (RDBMS) with 21 multiple choice questions. The questions test fundamental RDBMS concepts like the components of an RDBMS, the definition of attributes, tuples and relations, primary keys and foreign keys, normalization, and relational algebra operations. The quiz is intended to assess the taker's basic knowledge of RDBMS concepts.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    3K views5 pages

    Rdbms MCQ Quiz

    Uploaded by

    Shahzada Ali
    This document contains a quiz on relational database management systems (RDBMS) with 21 multiple choice questions. The questions test fundamental RDBMS concepts like the components of an RDBMS, the definition of attributes, tuples and relations, primary keys and foreign keys, normalization, and relational algebra operations. The quiz is intended to assess the taker's basic knowledge of RDBMS concepts.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    By OnlineInterviewQuestions.

    com
    Rdbms MCQ Quiz

    Take Rdbms Quiz To test your Knowledge


    Below are few Rdbms MCQ test that checks your basic knowledge of Rdbms. This Rdbms Test contains
    around 20 questions of multiple choice with 4 options. You have to select the right answer to a question. You
    can see the correct answer by clicking view answer link.

    Also, Read Best Rdbms interview questions.

    Q1. A RDBMS consists a collection of ?

    A. Tables
    B. Fields
    C. Records
    D. Keys

    Q2. The term attribute refers to a ___________ of a table.

    A. Record
    B. Tuple
    C. Column
    D. Key

    Q3. In relational model, the row of table is known to be ?

    A. Relation
    B. Entity field
    C. Tuple
    D. Attribute

    Q4. Address field of a person should not be part of primary key, since it is likely to ?

    A. Dependent
    B. Too long
    C. Changed
    D. Not changed

    Q5. The relational model is concerned with ?

    A. Data structure and Data integrity


    B. Data Manipulation
    C. Both A and B
    D. None of these

    Q6. Which is the false statement from the following ?

    A. A veiw is a named derived table


    B. A name relation is variable
    C. A veiw is a named reation and is virtual
    D. None of these

    Q7. The union of primary keys of the related entity sets becomes a -------------------------- of
    the relation ?

    A. Super Key
    B. Candidate key
    C. Foreign key
    D. Primary key

    Q8. What is the full form of RDBMS ?

    A. Right Database Management System


    B. Relational Database Management system
    C. Rapid Database Management System
    D. Route Database Management System

    Q9. In a relational Database a referential integrity constraint cab be specified with the
    help of ;
    A. Primary Key
    B. Secondry key
    C. Foreign key
    D. None of these

    Q10. Primary key should be chosen such that its attribute values are never

    A. Updated
    B. Changed
    C. Dependent
    D. None of these

    Q11. Query language is a language in which a user ?

    A. Requests
    B. Stores
    C. Response
    D. Represents

    Q12. Minimal superkeys are called ?

    A. Unique key
    B. Superset key
    C. Candidate key
    D. Primary key

    Q13. A table is a collection of relationships, there is a close correspondence between


    concept of :

    A. Tables and instances


    B. Table and variables
    C. Tables and relations
    D. Tables and Entries

    Q14. Contents of a relation instance may change with time as relation :

    A. Domain
    B. Retrieved
    C. Updated
    D. Time

    Q15. Query languages used in practice includes

    A. Elements
    B. Instances
    C. Tuples
    D. Fields

    Q16. Logical design of database, is known to be

    A. Database relation
    B. Database instance
    C. Database entity
    D. Database Schema

    Q17. A domain is atomic if elements of the domain are considered to be ____________


    units.

    A. Different
    B. Indivisbile
    C. Constant
    D. Divisible

    Q18. Which one of the following is a procedural language ?

    A. Domain relational calculus


    B. Tuple relational calculus
    C. Query language
    D. Relational algebra

    Q19. The _______operation performs a set union of two “similarly structured” tables :

    A. Intersect
    B. Product
    C. Union
    D. Join
    Q20. Which is the operator, takes the results of two queries and returns only rows that
    appear in both result sets ?

    A. Union
    B. Projection
    C. Difference
    D. Intersect

    Q21. The_____ operation allows the combining of two relations by merging pairs of
    tuples, one from each relation, into a single tuple.

    A. Select
    B. Intersection
    C. Union
    D. Join

    Please Visit OnlineInterviewquestions.com to download more pdfs

    You might also like