Scribd Logo
Upload

Welcome to Scribd!

  • 34 views

    RDBMS1

    Uploaded by

    Kailash Kandhasamy G
    The document contains a worksheet on relational database management systems (RDBMS) with multiple choice questions. Some key points: - RDBMS stands for relational database management system, where data is stored in tables with rows and columns and relationships can be defined between tables. - Questions cover topics like database concepts, keys, constraints, cardinality, degree, normalization, and relationships between tables defined through foreign keys. - An example table called "Employee" is given containing attributes like EMPID, Name, Email which could define a primary key and relationship between tables.

    Copyright:

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

    RDBMS1

    Uploaded by

    Kailash Kandhasamy G
    34 views3 pages
    The document contains a worksheet on relational database management systems (RDBMS) with multiple choice questions. Some key points: - RDBMS stands for relational database management system, where data is stored in tables with rows and columns and relationships can be defined between tables. - Questions cover topics like database concepts, keys, constraints, cardinality, degree, normalization, and relationships between tables defined through foreign keys. - An example table called "Employee" is given containing attributes like EMPID, Name, Email which could define a primary key and relationship between tables.

    Original Title

    RDBMS1[1]

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a worksheet on relational database management systems (RDBMS) with multiple choice questions. Some key points: - RDBMS stands for relational database management system, where data is stored in tables with rows and columns and relationships can be defined between tables. - Questions cover topics like database concepts, keys, constraints, cardinality, degree, normalization, and relationships between tables defined through foreign keys. - An example table called "Employee" is given containing attributes like EMPID, Name, Email which could define a primary key and relationship between tables.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    34 views3 pages

    RDBMS1

    Uploaded by

    Kailash Kandhasamy G
    The document contains a worksheet on relational database management systems (RDBMS) with multiple choice questions. Some key points: - RDBMS stands for relational database management system, where data is stored in tables with rows and columns and relationships can be defined between tables. - Questions cover topics like database concepts, keys, constraints, cardinality, degree, normalization, and relationships between tables defined through foreign keys. - An example table called "Employee" is given containing attributes like EMPID, Name, Email which could define a primary key and relationship between tables.

    Copyright:

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

    MAHARISHI VIDYA MANDIR, TENKASI

    WORKSHEET ON RDBMS
    I. Multiple choice Questions(MCQ):
    1. DBMS stands for______c_______

    a) Data Base Management Software b) Data Base Maintenance System

    c) Data Basic Management System d) Data Base management system

    2. In RDBMS, R stands for_____a____

    a) Relational b)Rotational c)Rational d)None of the above

    3. A Database contains one or more___a____

    a) Data b)Tables c)Files d)Links

    4. What is not true in respect of DBMS?

    a) Database enforces standards b) Database increases redundancy

    c) Database facilitates sharing of data d) Database helps to maintain integrity

    5. Cardinality is total ______b_____

    a) number of rows in a table b) number of columns in a table

    c) number of data items in a table d) none of the above

    6. Degree refers to total_____a____

    a) number of rows in a table b) number of columns in a table

    c) number of data items in a table d) none of the above

    7. Referential Integrity is a rule that ensures _____c_______ between records in

    related tables are valid.

    a) Links b)difference c)relationship d)similarity

    8. Data about data is ______b___

    a) Data redundancy b) Meta Data c) Database schema d) None of the above

    9. Repetition of data is called .......a.......

    a) Data redundancy b) Data Description c) Data inconsistency d) None of the above

    10. Mismatched redundant copies of data is known as data ...d.........

    a) Dependence b)Inconsistency c)Isolation d)Redundancy

    11. A .......c..... is an organized collection of structured data.

    a) Database b) File c) DBMS d) Information

    12. A data ..........b...... is a set of rules that define valid data.

    a) Query b)Constraint c)Dictionary d)All of the above


    13. A relational database consists of a collection of ......d........

    a) Fields b)Records c)Keys d)Tables

    14. A row in a database.

    a) Field b)Record c)Key d)Table

    15. The term ________d____ is used to refer to a field in a table.

    a) Attribute b)Row c)Tuple d)Instance

    16. Which of the following statements is not true about relational database?

    a) Relational data model is the most widely used data model.

    b) The data is arranged as a collection of tables in relational database.

    c) Relational database increases data redundancy and inconsistency.

    d) None of the above.

    17. Which of the following is a disadvantage of file processing system?

    a) Data redundancy b) Data isolation c) Data inconsistency d) All of the above

    18. A ___b__ is a property of the entire relation, rather than of the individual tuples in

    which each tuple is unique.

    a) Rows b)Key c)Attribute d)Fields

    19. Which one of the following attribute can be taken as a primary key?

    a) Name b)Street c)Id d)Department

    20. A _________ integrity constraint requires that the values appearing in specified attributes of any
    tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced
    relation.

    a) Referencing b)Referential c)Primary d)Specific

    21. Answer the questions based on the table Employee.

    Table: Employee

    a) The cardinality of the table Employee is ......

    i) 5 ii)4 iii)3 iv)6

    b) The degree of the table Employee is .......

    i) 3 ii)4 iii)5 iv)6


    c) Which column can be made as the primary key in the table Employee?

    i) EMPID ii) EMAIL iii) Both i and ii iv) None of the above

    d) If two columns are added to the table Employee, then the cardinality and

    degree of the table is ...... and ...... respectively.

    i) 4 , 7 ii) 7, 4 iii) 6,5 iv) 5,6

    e) State True/False:

    Both EMPID and EMAIL can be defined as primary key in the table Employee.

    i) True ii)False

    22. An attribute in a relation is a foreign key if it is the ________ key in any other

    relation.

    a) Candidate b)Primary c)Super d)Sub

    23. A(n) ________ in a table represents a logical relationship among a set of values.

    a) Column b)Key c)Row d)Attribute

    24. Which of the following attributes can be considered as a choice for the primary

    key?

    a) Name b)Street c)RollNo d)Subject

    You might also like