Welcome to DataBase Quiz, Entry Level !!

Question 1. 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

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

TRUNCATE

DELETE

DROP

REMOVE

Question 4. Which of the following is the correct SQL statement to use to remove rows from a table?

DROP

REMOVE ROW

DELETE

DELETE ROW

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

PreparedStatement

CallableStatement

Statement

All of the above

Question 6. 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 7. 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 8. 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

Question 9. Which SQL statement is used to extract data from a database?

GET

OPEN

EXTRACT

SELECT

Question 10. Which SQL keyword is used to sort the result-set?

SORT BY

ORDER

ORDER BY

SORT