Home »
MCQs »
DBMS MCQs
RDBMS, DBMS vs RDBMS Multiple-Choice Questions (MCQs) and Answers
RDBMS, DBMS vs RDBMS MCQs: This section contains RDBMS, DBMS vs RDBMS Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on December 15, 2021
1. What does RDBMS stand for?
- Rational Database Management System
- Relational Database Management System
- Rotational Database Management System
- Reasonable Database Management System
Answer: B) Relational Database Management System
Explanation:
The Full form of RDBMS is Relational Database Management System.
Discuss this Question
2. What is an example of RDBMS?
- SQL
- MS SQL Server
- IBM DB2
- All of the above
Answer: D) All of the above
Explanation:
There are various RDBMS such as SQL, MS SQL Server, IBM DB2, My-SQL, Microsoft Access and Oracle.
Discuss this Question
3. What is TRUE about RDBMS?
- Representation of data is done in form of Column.
- Every table contains its own candidate key.
- There is a collection of organized set of tables.
- It is uncommonly used database.
Answer: C) There is a collection of organized set of tables
Explanation:
In the RDBMS, there is a collection of organized set of tables.
Discuss this Question
4. A small entity that contains the specific information of each record in the table is known as ____.
- Row
- Column
- Field
- Record
Answer: C) Field
Explanation:
A small entity that contains the specific information of each record in the table is known as Field.
Discuss this Question
5. Row of table is also called as ____.
- Tuple
- Record
- Column
- Field
Answer: B) Record
Explanation:
Row of table is also called as Record.
Discuss this Question
6. A record is a ____ entity in the table.
- Horizontal
- Vertical
- Header
- Footer
Answer: A) Horizontal
Explanation:
A record is a horizontal entity in the table.
Discuss this Question
7. Column is a ____ entity of the table.
- Horizontal
- Vertical
- Header
- Footer
Answer: B) Vertical
Explanation:
Column is a Vertical entity of the table.
Discuss this Question
8. Column contains all the information that are associated to specific ______in the table.
- Field
- Row
- Record
- Tuple
Answer: A) Field
Explanation:
Column contains all the information that are associated to specific field in the table.
Discuss this Question
9. What does NULL value specify in RDBMS?
- The field is set to Zero
- The field is set to Infinite
- The field is left blank
- The field is set to Whole Number
Answer: C) The field is left blank
Explanation:
Null value specifies that the field is left blank.
Discuss this Question
10. Which of the following comes under the category of Data Integrity in RDBMS?
- Entity
- Domain
- Referential
- All of the above
Answer: D) All of the above
Explanation:
The following categories are there in Data Integrity in RDBMS:
- Entity
- Domain
- Referential
- User-defined
Discuss this Question
11. Which category of data integrity states that no duplicate rows should be there in a table?
- User-defined
- Referential
- Entity
- Domain
Answer: C) Entity
Explanation:
Entity integrity states that no duplicate rows should be there in a table.
Discuss this Question
12. What is TRUE about Referential Integrity?
- It states that rows can't be deleted
- It states that rows can be deleted
- It states that columns can't be deleted
- It states that columns can be deleted
Answer: A) It states that rows can't be deleted
Explanation:
Referential Integrity states that those rows that are used by other records, can't be deleted.
Discuss this Question
13. RDBMS applications stores data ____.
- In tabular form
- As file
- Both a and b
- None of the above
Answer: A) In tabular form
Explanation:
RDBMS applications stores data in tabular form.
Discuss this Question
14. In what format data is stored in DBMS?
- Hierarchal form
- Navigational form
- Both A. and B.
- None of the above
Answer: C) Both A. and B.
Explanation:
Data is stored in both hierarchal or navigational form in DBMS.
Discuss this Question
15. Normalization is not present in ______.
- DBMS
- RDBMS
- Both A. and B.
- None of the above
Answer: A) DBMS
Explanation:
Normalization is not present in DBMS.
Discuss this Question
16. How many integrity constraints are there in RDBMS?
- 3
- 4
- 5
- 6
Answer: B) 4
Explanation:
There are 4 integrity constraints in RDBMS.
Discuss this Question
17. In DBMS –
- There is no relation between the tables
- There is relation between the tables
- There is custom relation between the databases
- There is data value relation between the databases
Answer: B) There is relation between the tables
Explanation:
In DBMS there is relations between the tables.
Discuss this Question
18. Distributed database is supported by –
- RDBMS
- DBMS
- Both RDBMS & DBMS
- Neither RDBMS nor DBMS
Answer: A) RDBMS
Explanation:
Distributed database is supported by RDBMS.
Discuss this Question
19. RDBMS supports ______ users.
- One
- Two
- None
- Multiple
Answer: D) Multiple
Explanation:
RDBMS supports multiple users.
Discuss this Question
20. DBMS deals with _____ amount of data.
- Large
- Small
- Custom
- None
Answer: B) Small
Explanation:
DBMS deals with small amount of data.
Discuss this Question