Welcome to DataBase Quiz, Advanced Level !!

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. What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0

Null

0

Infinity

Error

Question 3. 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 4. 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 5. Which of the following is true of a network structure?

It is a physical representation of the data

It allows a many-to-many relationship

It is conceptually simple

It will be dominant data base of the future

Question 6. What type of lock will deny users any access to a table?

EXPLICIT

IMPLICIT

EXCLUSIVE

READ ONLY

Question 7. What will be the output of the following statement? SELECT STR(6365, 3)

***

6365

6,365

6400

Question 8. Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

dependency preserving and loss less join

loss less join but not dependency preserving

dependency preserving but not loss less join

not dependency preserving and not loss less join

Question 9. 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 10. What is the maximum date value that can be stored in a SMALLDATETIME data type?

June 6, 2079

July 6, 2079

December 31, 2079

December 31, 9999