All Questions

Introduction to RDBMS – Basics, advantages, and components.

MCQ Question 1 of 10

What does RDBMS stand for?

Relational Database Management SystemRandom Database Management SystemReal-time Data Management SystemRelational Data Model Software

Which feature differentiates RDBMS from DBMS?

Data stored in flat filesSupport for relationships using tablesLack of primary key conceptNo data integrity support

Which of the following is not an advantage of RDBMS?

Data redundancy reductionData consistencyComplex data relationships handlingNo need for normalization

Which of these is a component of RDBMS?

TablesQueriesReportsAll of the above

What is the role of a primary key in RDBMS?

To allow duplicate valuesTo uniquely identify each recordTo store null valuesTo define foreign keys

In RDBMS, a foreign key is used to:

Create duplicate recordsEstablish relationship between two tablesDelete rows automaticallyStore multiple data types

Which language is mainly used to interact with RDBMS?

HTMLSQLC++XML

Which type of integrity ensures that a foreign key must match a primary key in another table?

Entity IntegrityReferential IntegrityDomain IntegrityUser Integrity

Which of the following is an example of RDBMS software?

MySQLOraclePostgreSQLAll of the above

Why is normalization used in RDBMS?

To increase redundancyTo reduce redundancy and improve data integrityTo speed up queries onlyTo allow null primary keys