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

DROP

REMOVE ROW

DELETE

DELETE ROW

Question 3. 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 4. 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 5. 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 6. The relational database environment has all of the following components except

users

separate files

query languages

database

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 SQL statement is used to extract data from a database?

GET

OPEN

EXTRACT

SELECT

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

SELECT UNIQUE

SELECT INDENTITY

SELECT DIFFERENT

SELECT DISTINCT

Question 10. With SQL, how can you return the number of records in the "Persons" table?

SELECT COLUMNS() FROM Persons

SELECT COUNT() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons