| 1 |
Which of the following are anomalies that can be caused by redundancy in tables? |
- A. Insertion
- B. Deletion
- C. Modification
- D. All
|
| 2 |
The number of bytes used by 'int' data type in C are: |
|
| 3 |
------------- 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
|
| 4 |
Another term for a conditional operator is: |
- A. Ternary
- B. Binary
- C. Byte
- D. Iteration
|
| 5 |
Database integrity refers to the |
- A. correctness of data
- B. consistency of data
- C. both a and b
- D. none of these
|
| 6 |
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
|
| 7 |
In 3NT which form of dependency is removed ? |
- A. functional
- B. non-functional
- C. associative
- D. transitive
|
| 8 |
In 3NF, a non-key attribute must not depend on a : |
- A. Non-key attribute
- B. Key attribute
- C. Composite key
- D. Sort key
|
| 9 |
Two or more attributes with different name but same meaning create a problem: |
- A. Homonyms
- B. Synonyms
- C. Aliases
- D. Alternate attributes
|
| 10 |
A functional dependency between two or more non-key attributes is called: |
- A. Partial functional dependency
- B. Partial non-key dependency
- C. Transitive dependency
- D. None
|
