Welcome to DataBase Quiz, Randomly Selected !!

Question 1. 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 2. Given the following relation instance.
x  y  z
1  4  2
1  5  3
1  6  3
3  2  2 
Which of the following functional dependencies are satisfied by the instance?

XY -> Z and Z -> Y

YZ -> X and Y -> Z

YZ -> X and X -> Z

XZ -> Y and Y -> X

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. 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 5. What is used by a properly designed DBMS to enable databases to be returned to the pre-transaction state should errors occur?

two phase commit

prefetch transaction

one phase commit

backup and restore

Question 6. The ascending order of a data hirerchy is:

bit-byte-record-field-file-database

byte-bit-field-record-file-database

bit-byte-field-record-file-database

bit-byte-file-record-field-database

Question 7. Which SQL statement is used to extract data from a database?

GET

OPEN

EXTRACT

SELECT

Question 8. A file produced by a spreadsheet

is generally stored on disk in an ASCII text fromat

can be used as is by the DBMS

both a and b

none of the above

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