Trivia Quiz On Database Management System
Settings
.
- 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
Back to top