Welcome to DataBase Quiz, Entry Level !!

Question 1. The relational database environment has all of the following components except

users

separate files

query languages

database

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. 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 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. Which SQL keyword is used to sort the result-set?

SORT BY

ORDER

ORDER BY

SORT

Question 6. 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 7. Which SQL statement is used to return only different values?

SELECT UNIQUE

SELECT INDENTITY

SELECT DIFFERENT

SELECT DISTINCT

Question 8. 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 9. 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 10. 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