DATABASE MANAGEMENT SYSTEMS
(DBMS) EXAM QUESTIONS AND
ANSWERS PLUS RATIONALES|| LATEST
UPDATE 2026
What rough shape does a hierarchical database take?
1. A circle
2. A pyramid
3. A rectangle
4. A web
Hierarchical databases start narrow and spread out, like a pyramid. Hierarchical
databases start narrow and spread out, like a pyramid.Hierarchical databases start
narrow and spread out, like a pyramid.
What best describes the structure of a relational database?
1. A pyramid
2. A flag pole
3. An arch
4. A spider web
A spider web. A spider web. A spider web. A spider web
Why is a relational database useful in government intelligence?
1. It knows everything.
2. Only a few people can use them.
3. It limits who can see what information.
,4. They can hold more than other databases.
It limits who can see what information.
It limits who can see what information.
It limits who can see what information.
It limits who can see what information.
It limits who can see what information.
Which of these would be a logical use for a hierarchical database?
1. Organizing books by genre, then author
2. Organizing books by preference among several readers
3. Organizing product orders alongside inventory
4. A hierarchical database works for any collection of data
Organizing books by genre, then author.
Organizing books by genre, then author.
Organizing books by genre, then author.
Organizing books by genre, then author.
Organizing books by genre, then author.
How can the following table be changed to first normal form?
https://study.com/cimages/multimages/16/1nf_q3.png
1. Nothing; it is already 1NF
2. Remove the Part_Name field
3. Add a primary key
4. Remove the extra Color field
Remove the extra Color field.
, Which of the following is true about a database table?
1. It must contain at least one row, or tuple
2. It can contain zero tuples
3. Each field in a tuple must always contain data
4. All rows must be in alphabetical order to be considered a table
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
Which table is in first normal form (1NF)?
https://study.com/cimages/multimages/16/1nf_q4_a3.png
Look at the pic for the answer!
Under schema theory, knowledge is organized into _____.
1. Rows
2. Databases
3. Units
4. Tables
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
(DBMS) EXAM QUESTIONS AND
ANSWERS PLUS RATIONALES|| LATEST
UPDATE 2026
What rough shape does a hierarchical database take?
1. A circle
2. A pyramid
3. A rectangle
4. A web
Hierarchical databases start narrow and spread out, like a pyramid. Hierarchical
databases start narrow and spread out, like a pyramid.Hierarchical databases start
narrow and spread out, like a pyramid.
What best describes the structure of a relational database?
1. A pyramid
2. A flag pole
3. An arch
4. A spider web
A spider web. A spider web. A spider web. A spider web
Why is a relational database useful in government intelligence?
1. It knows everything.
2. Only a few people can use them.
3. It limits who can see what information.
,4. They can hold more than other databases.
It limits who can see what information.
It limits who can see what information.
It limits who can see what information.
It limits who can see what information.
It limits who can see what information.
Which of these would be a logical use for a hierarchical database?
1. Organizing books by genre, then author
2. Organizing books by preference among several readers
3. Organizing product orders alongside inventory
4. A hierarchical database works for any collection of data
Organizing books by genre, then author.
Organizing books by genre, then author.
Organizing books by genre, then author.
Organizing books by genre, then author.
Organizing books by genre, then author.
How can the following table be changed to first normal form?
https://study.com/cimages/multimages/16/1nf_q3.png
1. Nothing; it is already 1NF
2. Remove the Part_Name field
3. Add a primary key
4. Remove the extra Color field
Remove the extra Color field.
, Which of the following is true about a database table?
1. It must contain at least one row, or tuple
2. It can contain zero tuples
3. Each field in a tuple must always contain data
4. All rows must be in alphabetical order to be considered a table
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
A database table can contain zero or more rows, or tuples.
Which table is in first normal form (1NF)?
https://study.com/cimages/multimages/16/1nf_q4_a3.png
Look at the pic for the answer!
Under schema theory, knowledge is organized into _____.
1. Rows
2. Databases
3. Units
4. Tables
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
Under schema theory, knowledge is organized into units.
