Trivia Quiz On Database Management System

10 Questions | By Ashishdoorwar96 | Updated: Mar 21, 2022 | Attempts: 294

Questions

Settings

Trivia Quiz On Database Management System - Quiz

Welcome to the trivia quiz on database management system. Over the past few days we have been able to dive deeper into the data base. A data base is made of different components and each of them has a specific responsibility in order to meet a user’s responsibility. Take up the quiz and get to see just how much you got to understand. All the best!

Questions and Answers

1.

Which of the following is not the responsibility of the utilities component of DBMS software?
- A.
  
  Creating the physical and logical designs
- B.
  
  Removing flagged records for deletion
- C.
  
  Creating and maintaining the data dictionary
- D.
  
  Monitoring performance
2.

A report generator is used to
- A.
  
  Update files.
- B.
  
  Print files on paper.
- C.
  
  Data entry.
- D.
  
  Delete files.
3.

Count function in SQL returns the number of
- A.
  
  Values.
- B.
  
  Distinct values.
- C.
  
  groups.
- D.
  
  Columns.
4.

The statement in SQL which allows to change the definition of a table is
- A.
  
  Alter.
- B.
  
  Update.
- C.
  
  Create.
- D.
  
  Select.
5.

DBMS helps achieve
- A.
  
  Data independence
- B.
  
  Centralized control of data
- C.
  
  Neither (A) nor (B)
- D.
  
  Both (A) and (B)
6.

Which of the following are the properties of entities?
- A.
  
  Groups
- B.
  
  Table
- C.
  
  Attributes
- D.
  
  Switchboards
7.

The RDBMS terminology for a row is
- A.
  
  Tuple.
- B.
  
  Relation.
- C.
  
  Attribute.
- D.
  
  Degree.
8.

The full form of DDL is
- A.
  
  Dynamic Data Language
- B.
  
  Detailed Data Language
- C.
  
  Data Definition Language
- D.
  
  Data Derivation Language
9.

Which of the following is a legal expression in SQL?
- A.
  
  SELECT NULL FROM EMPLOYEE;
- B.
  
  SELECT NAME FROM EMPLOYEE;
- C.
  
  SELECT NAME FROM EMPLOYEE WHERE SALARY = NULL;
- D.
  
  None of the above
10.

The result of the UNION operation between R1 and R2 is a relation that includes
- A.
  
  All the tuples of R1
- B.
  
  All the tuples of R2
- C.
  
  All the tuples of R1 and R2
- D.
  
  All the tuples of R1 and R2 which have common columns