Welcome to the RDBMS MCQs Page

Dive deep into the fascinating world of RDBMS with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of RDBMS, a crucial aspect of DBMS. In this section, you will encounter a diverse range of MCQs that cover various aspects of RDBMS, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within DBMS.

Check out the MCQs below to embark on an enriching journey through RDBMS. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of DBMS.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of RDBMS. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

RDBMS MCQs | Page 1 of 8

Explore more Topics under DBMS

01

DBMS Basics

02

Data Models

03

The Entity Relationship Approach

04

Relational Databases

05

Data Storage and Querying

06

Relational Algebra

07

Normalization

08

Storage and File Structures

09

Indexing and Hashing

10

Transactions

11

Concurrency Control

12

Recovery System

13

Distributed Databases

14

SQL

15

Data Warehousing and Data Mining

16

Advanced SQL

17

SQL Queries,Constraints and Triggers

Q1.

State true or false: SQL specifies a way of mentioning functional dependencies

True

False

May be

Can't say

Discuss

Answer: (b).False

Q2.

State true or false: Most current database systems do not support constraints on materialized view

True

False

May be

Can't say

Discuss

Answer: (a).True

Q3.

Multi valued dependencies are also called as __________

Equality generating dependencies

Tuple generating dependencies

Multi-purpose dependencies

None of the mentioned

Discuss

Answer: (b).Tuple generating dependencies

Q4.

Functional dependencies are sometimes referred to as ________

Equality generating dependencies

Tuple generating dependencies

Multi-purpose dependencies

None of the mentioned

Discuss

Answer: (a).Equality generating dependencies

Q5.

The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies

Star

Closure

Derivation

Evolution

Discuss

Answer: (b).Closure

Q6.

State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency.

Discuss

Answer: (d).4

Q7.

Which of the following normal forms does not exist?

BCNF

PJNF

5NF

None of the mentioned

Discuss

Answer: (d).None of the mentioned

Q8.

Choose the correct statement regarding superkeys

A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple

A superkey is a tuple or a set of multiple tuples that can uniquely identify an attribute

Every superkey is a candidate key

A superkey is an attribute or a set of attributes that distinguish the relation from other relations

Discuss

Answer: (a).A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple

Q9.

What is an Instance of a Database?

The logical design of the database system

The entire set of attributes of the Database put together in a single relation

The state of the database system at any given point of time

The initial values inserted into the Database immediately after its creation

Discuss

Answer: (c).The state of the database system at any given point of time

Q10.

What is a foreign key?

A foreign key is a primary key of a relation which is an attribute in another relation

A foreign key is a superkey of a relation which is an attribute in more than one other relations

A foreign key is an attribute of a relation that is a primary key of another relation

A foreign key is the primary key of a relation that does not occur anywhere else in the schema

Discuss

Answer: (c).A foreign key is an attribute of a relation that is a primary key of another relation

Page 1 of 8

Welcome to the RDBMS MCQs Page

RDBMS MCQs | Page 1 of 8

Explore more Topics under DBMS

DBMS Basics

Data Models

The Entity Relationship Approach

Relational Databases

Data Storage and Querying

Relational Algebra

Normalization

Storage and File Structures

Indexing and Hashing

Transactions

Concurrency Control

Recovery System

Distributed Databases

SQL

Data Warehousing and Data Mining

Advanced SQL

SQL Queries,Constraints and Triggers

Suggested Topics

Cloud Computing

DBMS

Internet of Things (IoT)

Software Architecture and Design

CSS

HTML

Web Technologies

Computer Hardware

Microprocessor