Welcome to DataBase Quiz, Entry Level !!

Question 1. 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 2. 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 3. You are managing the in-house database systems. You are creating a series of secondary indexes in your relational database. By doing so, which of the following issues must be carefully considered .

confusion in selection of optimal query execution method

disk space consumption

performance overhead

All of the above

Question 4. With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

SELECT * FROM Persons WHERE FirstName LIKE 'Peter' AND LastName LIKE 'Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT FirstName='Peter', LastName='Jackson' FROM Persons

none of the above

Question 5. 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 6. Under JDBC, which of the following types of instances can be created by the Connection object?

PreparedStatement

CallableStatement

Statement

All of the above

Question 7. With SQL, how do you select all the columns from a table named "Persons"?

SELECT [all] FROM Persons

SELECT All Persons

SELECT *.Persons

SELECT * FROM Persons

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. 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 10. Which SQL statement is used to delete data from a database?

TRUNCATE

DELETE

DROP

REMOVE