Welcome to DataBase Quiz, Randomly Selected !!

Question 1. 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 2. Given relations r(w, x) and s(y, z), the result of
  select distinct w, x from r, s
is guaranteed to be same as r, provided

r has no duplicates and s is non-empty

r and s have no duplicates

s has no duplicates and r is non-empty

r and s have the same number of tuples

Question 3. 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 4. 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

Question 5. What will be the output of the following statement? SELECT CAST(-1 AS SMALLDATETIME)

1900-01-01 00:00:00.000

1899-01-01 00:00:00.000

1752-01-01 00:00:00.000

The system will generate an error

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

GET

OPEN

EXTRACT

SELECT

Question 8. Which of the following types of JDBC drivers allows your Java programs to communicate with the ODBC driver of your DBMS?

Pure Java

JDBC-ODBC Bridge

Native-API

JDBC-net

Question 9. 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 10. What will be the output of the following statement? SELECT ROUND(123.89, -1)

120.00

123.00

123.90

124.00