MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 46 Mcqs, each offering curated multiple-choice questions to sharpen your Translation and Regulation knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Who detects the failure of the system and restore the database to consistent state ? |
| A. | Database Administrator |
| B. | Application Programmer |
| C. | Naive User |
| D. | Storage Manager |
| Answer» E. | |
| 2. |
Which phage always carries a small piece of E.coli genome? |
| A. | Lambda |
| B. | Mu |
| C. | T4 |
| D. | T3 |
| Answer» C. T4 | |
| 3. |
Which of the following are functions of Database Manager ? 1. Interacting with File Manager 2. Creating Queries to Access data 3. Security Enforcement 4. Database Definition and Schema Generation |
| A. | 1 and 2 |
| B. | 3 and 1 |
| C. | 1, 2 and 3 |
| D. | All of these |
| Answer» D. All of these | |
| 4. |
Transaction management ensures ____________ and __________ properties. |
| A. | Atomicity and Intigrity |
| B. | Atomicity and Durability |
| C. | Atomicity and Abstraction |
| D. | None of these |
| Answer» C. Atomicity and Abstraction | |
| 5. |
___________ is an interface between low level database and application program. |
| A. | Database Associator |
| B. | Database Server |
| C. | Database Manage |
| D. | None of these |
| Answer» D. None of these | |
| 6. |
A transaction may not always complete its execution successfully. Such a transaction is termed |
| A. | Aborted |
| B. | Terminated |
| C. | Closed |
| D. | All of the mentioned |
| Answer» B. Terminated | |
| 7. |
Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction? |
| A. | Only 1 |
| B. | Only 2 |
| C. | Both 1 and 2 individually |
| D. | Either 1 or 2 |
| Answer» D. Either 1 or 2 | |
| 8. |
What are the Svedberg values for the subunits of the 70S ribosomes of E. colli? |
| A. | 40S and 30S |
| B. | 50S and 20S |
| C. | 50S and 30S |
| D. | 40S and 20S |
| Answer» D. 40S and 20S | |
| 9. |
When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is |
| A. | Wait-die |
| B. | Wait-wound |
| C. | Wound-wait |
| D. | Wait |
| Answer» B. Wait-wound | |
| 10. |
The deadlock state can be changed back to stable state by using _____________ statement. |
| A. | Commit |
| B. | Rollback |
| C. | Savepoint |
| D. | Deadlock |
| Answer» C. Savepoint | |
| 11. |
What are the ways of dealing with deadlock ? |
| A. | Deadlock prevention |
| B. | Deadlock recovery |
| C. | Deadlock detection |
| D. | All of the mentioned |
| Answer» E. | |
| 12. |
A lock that allows concurrent transactions to access different rows of the same table is known as a |
| A. | Field-level lock |
| B. | Row-level lock |
| C. | Table-level lock |
| D. | Database-level lock |
| Answer» B. Row-level lock | |
| 13. |
Database locking concept is used to solve the problem of |
| A. | Lost Update |
| B. | Uncommitted Dependency |
| C. | Inconsistent Data |
| D. | All of the above |
| Answer» E. | |
| 14. |
Which of these is data type long literal? |
| A. | 0x99fffL |
| B. | ABCDEFG |
| C. | 0x99fffa |
| D. | 99671246 |
| Answer» B. ABCDEFG | |
| 15. |
A deadlock exists in the system if and only if the wait-for graph contains a ___________. |
| A. | Cycle |
| B. | Direction |
| C. | Bi-direction |
| D. | D. |
| Answer» B. Direction | |
| 16. |
Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is |
| A. | How long the transaction has computed, and how much longer the transaction will compute before it completes its designated task. |
| B. | How many data items the transaction has used. |
| C. | How many more data items the transaction needs for it to complete and how many transactions will be involved in the rollback. |
| D. | All of the above |
| Answer» E. | |
| 17. |
The deadlock in a set of transaction can be determined by |
| A. | Read-only graph |
| B. | Wait graph |
| C. | Wait-for graph |
| D. | All of the mentioned |
| Answer» B. Wait graph | |
| 18. |
When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti ). This is |
| A. | Wait-die |
| B. | Wait-wound |
| C. | Wound-wait |
| D. | Wait |
| Answer» D. Wait | |
| 19. |
The execution sequences in concurrency control are termed as ________ |
| A. | Serials |
| B. | Schedules |
| C. | Organizations |
| D. | Time tables |
| Answer» C. Organizations | |
| 20. |
Which of the following is not a transaction state? |
| A. | Active |
| B. | Partially committed |
| C. | Failed |
| D. | Compensated |
| Answer» E. | |
| 21. |
____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed. |
| A. | Consistency |
| B. | Atomicity |
| C. | Durability |
| D. | Isolation |
| Answer» E. | |
| 22. |
Transaction processing is associated with everything below except |
| A. | Producing detail summary or exception reports |
| B. | Recording a business activity |
| C. | Confirming an action or triggering a response |
| D. | Maintaining a data |
| Answer» D. Maintaining a data | |
| 23. |
The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties. |
| A. | BEGIN |
| B. | SET TRANSACTION |
| C. | BEGIN TRANSACTION |
| D. | COMMIT |
| Answer» C. BEGIN TRANSACTION | |
| 24. |
__________ states that only valid data will be written to the database. |
| A. | Consistency |
| B. | Atomicity |
| C. | Durability |
| D. | Isolation |
| Answer» B. Atomicity | |
| 25. |
The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as |
| A. | Atomicity |
| B. | Durability |
| C. | Durability |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 26. |
The property of a transaction that persists all the crashes is |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» C. Isolation | |
| 27. |
Identify the characteristics of transactions |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» E. | |
| 28. |
Which of the following has all-or-none property? |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | Isolation |
| Answer» B. Durability | |
| 29. |
A transaction is delimited by statements (or function calls) of the form __________ |
| A. | Begin transaction and end transaction |
| B. | Start transaction and stop transaction |
| C. | Get transaction and post transaction |
| D. | Read transaction and write transaction |
| Answer» B. Start transaction and stop transaction | |
| 30. |
State true or false: Information residing in the volatile storage does not usually survive system crashes |
| A. | True |
| B. | False |
| Answer» B. False | |
| 31. |
Which of the following systems is responsible for ensuring isolation? |
| A. | Recovery system |
| B. | Atomic system |
| C. | Concurrency control system |
| D. | Compiler system |
| Answer» D. Compiler system | |
| 32. |
Which of the following systems is responsible for ensuring durability? |
| A. | Recovery system |
| B. | Atomic system |
| C. | Concurrency control system |
| D. | Compiler system |
| Answer» B. Atomic system | |
| 33. |
Which of the following is not a property of a transaction? |
| A. | Atomicity |
| B. | Simplicity |
| C. | Isolation |
| D. | Durability |
| Answer» C. Isolation | |
| 34. |
Execution of translation in isolation preserves the _________ of a database |
| A. | Atomicity |
| B. | Consistency |
| C. | Durability |
| D. | All of the mentioned |
| Answer» C. Durability | |
| 35. |
The all-or-none property is commonly referred to as _________ |
| A. | Isolation |
| B. | Durability |
| C. | Atomicity |
| D. | None of the mentioned |
| Answer» D. None of the mentioned | |
| 36. |
Which of the following is a property of transactions? |
| A. | Atomicity |
| B. | Durability |
| C. | Isolation |
| D. | All of the mentioned |
| Answer» E. | |
| 37. |
A transaction that has not been completed successfully is called as _______ |
| A. | Compensating transaction |
| B. | Aborted transaction |
| C. | Active transaction |
| D. | Partially committed transaction |
| Answer» C. Active transaction | |
| 38. |
_________ rollback requires the system to maintain additional information about the state of all the running transactions. |
| A. | Total |
| B. | Partial |
| C. | Time |
| D. | Commit |
| Answer» C. Time | |
| 39. |
What is ACID properties of Transactions? |
| A. | Atomicity, Consistency, Isolation, Database |
| B. | Atomicity, Consistency, Isolation, Durability |
| C. | Atomicity, Consistency, Inconsistent, Durability |
| D. | Automatically, Concurrency, Isolation, Durability |
| Answer» C. Atomicity, Consistency, Inconsistent, Durability | |
| 40. |
With regards to transaction processing, any DBMS should be capable of: |
| A. | Ensuring that transactions are free from interference from other users. |
| B. | Parts of a transaction are not lost due to a failure. |
| C. | Transactions do not make the database inconsistent. |
| D. | All of the above. |
| Answer» E. | |
| 41. |
The scheme that controls the interaction between executing transactions is called as _____ |
| A. | Concurrency control scheme |
| B. | Multiprogramming scheme |
| C. | Serialization scheme |
| D. | Schedule scheme |
| Answer» B. Multiprogramming scheme | |
| 42. |
A transaction completes its execution is said to be |
| A. | Saved |
| B. | Loaded |
| C. | Rolled |
| D. | Committed |
| Answer» E. | |
| 43. |
A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set. |
| A. | Idle |
| B. | Waiting |
| C. | Deadlock |
| D. | Ready |
| Answer» D. Ready | |
| 44. |
Collections of operations that form a single logical unit of work are called __________ |
| A. | Views |
| B. | Networks |
| C. | Units |
| D. | Transactions |
| Answer» E. | |
| 45. |
The application of database management system in air flight seat booking in a way that one seat is accessed by only one clerk for customer reservation is classified as |
| A. | online transaction processing |
| B. | offline transaction processing |
| C. | online logical representation |
| D. | offline modeling representation |
| Answer» B. offline transaction processing | |
| 46. |
In database management system, the executing process or executing program which considers the updating or reading of records stored in database is called |
| A. | conceptualization |
| B. | execution |
| C. | implementation |
| D. | transaction |
| Answer» E. | |