Welcome to DataBase Quiz, Randomly Selected !!

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

Null

0

Infinity

Error

Question 2. Which of the following correctly describe the locking mechanism in a RDBMS?

A read lock prevents other transactions from reading the locked data

A write lock prevents other transactions from reading or writing to the locked data

Multiple transactions can have read locks on the same data item.

Either B&C

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. An audit trail

is used to make backup copies

is the recorded history of operations performed on a file

can be used to restore lost information

none of the above

Question 5. In the DBMS approach, application programs perform the

storage function

processing functions

access control

none of the above

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

120.00

123.00

123.90

124.00

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