Database design and implementation UE Past Papers Questions.

In the architecture of a database system conceptual level is the

• Physical level
• Logical level
• External level
• View level

Answer / Solution

In case of entity integrity , the primary key may be

• Not null
• Null
• Both Null and not Null

Answer / Solution

An advantage of the database management approach is

• Data is dependent on programs
• Data redundancy increases
• Data is integrated and can be accessed by multiple programs
• None of the above.

Answer / Solution

E-R model uses this symbol to represent weak entity set?

• Dotted rectangle
• Diamond
• Doubly outlined rectangle
• None of these

Answer / Solution

Briefly describe the following types of keys as used in DATABASES

1. Super Key
2. Partial Key
3. Primary Key
4. Candidate Key
5. Alternate Key
6. Surrogate Key
7. Foreign Key

Answer / Solution

UNSOLVED