Welcome to DataBase Quiz, Intermediate Level !!

Question 1. A file produced by a spreadsheet

is generally stored on disk in an ASCII text fromat

can be used as is by the DBMS

both a and b

none of the above

Question 2. Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?

1

2

3

None of the above

Question 3. Which is the make given to the database management system which is able to handle full text data, image data, audio and video?

full media

graphics media

multimedia

hypertext

Question 4. In the DBMS approach, application programs perform the

storage function

processing functions

access control

none of the above

Question 5. What is used by a properly designed DBMS to enable databases to be returned to the pre-transaction state should errors occur?

two phase commit

prefetch transaction

one phase commit

backup and restore

Question 6. What's the maximum value can an INT data type hold?

2,147,483,647

2,147,483,648

4,294,967,295

4,294,967,296

Question 7. What will be the output of the following statement? SELECT CAST(-1 AS SMALLDATETIME)

1900-01-01 00:00:00.000

1899-01-01 00:00:00.000

1752-01-01 00:00:00.000

The system will generate an error

Question 8. A transparent DBMS

can not hide sensitive information from users

keeps its logical structure hidden from users

keeps its physical structure hidden from users

both b and c

Question 9. In JDBC, what represents a single instance of a particular database session?

a thread

an opened connection

a closed connection

a pipe

Question 10. What statement do you use to remove a schema and its related objects from your relational database?

DROP SCHEMA RESTRICT

DROP SCHEMA ALL

DROP SCHEMA CASCADE

DROP SCHEMA OPTS