Query Maestro - Round 1(Set 1)

20 Questions | Total Attempts: 116

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

.


Questions and Answers
  • 1. 
    What does SQL stand for?
    • A. 

      Structured Question Language

    • B. 

      Strong Question Language

    • C. 

      Structured Query Language

    • D. 

      String Query Language

  • 2. 
    Using which language can a user request information from a database?
    • A. 

      Relational

    • B. 

      Structural

    • C. 

      Compiler

    • D. 

      Query

  • 3. 
    -To remove a relation from an SQL database, we use the ____ command.
    • A. 

      Delete

    • B. 

      Remove

    • C. 

      Drop table

    • D. 

      Purge

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

      Foreign Key

    • B. 

      Primary Key

    • C. 

      Super Key

    • D. 

      Secondary key

  • 5. 
    In the ______ normal form, a composite attribute is converted to individual attributes.
    • A. 

      First

    • B. 

      Second

    • C. 

      Third

    • D. 

      Fourth

  • 6. 
    Which of the following is not Armstrong's Axiom?
    • A. 

      Transitivity rule

    • B. 

      Pseudotransitivity rule

    • C. 

      Reflexive rule

    • D. 

      Augmentation rule

  • 7. 
    An entity set that does not have sufficient attributes to form a primary key is termed as _____.
    • A. 

      Strong entity set

    • B. 

      Variant set

    • C. 

      Weak entity set

    • D. 

      Variable set

  • 8. 
    In SQL the spaces at the end of the string are removed by ______ function.
    • A. 

      Upper

    • B. 

      Lower

    • C. 

      String

    • D. 

      Trim

  • 9. 
    Student(ID, name, dept, name, tot_cred) In this query which attribute form the primary key?
    • A. 

      Name

    • B. 

      ID

    • C. 

      Tot_cred

    • D. 

      Dept

  • 10. 
    The tuples of the relations can be of  ______ order.
    • A. 

      Same

    • B. 

      Sorted

    • C. 

      Any

    • D. 

      Constant

  • 11. 
    A domain is atomic if elements of the domain are considered to be ______units.
    • A. 

      Different

    • B. 

      Indivisible

    • C. 

      Constant

    • D. 

      Divisible

  • 12. 
    Course(course_id, sec_id, semester) Here the course_id, sec_id and semester are _______ and course is a______.
    • A. 

      Relations,Attribute

    • B. 

      Tuple,Relation

    • C. 

      Attributes, Relation

    • D. 

      Tuple, Attributes

  • 13. 
    Database ________ which is the logical design of the database, and the database _____which is a snapshot of the data in the database at a given instant of time.
    • A. 

      Instance, Schema

    • B. 

      Relation, Schema

    • C. 

      Relation, Domain

    • D. 

      Schema, Instance

  • 14. 
    For each attribute of a relation, there is a set of permitted values, called the _____of the attribute.
    • A. 

      Relation

    • B. 

      Domain

    • C. 

      Set

    • D. 

      Schema

  • 15. 
    A relational database consists of a collection of 
    • A. 

      Records

    • B. 

      Tables

    • C. 

      Fields

    • D. 

      Keys

  • 16. 
    A ________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
    • A. 

      Triggers

    • B. 

      Functions

    • C. 

      Procedures

    • D. 

      None of the above

  • 17. 
    The DROP TABLE statement :
    • A. 

      Deletes the table structure only

    • B. 

      Works whether or not referential integrity constraints would be violated

    • C. 

      Deletes the table structure along with the table data

    • D. 

      Is not an SQL statement

  • 18. 
    Which of the following indicates the maximum number of entities that can be involved in a relationship?
    • A. 

      Greater Entity Count(GEC)

    • B. 

      Minimum cardinality

    • C. 

      ERD

    • D. 

      Maximum cardinality

  • 19. 
    With SQL, how do you select all the columns from a table named "Persons"?
    • A. 

      SELECT [all] FROM PERSONS

    • B. 

      SELECT * FROM Persons

    • C. 

      SELECT *.Persons

    • D. 

      SELECT Persons

  • 20. 
    With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
    • A. 

      SELECT * FROM Persons ORDER FirstName DESC

    • B. 

      SELECT * FROM Persons SORT 'FirstName' DESC

    • C. 

      SELECT * FROM Persons ORDER BY FirstName DESC

    • D. 

      SELECT * FROM Persons SORT BY 'FirstName' DESC

Back to Top Back to top