Oracle 1z0-063 問題集

質問 1：
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan(plan=>'PRIU3ER3',comment=>'dssprio'); SQL>exec Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'on PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?
A. The other_groups group is not included in the resource plan.
B. The pending area is automatically submitted when creating plan directives.
C. The sys_group group is not included in the resource plan.
D. Pending areas can not be validated until submitted.
E. The procedure must be executed before creating any plan directive.
正解：A

質問 2：
In which three scenarios is media recovery required? (Choose three.)
A. when data files are lost
B. when a tablespace is accidentally dropped from a database
C. when one of the online redo log members is corrupted
D. when archived redo log files are lost
E. when all control files are lost
正解：A,B,E

質問 3：
Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).
It was started up by using the command which executed successfully with no errors:
SQL> STARTUP MOUNT
Which two statements are true? (Choose two.)
A. All tempfiles are opened.
B. The SPFILE is opened.
C. All control files are opened.
D. CDB$ROOT is opened.
E. All redo logs are opened.
正解：D,E

質問 4：
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ' /dev/f lash_device_1',' /dev/f lash_device_2'
How should the D3_flash_cache_size be configured to use both devices?
A. Set D3_FLASH_CACHE_SIZE=64G, 64G.
B. db_flash_cache_SI2E is automatically configured by the instance at startup.
C. Set DB_FLASH_CACHE_SIZE=64G.
D. Set D3_FLASK_CACKE_SI2E=128G.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)
A. Undo retention guarantee should be enabled.
B. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
C. Automatic Undo Management should be enabled.
D. Supplemental logging should be enabled.
E. Fast Recovery Area should be defined.
F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
正解：C,F

質問 6：
Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidentally truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.
Which two best methods for recovering the truncated table data? (Choose two.)
A. Tablespace Point-in-Time Recovery
B. Database Point-in-Time Recovery
C. Flashback Database
D. Table Point-in-Time Recovery
E. Flashback Transaction Backout
正解：B,C