Query Maestro - Round 1(Set 2)

20 Questions | Total Attempts: 115

SettingsSettingsSettings
Query Maestro - Round 1(Set 2) - Quiz


Questions and Answers
  • 1. 
    Relational calculus is a 
    • A. 

      Procedural language

    • B. 

      Non-Procedural language

    • C. 

      Data definition language

    • D. 

      High-level language

  • 2. 
    The most commonly used operation in relational algebra for projecting a set of tuple from a relation is 
    • A. 

      Projection

    • B. 

      Join

    • C. 

      Select

    • D. 

      Union

  • 3. 
    A query in the tuple relational calculus is expressed as:
    • A. 

      {t/P(t)}

    • B. 

      {P(t)/t}

    • C. 

      {t/P()/t}

    • D. 

      All the above

  • 4. 
    Is "SELECT * FROM employee" a DML statement?
    • A. 

      True

    • B. 

      False

  • 5. 
    The view of total database content is
    • A. 

      Physical view

    • B. 

      Conceptual view

    • C. 

      External view

    • D. 

      Internal view

  • 6. 
    Cartesian product in relational algebra is
    • A. 

      A Unary operator

    • B. 

      A Binary operator

    • C. 

      A Ternary operator

    • D. 

      Not defined

  • 7. 
    The relational model feature is that there 
    • A. 

      Is no need for primary key data

    • B. 

      Are explicit relationships among records

    • C. 

      Is much more data independence than some other database models

    • D. 

      Are tables with many dimensions

  • 8. 
    Count function in SQL returns the number of 
    • A. 

      Distinct values

    • B. 

      Values

    • C. 

      Groups

    • D. 

      Columns

  • 9. 
    Is " Conceptual design involves modelling independent of the DBMS " true or false?
    • A. 

      True

    • B. 

      False

  • 10. 
    It is possible to define a schema completely using
    • A. 

      VDL and DDL

    • B. 

      SDL and DDL

    • C. 

      VDL and DML

    • D. 

      DDL and DML

  • 11. 
    Data independence means 
    • A. 

      Data is defined separately and not included in programs

    • B. 

      Programs are not dependent on the physical attributes of data

    • C. 

      Programs are not dependent on the logical attributes of data 

    • D. 

      Both 2 and 3

  • 12. 
    The statement in SQL which allows changing the definition of a table is 
    • A. 

      Update

    • B. 

      Alter

    • C. 

      Create

    • D. 

      Select

  • 13. 
    Relational Algebra is 
    • A. 

      Data Definition Language

    • B. 

      Meta Language

    • C. 

      Procedural query Language

    • D. 

      None of the above

  • 14. 
    Key to represent relationship between tables is called
    • A. 

      Primary Key

    • B. 

      Secondary Key

    • C. 

      Candidate Key

    • D. 

      Foreign Key

  • 15. 
    The file organization that provides very fast access to any arbitrary record in a file is
    • A. 

      Hashed file

    • B. 

      Ordered file

    • C. 

      Unordered file

    • D. 

      B-tree

  • 16. 
    Which of the following are the properties of entities?
    • A. 

      Groups

    • B. 

      Table

    • C. 

      Attributes

    • D. 

      Switchboards

  • 17. 
    What is a  relationship called when it is maintained between two entities?
    • A. 

      Unary

    • B. 

      Binary

    • C. 

      Ternary

    • D. 

      Quaternary

  • 18. 
    Which are the two ways in which entities can participate in a relationship?
    • A. 

      Passive and active

    • B. 

      Total and partial

    • C. 

      Simple and complex

    • D. 

      All of the above

  • 19. 
    Which of the following database object does not physically exist?
    • A. 

      Base table

    • B. 

      Index

    • C. 

      Triggers

    • D. 

      View

Back to Top Back to top