Welcome to DataBase Quiz, Entry Level !!

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

users

separate files

query languages

database

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

DROP

REMOVE ROW

DELETE

DELETE ROW

Question 7. A top-to-bottom relationship among the items in a database is established by a

hierarchical schema

network schema

relational schema

all of the above

Question 8. Which SQL statement is used to delete data from a database?

TRUNCATE

DELETE

DROP

REMOVE

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