Which action takes place when a file checkpoint occurs? A. The checkpoint position is advanced in the checkpoint queue. B. All buffers for a checkpointed file that were modified before a specific SCN are written to disk by DBWn and…
Examine the structure of the sales table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled. You want to perform online segment shrink to reclaim fragmented free space below the high water mark. What…
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c? A. shutting down the database instance that is being upgraded B. executing the catctl.pl script to…
Your database is open and the listener LISTNENER is up. You issue the command: LSNRCTL> RELOAD What is the effect of reload on sessions that were originally established by listener? A. Only sessions based on static listener registrations are disconnected.…
Which statement is true regarding the startup of a database instance? A. The instance does not start up normally and requires manual media recovery after a shutdown using the abort option. B. Uncommitted transactions are rolled back during the startup…
Examine the memory-related parameters set in the SPFILE of an Oracle database: Which statement is true? A. Only SGA components are sized automatically. B. Memory is dynamically re-allocated between the SGA and PGA as needed. C. The size of the…
Which two tasks can be performed on an external table? A. partitioning the table B. creating an invisible index C. updating the table by using an update statement D. creating a public synonym E. creating a view
Which three statements are true about a job chain? A. It can contain a nested chain of jobs. B. It can be used to implement dependency-based scheduling. C. It cannot invoke the same program or nested chain in multiple steps…
The hr user receiver, the following error while inserting data into the sales table: ERROR at line 1: ORA-01653; unable to extend table HR.SALES by 128 in tablespace USERS On investigation, you find that the users tablespace uses Automnrif Segment…
Which three factors influence the optimizer’s choice of an execution plan? A. the optimizer_mode initialization parameter B. operating system (OS) statistics C. cardinality estimates D. object statistics in the data dictionary E. fixed baselines