Scribd
Upload
29 views3 pages

RDBMS Worksheet: Key Concepts and MCQs

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.

Uploaded by

Kailash Kandhasamy G
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
29 views3 pages

RDBMS Worksheet: Key Concepts and MCQs

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.

Uploaded by

Kailash Kandhasamy G
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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

Common questions

Powered by AI

Referential integrity is a rule that ensures relationships between records in related tables remain valid . It 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 .

Cardinality is the total number of rows in a table, while degree refers to the total number of columns in a table .

Redundancy is considered a disadvantage because it leads to data inconsistency and can increase storage costs . In a file processing system, redundancy is a disadvantage as it contributes to data isolation and inconsistency .

A relational database organizes data as a collection of tables and supports data integrity and reduces redundancy and inconsistency compared to file processing systems, which are prone to data redundancy, isolation, and inconsistency .

Data constraints define valid data to prevent incorrect, null, or irrelevant entries, enhancing data integrity by ensuring accuracy, consistency, and reliability within the database . They enforce rules, such as primary key and foreign key constraints, to maintain structural reliability.

Metadata, or data about data, provides necessary information about other data, aiding in understanding, maintenance, and efficiency of data operations . It is crucial for managing and using data, ensuring it is correctly understood and manipulated.

If two columns are added to the table, the cardinality remains the same but the degree increases by two because the number of columns (degree) increases, while the number of rows (cardinality) does not change .

An attribute suitable to be a primary key should uniquely identify each tuple/row of the table, such as ID numbers . It must not permit null values and should remain stable, meaning its value cannot change over time.

The relational data model organizes data into tables with relationships enforced through keys, reducing redundancy by eliminating duplicate data and inconsistency by updating single data points across the database .

A foreign key is an attribute in a relation that is a primary key in another relation . It establishes and enforces a link between the data in two tables, ensuring that data remains consistent across those tables.

You might also like