DBMS Trivia Quiz Questions

5 Questions | By Vivekparashar | Updated: Mar 21, 2022 | Attempts: 887

This trivia quiz is made up of DBMS questions that are specific to help you through your revision. This software is generally used to ease access to data and allows people to update some data too. There are different types of data in use currently, and the quiz below is perfect to see how much you understand them and their uses. Give it a shot!

Questions and Answers

1.

In SQL, which of the following is not a data definition language commands?
- A.
  
  RENAME
- B.
  
  REVOKE
- C.
  
  GRANT
- D.
  
  UPDATE
2.

Database management systems are intended to
- A.
  
  Eliminate data redundancy
- B.
  
  Establish relationships among records in different files
- C.
  
  Manage file access
- D.
  
  All of the above
3.

In SQL, which command is used to select only one copy of each set of duplicable rows
- A.
  
  SELECT DISTINCT
- B.
  
  SELECT UNIQUE
- C.
  
  SELECT DIFFERENT
- D.
  
  None of the above
4.

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?
- A.
  
  Super Key
- B.
  
  Candidate Key
- C.
  
  Sub Key
- D.
  
  Foreign Key
5.

Which one of the following attribute can be taken as a primary key?
- A.
  
  Name
- B.
  
  Street
- C.
  
  ID
- D.
  
  Department