1z0-043多項選擇題每日一練(2019.03.21)

A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode

A. control files
B. password file
C. archived log files
D. system-critical data files for which all the redo entries are present
E. non-system-critical data files for which all the redo entries are present

A. The batch operation started by the user， SCOTT， terminates with an error.
B. The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
C. The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
D. The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
E. The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

A.The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
B.The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
C.Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management.
D.The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

A.The maximum degree of parallelism for the members of the consumer groups is 4.
B.The CPU allocation will always be equal for the consumer groups MARKET and DEV.
C.The OTHERS consumer group would get 100% of the CPU if there are unused level 1 CPU resources.
D.The SALES and MARKET consumer groups would get 100% of the CPU if there are unused level 2 CPU resources.
E.The maximum degree of parallelism for the members of the consumer group SALES is 4 with no restriction for the remaining groups.