1. What are the different types of relationships in RDBMS?

A) One to Many

B) One to One

C) One to Multiple

D) A & B

Correct Answer: A & B

Explanation : RDBMS stands for Relational Database Management System and in RDBMS types of relations are One-to-One, One-to-Many/Many-to-One & Many-to-Many.


2. Which one of these is not a RDBMS?

A) MS Access

B) Drupal

C) Oracle

D) MySQL

Correct Answer: Drupal

Explanation : Drupal is an open source web content management system(CMS).


3. Which of the below statements are not true?

A) DBMS creates each table in a file.

B) RDBMS is an operating system

C) RDBMS requires seperate hardware.

D) RDBMS. Oracle MS SQL Server MySQL are different database systems

Correct Answer: RDBMS is an operating system


4. What does an RDBMS consist of?

A) Collection of Tables

B) Collection of Records

C) Collection of Keys

D) Collection of Fields

Correct Answer: Collection of Tables

Explanation : RDBMS consist of Collection of Tables.


5. The degree of a relationship refers to the:

A) Number of entities

B) Maximum cardinality

C) Minimum cardinality

D) Number of attributes in the identifiers

Correct Answer: Number of entities

Explanation : The degree of a relationship refers to the Number of entities.


6. A two-dimensional table of data is called a _____?

A) Group

B) Set

C) Declaration

D) Relation

Correct Answer: Relation

Explanation : A two-dimensional table of data is called a Relation.


7. A relation is analogous to a _____?

A) Field

B) File

C) Row

D) Record

Correct Answer: File

Explanation : A relation is analogous to a File.


8. A domain is atomic if elements of the domain are considered to be ____________ units.

A) Divisible

B) Different

C) Indivisbile

D) Constant

Correct Answer: Indivisbile

Explanation : A domain is atomic if elements of the domain are considered to be Indivisbile units.