Database Management Using SQL

20 Questions | Total Attempts: 12

SettingsSettingsSettings
Please wait...
Database Management Using SQL

.


Questions and Answers
  • 1. 
    Which of the following is not a property of transactions?
    • A. 

      Atomicity

    • B. 

      Concurrency

    • C. 

      Isolation

    • D. 

      Durability

  • 2. 
    Tree structures are used to store data in
    • A. 

      Network model.

    • B. 

      Relational model.

    • C. 

      Hierarchical model.

    • D. 

      File based system.

  • 3. 
    A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other composite key.
    • A. 

      2NF

    • B. 

      3NF

    • C. 

      BCNF

    • D. 

      1NF

  • 4. 
    What is data integrity?
    • A. 

      It is the data contained in database that is non redundant.

    • B. 

      It is the data contained in database that is accurate and consistent.

    • C. 

      It is the data contained in database that is secured.

    • D. 

      It is the data contained in database that is shared.

  • 5. 
    In SQL the statement select * from R, S is equivalent to
    • A. 

      Select * from R natural join S.

    • B. 

      Select * from R cross join S.

    • C. 

      Select * from R union join S.

    • D. 

      Select * from R inner join S.

  • 6. 
    A train passes a station platform in 36 seconds and a man standing on the platform in 20 seconds. If the speed of the train is 54 km/hr, what is the length of the platform?
    • A. 

      120 m

    • B. 

      240 m

    • C. 

      300 m

    • D. 

      None of these

  • 7. 
    A person crosses a 600 m long street in 5 minutes. What is his speed in km per hour?
    • A. 

      3.6

    • B. 

      7.2

    • C. 

      8.4

    • D. 

      10

  • 8. 
    DROP is a ______________ statement in SQL.
    • A. 

      Query

    • B. 

      Embedded SQL

    • C. 

      DDL

    • D. 

      DCL

  • 9. 
    Which of the following ensures the atomicity of the transaction?
    • A. 

      Transaction management component of DBMS

    • B. 

      Application Programmer

    • C. 

      Concurrency control component of DBMS

    • D. 

      Recovery management component of DBMS

  • 10. 
    A vendor bought toffees at 6 for a rupee. How many for a rupee must he sell to gain 20%?
    • A. 

      3

    • B. 

      4

    • C. 

      5

    • D. 

      6

  • 11. 
    ON UPDATE CASCADE ensures which of the following?
    • A. 

      Normalization

    • B. 

      Data Integrity

    • C. 

      Materialized Views

    • D. 

      All of the above.

  • 12. 
    Which of the following is valid SQL for an Index?
    • A. 

      CREATE INDEX ID;

    • B. 

      CHANGE INDEX ID;

    • C. 

      ADD INDEX ID;

    • D. 

      REMOVE INDEX ID;

  • 13. 
    A is thrice as good as workman as B and therefore is able to finish a job in 60 days less than B. Working together, they can do it in:
    • A. 

      20 days

    • B. 

      22.5 days

    • C. 

      25 days

    • D. 

      30 days

  • 14. 
    The SQL keyword(s) ________ is used with wildcards.
    • A. 

      LIKE only

    • B. 

      IN only

    • C. 

      NOT IN only

    • D. 

      IN and NOT IN

  • 15. 
    January 1, 2008 is Tuesday. What day of the week lies on Jan 1, 2009?
    • A. 

      Monday

    • B. 

      Wednesday

    • C. 

      Thursday

    • D. 

      Sunday

  • 16. 
    Which of the following are the five built-in functions provided by SQL?
    • A. 

      COUNT, SUM, AVG, MAX, MIN

    • B. 

      SUM, AVG, MIN, MAX, MULT

    • C. 

      SUM, AVG, MULT, DIV, MIN

    • D. 

      SUM, AVG, MIN, MAX, NAME

  • 17. 
    Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'
    • A. 

      SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

    • B. 

      SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

    • C. 

      SELECT NAME IN CUSTOMER WHERE STATE = 'V';

    • D. 

      SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

  • 18. 
    The SQL keyword BETWEEN is used:
    • A. 

      For ranges.

    • B. 

      To limit the columns displayed.

    • C. 

      As a wildcard.

    • D. 

      None of the above is correct.

  • 19. 
     A clock is started at noon. By 10 minutes past 5, the hour hand has turned through:
    • A. 

      145°

    • B. 

      150°

    • C. 

      155°

    • D. 

      160°

  • 20. 
    Introducing a woman, Shashank said, "She is the mother of the only daughter of my son." How that woman is related to Shashank?
    • A. 

      Daughter

    • B. 

      Sister-in-law

    • C. 

      Wife

    • D. 

      Daughter-in-law

Back to Top Back to top