DBMS Trivia Quiz Questions

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Vivekparashar

Vivekparashar

Community Contributor

Quizzes Created: 1 | Total Attempts: 912

Questions: 5 | Attempts: 914 | Updated: Mar 21, 2023

Settings

Create your own Quiz

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
Correct Answer
D. UPDATE

Explanation
UPDATE is not a data definition language (DDL) command in SQL. DDL commands are used to define or modify the structure of the database, such as creating or altering tables, indexes, and constraints. UPDATE is a data manipulation language (DML) command used to modify the data within the tables, not the structure of the database itself.

Rate this question:
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
Correct Answer
D. All of the above

Explanation
A database management system (DBMS) is designed to eliminate data redundancy by storing data in a centralized location and ensuring that each piece of data is only stored once. It also establishes relationships among records in different files, allowing for efficient data retrieval and analysis. Additionally, a DBMS manages file access by controlling who can access and manipulate the data stored in the database. Therefore, all of the given options are correct as they describe the main purposes and functions of a DBMS.

Rate this question:
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
Correct Answer
A. SELECT DISTINCT

Explanation
The SELECT DISTINCT command is used in SQL to select only one copy of each set of duplicable rows. This means that it will eliminate any duplicate rows in the result set, ensuring that each row is unique. The other options, SELECT UNIQUE and SELECT DIFFERENT, are not valid SQL commands and therefore are not the correct answer.

Rate this question:
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
Correct Answer
A. Super Key

Explanation
A super key is a set of one or more attributes that can uniquely identify a record in a database. It may contain extra attributes that are not necessary for uniqueness. In other words, a super key is a superset of a candidate key. Therefore, a super key is the correct answer as it satisfies the condition of uniquely identifying a record.

Rate this question:

1
0
5.

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

Explanation
The attribute "ID" can be taken as a primary key because it is likely to be a unique identifier for each record in the database. Primary keys are used to uniquely identify each record in a table, and it is important for them to have unique values to ensure data integrity and avoid duplication. The attributes "Name", "Street", and "Department" are not suitable as primary keys because they are not guaranteed to be unique for each record.

Rate this question:

DBMS Trivia Quiz Questions

In SQL, which of the following is not a data definition language commands?

Database management systems are intended to

In SQL, which command is used to select only one copy of each set of duplicable rows

Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

Which one of the following attribute can be taken as a primary key?