Welcome to DataBase Quiz, Advanced Level !!

Question 1. View text definitions are stored in which system table?





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

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 type of lock will deny users any access to a table?





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





Question 7. What will be the output of the following statement? SET ARITHABORT OFF SET ANSI_WARNINGS OFF SELECT 100/0





Question 8. 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 9. Given the relations
employee (name, salary, deptno) and department (deptno, deptname, address)
Which of the following queries cannot be expressed using the basic relational algebra operations (U, -, x, , p)?

Department address of every employee

Employees whose name is the same as their department name

The sum of all employees? salaries

All employees of a given department

Question 10. The highest level in the hierarchy of data organization is called

data bank

data base

data file

data record