Trivia Quiz On Database Management System

10 Questions | Total Attempts: 187

SettingsSettingsSettings
Please wait...
Trivia Quiz On Database Management System

.


Related Topics
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