DBI202 Practice Test Questions With
100% Accurate Answers 2026/2027
Updated.
Which of following feature is NOT responsibility of Database Management System?
A. Allow users to create new databases and specify their schemas
B. Give users the ability to query the data
C. Support the storage of very large amounts of data
D. Manage user accounts of computer on which DBMS is running - Answer d
Which of following statement is correct?
A. Every relation must have only one primary key
B. Primary key has only one attribute
C. Two tuples can have the same values on primary key's components
D. Super key is a special primary key - Answer a
The database language that is used to query and modify the database is called ____:
A. Data Definition Language
B. Data Manipulation Language
C. Data Control Language
D. All of the others - Answer b
A rule that states that each foreign key value must match a primary key value in other relation is
called the ____
A. Referential integrity constraint
B. Key match rule
C. Foreign/primary match rule
D. Entity key group rule - Answer a
A constraint between two attribute sets in a relation is called ____
,A. Functional relation
B. Attribute dependency
C. Functional dependency
D. Functional relation constraint - Answer c
Which of the following may be used to describe the relationship between two relations?
A. Super key
B. Alternate Key
C. Compose key
D. Foreign key - Answer d
The number of entity sets that participate in a relationship is called the ____
A Identifying characteristic
B. Degree
C. Entity
D. Entity set - Answer b
Suppose relation R(ABCD) with functional dependencies set F={AB, BC, BCD}. Which of
followings is a key of R?
A. A
B. B
C. AB
D. BC - Answer a
Suppose relation R(ABCD) with functional dependencies set F={AB, BC, BCD}. Which of the
highest Normal form of R?
A. 1NF
B. 2NF
C. 3NF
D. BCNF - Answer b
,Given relation R(ABCDE) with functional dependencies set F={AB, BC, BCD, CE}. Compute {B}+
A. {ABCDE}
B. {BCDE}
C. {AB}
D. {CDE} - Answer b
A _______is a set of attributes of a relation whose values can be used to uniquely identify a row
A. Foreign key
B. Super key
C. Alternate Key
D. Compose key - Answer b
A relationship Writes from Authors to Books should be
A. An one - one relationship
B. A many - one relationship
C. An ISA relationship
D. A many - many relationship - Answer d
The normal form which is required every non-key attribute is fully dependent on the primary
key is called
A. 1NF
B. 2NF
C. 3NF
D. BCN - Answer b
Every employee can work in one or more projects and every project has a lot of worked
employees. This relationship is
A. Many to many
B. Many to one
C. One to one
, D. One to many - Answer a
Suppose there are two relations R(A,B,C) and S(E,F), and a referential integrity constraint from
attribute F of S to attribute A of R, where A is a primary key of R. Which of the followings can
violate this constraint?
A. Insert a new tuple to the relation R
B. Insert a new tuple to the relation S
C. Delete an exist tuple from the relation S
D. All of the others - Answer b
Select the right statement
A. Referential integrity constraint is also called foreign key constraint
B. A foreign key in one table points to a PRIMARY KEY in another table
C. A foreign key constraint can be added or deleted using the 'Alter Table' command
D. All of the answers - Answer d
Which of the following terms is NOT a property of a transaction?
A. Security
B. Atomicity
C. Consistency
D. Isolation - Answer a
Select the correct statement
A. The projection operation eliminates duplicated tuples
B. The selection operation always returns a relation has number of tuples equal zero
C. The projection operation always returns a relation has the same schema with the relation
projected
D. All of the others - Answer a
In ERD using Chen notation, the diamond symbol is used to represent an
A. Entity
100% Accurate Answers 2026/2027
Updated.
Which of following feature is NOT responsibility of Database Management System?
A. Allow users to create new databases and specify their schemas
B. Give users the ability to query the data
C. Support the storage of very large amounts of data
D. Manage user accounts of computer on which DBMS is running - Answer d
Which of following statement is correct?
A. Every relation must have only one primary key
B. Primary key has only one attribute
C. Two tuples can have the same values on primary key's components
D. Super key is a special primary key - Answer a
The database language that is used to query and modify the database is called ____:
A. Data Definition Language
B. Data Manipulation Language
C. Data Control Language
D. All of the others - Answer b
A rule that states that each foreign key value must match a primary key value in other relation is
called the ____
A. Referential integrity constraint
B. Key match rule
C. Foreign/primary match rule
D. Entity key group rule - Answer a
A constraint between two attribute sets in a relation is called ____
,A. Functional relation
B. Attribute dependency
C. Functional dependency
D. Functional relation constraint - Answer c
Which of the following may be used to describe the relationship between two relations?
A. Super key
B. Alternate Key
C. Compose key
D. Foreign key - Answer d
The number of entity sets that participate in a relationship is called the ____
A Identifying characteristic
B. Degree
C. Entity
D. Entity set - Answer b
Suppose relation R(ABCD) with functional dependencies set F={AB, BC, BCD}. Which of
followings is a key of R?
A. A
B. B
C. AB
D. BC - Answer a
Suppose relation R(ABCD) with functional dependencies set F={AB, BC, BCD}. Which of the
highest Normal form of R?
A. 1NF
B. 2NF
C. 3NF
D. BCNF - Answer b
,Given relation R(ABCDE) with functional dependencies set F={AB, BC, BCD, CE}. Compute {B}+
A. {ABCDE}
B. {BCDE}
C. {AB}
D. {CDE} - Answer b
A _______is a set of attributes of a relation whose values can be used to uniquely identify a row
A. Foreign key
B. Super key
C. Alternate Key
D. Compose key - Answer b
A relationship Writes from Authors to Books should be
A. An one - one relationship
B. A many - one relationship
C. An ISA relationship
D. A many - many relationship - Answer d
The normal form which is required every non-key attribute is fully dependent on the primary
key is called
A. 1NF
B. 2NF
C. 3NF
D. BCN - Answer b
Every employee can work in one or more projects and every project has a lot of worked
employees. This relationship is
A. Many to many
B. Many to one
C. One to one
, D. One to many - Answer a
Suppose there are two relations R(A,B,C) and S(E,F), and a referential integrity constraint from
attribute F of S to attribute A of R, where A is a primary key of R. Which of the followings can
violate this constraint?
A. Insert a new tuple to the relation R
B. Insert a new tuple to the relation S
C. Delete an exist tuple from the relation S
D. All of the others - Answer b
Select the right statement
A. Referential integrity constraint is also called foreign key constraint
B. A foreign key in one table points to a PRIMARY KEY in another table
C. A foreign key constraint can be added or deleted using the 'Alter Table' command
D. All of the answers - Answer d
Which of the following terms is NOT a property of a transaction?
A. Security
B. Atomicity
C. Consistency
D. Isolation - Answer a
Select the correct statement
A. The projection operation eliminates duplicated tuples
B. The selection operation always returns a relation has number of tuples equal zero
C. The projection operation always returns a relation has the same schema with the relation
projected
D. All of the others - Answer a
In ERD using Chen notation, the diamond symbol is used to represent an
A. Entity
