Welcome to DataBase Quiz, Entry Level !!

Question 1. 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 2. 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 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 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 5. You run a SELECT statement, and multiple duplicates of values are retrieved. What keyword can you use to retrieve only the non duplicate data?

DUBPLICATE

INDIVIDUAL

INDEX

DISTINCT

Question 6. 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 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 of the following is the correct SQL statement to use to remove rows from a table?

DROP

REMOVE ROW

DELETE

DELETE ROW

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

PreparedStatement

CallableStatement

Statement

All of the above

Question 10. In the world of SQL relational database, the data type for varchar, in general, is:

Fixed length string of n characters

Variable length string up to n characters

Floating point number of p bits precision

32-bit signed integer