Welcome to DataBase Quiz, Entry Level !!

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

SELECT UNIQUE

SELECT INDENTITY

SELECT DIFFERENT

SELECT DISTINCT

Question 7. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?

report writer

query language

data manipulation language

transaction log

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

TRUNCATE

DELETE

DROP

REMOVE

Question 9. In a properly designed DBMS, concurrency control is provided by which of the following components.

Cache Manager

Lock Manager

Transaction Manager

B&C

Question 10. Which of the following are the factors to consider when you want to select a DBMS based on the criteria of physical capabilities, as recommended by CIW ?

hardware requirements

data compression support

encryption support

All of the above