Oracle 1Z0-060 問題集

質問 1：
You use RMAN to back up a database which uses Automatic Storage Management (ASM) and you use the command to back up the ASM metadata regularly.
MD_BACKUP
You lose an ASM disk group DG1 due to a hardware failure.
In which two ways can you re-create the lost disk group and restore the data? (Choose two.)
A. Use the MKDG command to add a new disk group DG1 with the same or different specifications as those from the lost disk group and use RMAN to restore the data.
B. Use RMAN to restore both the metadata and the data.
C. Use the MD_RESTORE command to restore the disk group metadata and use RMAN to restore the data.
D. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
正解：A,C

質問 2：
An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

You want to balance the memory between the System Global Area (SGA) components depending on the workload.
Which option would solve this problem?
A. setting the SGA_TARGET parameter to 300M
B. setting the SGA_MAX_SIZE parameter to 400M
C. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M
D. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
正解：A

質問 3：
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
A. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
B. The statement results in an error because there are open PDBs.
C. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
D. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
After implementing full Oracle Data Redaction, you change the default value for the NUMBERdata type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
A. Flush the shared pool.
B. Re-connect the sessions that access objects with redaction policies defined on them.
C. Restart the database instance.
D. Re-create redaction policies that use FULL data redaction.
E. Re-enable redaction policies that use FULL data redaction.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
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/flash_device_1 `,' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
A. Set DB_FLASH_CACHE_ZISE = 64G.
B. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
C. Set DB_FLASH_CACHE_ZISE = 64G, 64G
D. Set DB_FLASH_CACHE_ZISE = 128G.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements are true about adaptive SQL plan management?
A. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
E. It adds new, bettor plans automatically as fixed plans to the baseline.
正解：B,C,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINERstatement and why is it so?
A. It succeeds because the PDB_ADMIN user has the required privileges.
B. It fails because local users are unable to use the SET CONTAINER statement.
C. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
D. It fails because common users are unable to use the SET CONTAINER statement.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 8：
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:

What is the result?
A. The file `+data.231.45678' remains in the same location andasynonym'myfile.dbf' is created.
B. The file `+data.231.45678' is physically relocated to `+data/prod' and renamed as `myfile.dbf'.
C. The file `+data.231.45678' is renamed as `myfile.dbf', and copied to `+data/prod'.
D. The file `myfile.dbf' is created in `+data/prod' and the reference to `+data.231.45678' in the data dictionary removed.
正解：A
解説: (Topexam メンバーにのみ表示されます)