Transaction Management Notes Questions with Answers PDF Download - 15

Detection of system failures and restoring the database to the state that existed prior to the occurrence of the failure, is known as

1. Failure recovery
2. Failure identification
3. Failure response
4. Failure management

The address field of a person should not be part of the primary key, since it is likely to

1. Dependent
2. Changed
3. Not changed
4. Too long

The universal front end to database applications that connects to the back end through the Internet, are the

1. Web browsers
2. Applications
3. Tools
4. Software programs

The term that allows specification of not only a set of relations, but also information about each relation, is known as

1. Data manipulation language
2. Data Declaration language
3. Data Declaration language
4. Data Definition language

When comparing a char type with a varchar type, one may expect extra spaces to be added to the

1. char type
2. varchar type
3. Both A and B
4. None of the above