Database Management Questions & Answers: part22



Software Programming : Database Management QUESTIONS AND ANSWERS :: part22 : 1 to 5

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

1.Which of the following gives the state of the transaction after the final statement has been executed?

Active
Partially committed
Failed
Aborted
Committed.

2.Which of the following is referred to as a sequential storage device?

Tape storage
Flash memory
Optical storage
Cache
Main memory.

3.In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?

Triggers
Pointers
Locks
Cursors
Deadlocks.

4.Which of the following statements is false with respect to the storage of the database?

A database is mapped into a number of different files, which are maintained by the underlying operating system
Each file is partitioned into fixed-length storage units called blocks
A major goal of database system is to maximize the number of block transfers between disk and memory
Both (opt1) and (opt2) false
Both (opt2) and (opt3) false.

5.Which of the following is/are reason(s) for the existence of variable length records in database systems?

Storage of multiple record types in a file
Record types that allow variable lengths for one or more fields
Record types that allow repeating fields
All of the above
None of the above.

More Database Management QUESTIONS AND ANSWERS available in next pages

    Health is the greatest gift, contentment is the greatest wealth -Buddha
Trust because you are willing to accept the risk, not because it’s safe or certain