| 1 |
The type of expression x > y is |
- A. arithmetic
- B. logical
- C. relational
- D. conditional
|
| 2 |
The entity integrity rule states that: |
- A. No primary key attribute can be null
- B. Each entity must have a primary key
- C. Primary key must have only one attribute
- D. None
|
| 3 |
Which is a possible value of flag? |
- A. -
- B. +
- C. Space
- D. All of these
|
| 4 |
In 3NF, a non-key attribute must not depend on a : |
- A. Non-key attribute
- B. Key attribute
- C. Composite key
- D. Sort key
|
| 5 |
The 1NF describes the tabular format in which: |
- A. All the key attributes are defined
- B. No repeating groups in the table
- C. All attributes are dependent on primary key
- D. All
|
| 6 |
A rule that states each foreign key value must match a primary key value in the other relation is called: |
- A. Referential integrity constraints
- B. Key match rule
- C. Entity key group rule
- D. Foreign/ primary match rule
|
| 7 |
------------- is the process of converting complex data structures into simple and stable data structures |
- A. database integrity
- B. homonyms
- C. normalization
- D. mutually exclusive data
|
| 8 |
A relation is in 2NF if it is in 1NF and all its non-key attributes are: |
- A. Dependent on part of the primary key
- B. Dependent on the entire primary key
- C. Independent on the primary key
- D. Independent of any other relation
|
| 9 |
We can make two way decisions with the help of |
- A. if
- B. nested
- C. if-else
- D. all
|
| 10 |
The program structure that executes program statements in order is |
- A. selection
- B. sequence
- C. repetition
- D. iteration
|
