Welcome to DataBase Quiz, Intermediate Level !!

Question 1. 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

Question 2. Which of the following correctly describe the sequence of the DBMS operational process?

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS intercepts the request DBMS presents the request to the user.

User issues request -> DBMS intercepts the request DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user.

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user DBMS intercepts the request.

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. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Question 5. 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 6. The language used by application programs to request data from the DBMS is referred to as the

DML

DDL

query language

none of the above

Question 7. 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 8. Which of the following is NOT a valid description of the public role?

The public role captures all default permissions for users in a database.

The public role cannot be dropped.

The public role is contained in every database, including msdb, tempdb, model, and all user databases except in the master database for security purposes.

The public role cannot have users, groups, or roles assigned to it.

Question 9. 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 10. In JDBC, what represents a single instance of a particular database session?

a thread

an opened connection

a closed connection

a pipe