EASY
HSSC Clerk
IMPORTANT
Earn 100

Which of the following statements concerning relational database is true?

50% studentsanswered this correctly

Important Questions on Database Management System

MEDIUM
HSSC Clerk
IMPORTANT

3NF is preferred than BCNF because:

1. We normally choose to retain dependency preservation.

2. A high penalty in system performance is to be paid or risk the integrity of the data in our database.

3. There isn't any problem of repetition of information.

4. Given statement is wrong.

EASY
HSSC Clerk
IMPORTANT
Which of the following is the correct statement about SQL?
MEDIUM
HSSC Clerk
IMPORTANT
In SQL, relations can contain null values, and comparisons with null values are treated as unknown. Suppose all comparisons with a null value are treated as false. Which of the following pairs is not equivalent?
EASY
HSSC Clerk
IMPORTANT
Locking is introduced into database so that_____.
EASY
HSSC Clerk
IMPORTANT
Which of the following is true for two-phase locking?
MEDIUM
HSSC Clerk
IMPORTANT
Index sequential file is made of all of these expect_____.