Welcome to DataBase Quiz, Entry Level !!

Question 1. You are managing the in-house database systems.You need to ensure that the user AMY can execute all operations against the SALES relation. What SQL statement sequence will you use?

GRANT ALL PRIVILEGES WHERE FROM ON TO

GRANT ALL PRIVILEGES TO WHERE FROM

GRANT ALL PRIVILEGES WHERE FROM TO

GRANT ALL PRIVILEGES ON TO

Question 2. Under JDBC, which of the following types of instances can be created by the Connection object?

PreparedStatement

CallableStatement

Statement

All of the above

Question 3. Which of the following correctly describe the locking mechanism in a RDBMS?

A read lock prevents other transactions from reading the locked data

A write lock prevents other transactions from reading or writing to the locked data

Multiple transactions can have read locks on the same data item.

Either B&C

Question 4. Which of the following are the factors to consider when you want to select a DBMS based on the criteria of physical capabilities, as recommended by CIW ?

hardware requirements

data compression support

encryption support

All of the above

Question 5. Which of the following types of JDBC drivers allows your Java programs to communicate with the ODBC driver of your DBMS?

Pure Java

JDBC-ODBC Bridge

Native-API

JDBC-net

Question 6. Sort/Report generators

are faster than index/report generators

require more disk space than indexed/report generators

do not need to sort before generating report

both a and b

Question 7. You reject someone's proposal to use File-based databases. Which of the following are the disadvantages of such databases?

repetition of data

separation of data

data dependence

All of the above

Question 8. Which SQL statement is used to return only different values?

SELECT UNIQUE

SELECT INDENTITY

SELECT DIFFERENT

SELECT DISTINCT

Question 9. An audit trail

is used to make backup copies

is the recorded history of operations performed on a file

can be used to restore lost information

none of the above

Question 10. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

report writer

query language

data manipulation language

transaction log