Database Management Using SQL

20 Questions | Attempts: 25
Share
SettingsSettings
Please wait...
  • 1/20 Questions

    Which of the following is not a property of transactions?

    • Atomicity
    • Concurrency
    • Isolation
    • Durability
Please wait...
About This Quiz

.

Database Management Using SQL - Quiz

Quiz Preview

  • 2. 

    Tree structures are used to store data in

    • Network model.

    • Relational model.

    • Hierarchical model.

    • File based system.

    Correct Answer
    A. Hierarchical model.
  • 3. 

    In SQL the statement select * from R, S is equivalent to

    • Select * from R natural join S.

    • Select * from R cross join S.

    • Select * from R union join S.

    • Select * from R inner join S.

    Correct Answer
    A. Select * from R cross join S.
  • 4. 

    Which of the following is valid SQL for an Index?

    • CREATE INDEX ID;

    • CHANGE INDEX ID;

    • ADD INDEX ID;

    • REMOVE INDEX ID;

    Correct Answer
    A. CREATE INDEX ID;
  • 5. 

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

    • Daughter

    • Sister-in-law

    • Wife

    • Daughter-in-law

    Correct Answer
    A. Daughter-in-law
  • 6. 

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

    • 3.6

    • 7.2

    • 8.4

    • 10

    Correct Answer
    A. 7.2
  • 7. 

    ON UPDATE CASCADE ensures which of the following?

    • Normalization

    • Data Integrity

    • Materialized Views

    • All of the above.

    Correct Answer
    A. Data Integrity
  • 8. 

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

    • Monday

    • Wednesday

    • Thursday

    • Sunday

    Correct Answer
    A. Thursday
  • 9. 

    Which of the following are the five built-in functions provided by SQL?

    • COUNT, SUM, AVG, MAX, MIN

    • SUM, AVG, MIN, MAX, MULT

    • SUM, AVG, MULT, DIV, MIN

    • SUM, AVG, MIN, MAX, NAME

    Correct Answer
    A. COUNT, SUM, AVG, MAX, MIN
  • 10. 

    The SQL keyword BETWEEN is used:

    • For ranges.

    • To limit the columns displayed.

    • As a wildcard.

    • None of the above is correct.

    Correct Answer
    A. For ranges.
  • 11. 

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

    • 145°

    • 150°

    • 155°

    • 160°

    Correct Answer
    A. 155°
  • 12. 

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

    • 2NF

    • 3NF

    • BCNF

    • 1NF

    Correct Answer
    A. 3NF
  • 13. 

    What is data integrity?

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

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

    • It is the data contained in database that is secured.

    • It is the data contained in database that is shared.

    Correct Answer
    A. It is the data contained in database that is accurate and consistent.
  • 14. 

    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?

    • 120 m

    • 240 m

    • 300 m

    • None of these

    Correct Answer
    A. 240 m
  • 15. 

    DROP is a ______________ statement in SQL.

    • Query

    • Embedded SQL

    • DDL

    • DCL

    Correct Answer
    A. DDL
  • 16. 

    Which of the following ensures the atomicity of the transaction?

    • Transaction management component of DBMS

    • Application Programmer

    • Concurrency control component of DBMS

    • Recovery management component of DBMS

    Correct Answer
    A. Transaction management component of DBMS
  • 17. 

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

    • 3

    • 4

    • 5

    • 6

    Correct Answer
    A. 5
  • 18. 

    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:

    • 20 days

    • 22.5 days

    • 25 days

    • 30 days

    Correct Answer
    A. 22.5 days
  • 19. 

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

    • LIKE only

    • IN only

    • NOT IN only

    • IN and NOT IN

    Correct Answer
    A. LIKE only
  • 20. 

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

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

    • SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

    • SELECT NAME IN CUSTOMER WHERE STATE = 'V';

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

    Correct Answer
    A. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

Quiz Review Timeline (Updated): Mar 15, 2022 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 15, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • May 09, 2020
    Quiz Created by
    Prasad Mutkule
Back to Top Back to top
Advertisement