Database Management Using SQL

1. Which of the following is valid SQL for an Index?

CREATE INDEX ID;

CHANGE INDEX ID;

ADD INDEX ID;

REMOVE INDEX ID;

2. Which of the following is not a property of transactions?

Atomicity

Concurrency

Isolation

Durability

3. Tree structures are used to store data in

Network model.

Relational model.

Hierarchical model.

File based system.

4. 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

5. 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.

6. ON UPDATE CASCADE ensures which of the following?

Normalization

Data Integrity

Materialized Views

All of the above.

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

Monday

Wednesday

Thursday

Sunday

8. 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

9. The SQL keyword BETWEEN is used:

For ranges.

To limit the columns displayed.

As a wildcard.

None of the above is correct.

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

145°

150°

155°

160°

11. 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

12. 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

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

3

4

5

6

14. 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

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

LIKE only

IN only

NOT IN only

IN and NOT IN

16. 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');

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

2NF

3NF

BCNF

1NF

18. 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.

19. 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

20. DROP is a ______________ statement in SQL.

Query

Embedded SQL

DDL

DCL