Quiz : How Well Do You Know About Relational Database?

10 Questions | By Chawk2505 | Updated: Sep 21, 2022 | Attempts: 9149

Questions

Settings

Quiz : How Well Do You Know About Relational Database? - Quiz

Are you aware of relational databases? By taking our fun quiz, can you tell us just how well you know about relational databases? Our quiz is designed to help you understand how databases holding the same information are structured and maintained. Do you think you have what it takes to tackle it based on what you have learned? Then press the start button and see how well you will do in this quiz. All the best!

Questions and Answers

1.

Which of the following makes it possible for entities to share a relationship?
- A.
  
  Multi-valued attributes
- B.
  
  A foreign key
- C.
  
  A common attribute
- D.
  
  The same number of attributes
2.

A database contains the fields Pupil_no and Pupil_name. If we are given the Pupil_no then we will know Pupil_name. This means that:
- A.
  
  Pupil_name has a functionality with Pupil_ID
- B.
  
  Pupil_ID is functionally dependent on Pupil_name
- C.
  
  Pupil_name is functionally dependent on Pupil_ID
- D.
  
  These two attributes have a relationship
3.

What is the purpose of an indexed field in a database?
- A.
  
  To speed up queries
- B.
  
  To verify values
- C.
  
  To create links between entities
- D.
  
  To specify a lookup
4.

The requirement that each entity much have a unique primary key where the value of that primary key is not null, is known as the
- A.
  
  Entity Integrity Rule
- B.
  
  Referential Integrity Rule
- C.
  
  Entity-Relationship Rule
- D.
  
  Validation Index
5.

If there are multiple occurrences of attributes for a single value of a primary key, this is known as a ______________ group.
6.

Which of the following is TRUE about referential integrity rule?
- A.
  
  Each primary key much be unique and not null
- B.
  
  For each foreign key, there must be a corresponding primary key
- C.
  
  Repeating groups are not permitted.
- D.
  
  All attributes must have meaningful names.
7.

The frequency of a relationship between entities may be described by
- A.
  
  Indexed fields
- B.
  
  Transitive dependencies
- C.
  
  Cardinality
- D.
  
  Referential integrity
8.

Consider the following entity:CAR_RENTAL(Car_Reg, Make, Model, Driver_Name, Date_Hired, Date_Returned)Which of the following would be included in a repeating group?
- A.
  
  Car_Reg
- B.
  
  Make
- C.
  
  Driver_name
- D.
  
  Model
9.

Which of the following is TRUE about relational database design?
- A.
  
  The order of attributes is critical.
- B.
  
  Each column must be unique.
- C.
  
  No row should be duplicated.
- D.
  
  All tables must contain a foreign key.
10.

Majority of relational database system employ which language
- A.
  
  C#
- B.
  
  Java
- C.
  
  SQL
- D.
  
  All of the above