Welcome to DataBase Quiz, Intermediate Level !!

Question 1. 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 2. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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. What statement do you use to remove a schema and ensure that the removal takes place only if the schema is empty?

DROP SCHEMA RESTRICT

DROP SCHEMA OPTS

DROP SCHEMA CASCADE

DROP SCHEMA CLEAR

Question 5. The ascending order of a data hirerchy is:

bit-byte-record-field-file-database

byte-bit-field-record-file-database

bit-byte-field-record-file-database

bit-byte-file-record-field-database

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

a thread

an opened connection

a closed connection

a pipe

Question 9. 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 10. 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'