Welcome to DataBase Quiz, Randomly Selected !!

Question 1. What will be the output of the following statement? SELECT ROUND(123.89, -1)

120.00

123.00

123.90

124.00

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

GET

OPEN

EXTRACT

SELECT

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

SELECT UNIQUE

SELECT INDENTITY

SELECT DIFFERENT

SELECT DISTINCT

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

SORT BY

ORDER

ORDER BY

SORT

Question 7. What will be the output of the following statement? SELECT LEN(CAST(LEFT('026-100', 3) AS INT))

Statement will generate an error.

2

3

7

Question 8. 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 9. What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?

DATETIME

INT

SMALLDATETIME

VARCHAR

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