Quiz  /  PostgreSQL Class 12 MCQ Questions With Answers

  • 1. 
    DDL commands are:-

  • DROP
  • CREATE
  • DELETE
  • Both A & B

  • 2. 
    Pattered matching in SELECT command can be done using:-

  • _
  • %
  • &
  • Both A & B

  • 3. 
    A key which allows unique or null values.

  • Unique
  • Null key
  • Primary key
  • Alternate key

  • 4. 
    Expand DML

  • Data mapping language
  • data multi language
  • data manipulation language
  • data model language

  • 5. 
    Delete * from empl;

  • Deletes all tuples.
  • updates the table emp with null.
  • Destroys the table.

  • 6. 
    TCL commands are:-

  • ROLLBACK
  • GRANT
  • REVOKE
  • All of above

  • 7. 
    View is a virtual table created from the existing table

  • false
  • true

  • 8. 
    Expand DDL

  • Data declaration language
  • DATA DOCUMENT LANGUAGE
  • definition data language
  • DATA DEFINITION LANGUAGE

  • 9. 
    Examples of DBMS software are:-

  • MySQL
  • ORACLE
  • FOXPRO
  • All of above

  • 10. 
    DML commands are:-

  • INSERT
  • UPDATE
  • DELETE
  • All of above

  • 11. 
    Degree ? cardinality ?

  • 5 11
  • 4 10
  • 4 11
  • 5 10

  • 12. 
    Uniquely identifies the record ,includes NULL also

  • primary key
  • unique key
  • candidate key
  • alternate key
Report Question
warning
access_time
  Time