EASY
HSSC Clerk
IMPORTANT
Earn 100

Which of the following statements concerning relational database is true?
(a)A foreign key field may be null.
(b) A primary key field may be null
(c)All relations must be in at least third normal form
(d)The primary key fields of a relation must be adjacent
(e)None of these

50% studentsanswered this correctly

Important Questions on Database Management System
MEDIUM
HSSC Clerk
IMPORTANT
NF 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
Which of the following is correct?

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_____.

EASY
HSSC Clerk
IMPORTANT
Choose the correct statements _____.
