Free Mock Test : DBMS (Database Management System) : Relational Data Model (Test 1)

Home

Technology

Blog

Free Mock Test - DBMS (Database Management System) : Relational Data Model (Test 1)

In recent trends across major competitive and officer-level examinations, the topic DBMS (Database Management System)—particularly the Relational Data Model—has emerged as a high-weightage and concept-driven area. Exams such as banking, SSC, railways, and various technical officer recruitments are increasingly testing candidates on both theoretical understanding and practical application of relational database concepts.

Total Questions : 25

Timer : sec

Question : Which operation in the relational model may cause issues if foreign key constraints are involved?

Insertion

Deletion

Retrieval

Projection

Question : Which of the following key types is formed when multiple attributes together uniquely identify a tuple?

Foreign Key

Candidate Key

Composite Key

Alternate Key

Question : In a relational model, which property ensures that each cell contains only a single value?

Referential Integrity

Atomicity of attributes

Domain constraint

Cardinality constraint

Question : Which of the following statements about a domain is correct?

It defines the number of tuples in a relation

It is the set of all possible values an attribute can take

It uniquely identifies a tuple

It represents a row in a relation

Question : Which of the following correctly defines the degree of a relation?

Number of tuples in a relation

Number of attributes in a relation

Number of domains in a relation

Number of keys in a relation

Question : Which of the following is a unary operation in relational algebra?

Cartesian Product

Union

Selection

Join

Question : Which operation is best suited for queries involving “for all” conditions?

Join

Division

Projection

Intersection

Question : For two relations R and S to be union compatible, which condition must hold?

Same number of tuples

Same attribute names only

Same degree and compatible domains

Same primary key

Question : Which relational algebra operation is used to retrieve tuples that satisfy a given condition?

Projection (π)

Selection (σ)

Join (⨝)

Division (÷)

Question : Which of the following operations is NOT necessarily commutative in relational algebra?

Union (∪)

Intersection (∩)

Cartesian Product (×)

Set Difference (−)

Question : Which of the following statements is TRUE regarding RIGHT OUTER JOIN?

It returns only matched tuples

It returns all tuples from the left table

It returns all tuples from the right table and matched from the left

It eliminates NULL values

Question : What is the key characteristic of a NATURAL JOIN?

Uses inequality operators

Requires explicit join condition

Matches tuples based on common attribute names automatically

Produces Cartesian product

Question : Which join is based strictly on equality condition (=) between attributes?

Natural Join

Equi Join

Full Join

Cross Join

Question : In a LEFT OUTER JOIN, what happens to tuples in the left table with no matching tuple in the right table?

They are discarded

They appear with NULL values for right table attributes

They are duplicated

They are matched randomly

Question : Which join returns all tuples from both relations including unmatched tuples?

Natural Join

Left Outer Join

Full Outer Join

Equi Join

Question : Which of the following best describes a domain constraint?

Ensures relationships between tables remain valid

Ensures values in a column follow a defined data type or range

Ensures primary key uniqueness

Prevents duplicate tuples in a relation

Question : Which statement is TRUE regarding primary key vs unique key?

Both allow NULL values

Primary key allows duplicates, unique key does not

Unique key can allow NULL values, primary key cannot

Both must be defined at table level only

Question : Which of the following is NOT a valid category of integrity constraint in DBMS?

Domain constraint

Entity integrity

Functional constraint

Referential integrity

Question : Which constraint ensures that a value in one table must match a value in another table or be NULL?

Domain constraint

Key constraint

Referential integrity constraint

Entity integrity constraint

Question : Which of the following situations violates entity integrity constraint?

A foreign key references a non-existing value

A primary key contains duplicate values

A primary key contains NULL values

A non-key attribute contains NULL values

Question : Which of the following best describes Relational Calculus?

It specifies how to retrieve data step-by-step

It is based on procedural logic

It specifies what data is required, not how to retrieve it

It is only used in relational algebra

Question : Which of the following queries expresses existential quantification correctly?

{ t | ∀u (R(u) → t.A = u.A) }

{ t | ∃u (R(u) ∧ t.A = u.A) }

{ t | t.A = ∀u }

{ t | R(t) → ∃ }

Question : Which statement best distinguishes Domain Relational Calculus (DRC) from Tuple Relational Calculus (TRC)?

DRC uses tuples, TRC uses attributes

DRC uses domain variables, TRC uses tuple variables

DRC is procedural, TRC is non-procedural

DRC cannot use quantifiers

Question : In Tuple Relational Calculus (TRC), a variable is said to be bound when:

It appears in the result set

It is associated with a relation

It is quantified using ∀ or ∃

It is part of projection

Question : Which of the following correctly represents a safe TRC expression?

{ t | ¬R(t) }

{ t | t ∈ R ∧ t.A > 5 }

{ t | t.A > 5 }

{ t | ∀t ∈ R (t.A > 5) }

About us

Term & conditions

Privacy & Policy

Free Mock Test - DBMS (Database Management System) : Relational Data Model (Test 1)

Cookies & Disclaimer