MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 22 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
LGWR is an acronym for? |
| A. | log writer |
| B. | logger writer |
| C. | log write |
| D. | log written |
| Answer» B. logger writer | |
| 2. |
Select the correct case for which only queries are issued at one or more nodes. |
| A. | Partially read-only |
| B. | Completely read-only with prepare phase |
| C. | Completely read-only without two-phase commit |
| D. | Both B and C |
| Answer» B. Completely read-only with prepare phase | |
| 3. |
RECO process is an acronym of? |
| A. | Record |
| B. | Recover |
| C. | Recognize |
| D. | None of the company |
| Answer» C. Recognize | |
| 4. |
What is the correct privilege which is required for manually committing an in-doubt transaction? |
| A. | System privilege |
| B. | Force any transaction |
| C. | Both a & b |
| D. | None of the above |
| Answer» C. Both a & b | |
| 5. |
How do we name a transaction? |
| A. | SET TRANSACTION ... NAME |
| B. | TRANSACTION ... NAME |
| C. | TRANSACTION ... NAME = |
| D. | SET TRANSACTION = NAME |
| Answer» B. TRANSACTION ... NAME | |
| 6. |
When a node is told to prepare, it can respond in several ways, one of the ways is no data on the node has been or can be modified, so no preparation is necessary . What is this response called? |
| A. | Prepared |
| B. | Read-only |
| C. | Abort |
| D. | None of the above |
| Answer» C. Abort | |
| 7. |
Which of the following are valid optimization methods? |
| A. | Rule based |
| B. | Cost based |
| C. | Both a and b |
| D. | Query based |
| Answer» D. Query based | |
| 8. |
Which condition is applied while determining the commit point site? |
| A. | A read-only node can be the commit point site |
| B. | If multiple nodes directly referenced by the global coordinator have the same commit point strength, then the database designates one of these as the commit point site |
| C. | If a distributed transaction starts with a rollback, then the prepare and commit phases are not needed |
| D. | None of the above |
| Answer» C. If a distributed transaction starts with a rollback, then the prepare and commit phases are not needed | |
| 9. |
What happens when an entire transaction is roll backed without referencing any save points? |
| A. | All changes are undone made by all of the SQL statements |
| B. | The transaction locks of data is released |
| C. | The transaction ends |
| D. | All of the above |
| Answer» E. | |
| 10. |
What is the exact reason for which you can force the failure of a distributed transaction? |
| A. | To observe RECO automatically resolving the local portion of the transaction |
| B. | To practice manually resolving in-doubt distributed transactions and observing the results |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 11. |
Which of the following scenarios ends an Oracle transaction? |
| A. | COMMIT or ROLLBACK is issued |
| B. | User disconnects from Oracle |
| C. | User process terminates abnormally |
| D. | All of the above |
| Answer» E. | |
| 12. |
The job of the commit point site is to initiate a commit or roll back operation as instructed by _____________. |
| A. | Global coordinator |
| B. | Local coordinator |
| C. | Database servers |
| D. | Commit point site |
| Answer» B. Local coordinator | |
| 13. |
Which of the following/s are supported by transaction control statements? |
| A. | Commit, Rollback, Savepoint |
| B. | Alter,Execute,Drop |
| C. | Insert, Remove, Delete |
| D. | All of the above |
| Answer» B. Alter,Execute,Drop | |
| 14. |
Select the correct SQL statement for disabling recovery. |
| A. | alter system disable distributed recovery; |
| B. | update system disable distributed recovery; |
| C. | select system disable distributed recovery; |
| D. | delete system disable distributed recovery; |
| Answer» B. update system disable distributed recovery; | |
| 15. |
Which of the following way can the Distributed transactions become in-doubt? |
| A. | A server machine running Oracle Database software crashes |
| B. | A network connection between two or more Oracle Databases involved in distributed processing is connected |
| C. | An unhandled software error does not occurs |
| D. | None of the above |
| Answer» B. A network connection between two or more Oracle Databases involved in distributed processing is connected | |
| 16. |
What is the role in the session tree that has a node which is forced to reference data on other nodes to complete its part of the transaction? |
| A. | Client |
| B. | Database server |
| C. | Global coordinator |
| D. | Local coordinator |
| Answer» E. | |
| 17. |
Errors discovered during SQL statement execution cause |
| A. | statement-level rollback |
| B. | Row-level rollback |
| C. | Deadlock |
| D. | Both a and b |
| Answer» B. Row-level rollback | |
| 18. |
___________________ determines the best possible way to execute a query. |
| A. | Transaction optimizer |
| B. | Query optimizer |
| C. | Optimizer |
| D. | Oracle optimizer |
| Answer» C. Optimizer | |
| 19. |
When does a statement run in a resumable mode? |
| A. | When the client implicitly enables resumable semantics for the session using the ALTER SESSION statement |
| B. | When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement |
| C. | When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement |
| D. | When the client explicitly enables resumable semantics for the session using the CREATE SESSION statement |
| Answer» C. When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement | |
| 20. |
Which of the following performs the following operations during a distributed transaction?1) Sends all of the distributed transaction SQL statements, remote procedure calls, and so forth to the directly referenced nodes, thus forming the session tree.2) Instructs all directly referenced nodes other than the commit point site to prepare the transaction.3) Instructs the commit point site to initiate the global commit of the transaction if all nodes prepare successfully. |
| A. | Database server |
| B. | Local coordinator |
| C. | Global coordinator |
| D. | Commit point site |
| Answer» D. Commit point site | |
| 21. |
Two-phase commit mechanism is completely transparent to users who issue _________________ . |
| A. | Commit a transaction |
| B. | Rollback a transaction |
| C. | Non distributed transactions |
| D. | Distributed transactions |
| Answer» E. | |
| 22. |
What is an executable SQL statement? |
| A. | A statement that can be executed without errors |
| B. | Statement that generates calls to an instance, including DDL statements only. |
| C. | Statement that generates calls to an instance including statements only. |
| D. | Statement that generates calls to an instance, including DML and DDL statements. |
| Answer» E. | |