Welcome to DataBase Quiz, Randomly Selected !!

Question 1. 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 2. Which SQL keyword is used to sort the result-set?

SORT BY

ORDER

ORDER BY

SORT

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

***

6365

6,365

6400

Question 4. The language used by application programs to request data from the DBMS is referred to as the

DML

DDL

query language

none of the above

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

EXPLICIT

IMPLICIT

EXCLUSIVE

READ ONLY

Question 8. The management information system (MIS) structure with one main computer system is called a

hierarchical MIS structure

distributed MIS structure

centralized MIS structure

decentralized MIS structure

Question 9. A transparent DBMS

can not hide sensitive information from users

keeps its logical structure hidden from users

keeps its physical structure hidden from users

both b and c

Question 10. In the world of SQL relational database, the data type for varchar, in general, is:

Fixed length string of n characters

Variable length string up to n characters

Floating point number of p bits precision

32-bit signed integer