最新的Oracle Database認證 1Z0-060考試題庫

問題1

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available.

A. 10,3,4,8,9

B. 1,2,5,6,7,8

C. 1,2,3,4,7,8

D. 1,2,10,5,6,9

正確答案: B,D

問題2

Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?

A. Run the ut132k.sql script in $ORACLE_HOME/rdbms/admin.

B. Shut down the database instance.

C. Restart the database instance in UPGRADE mode.

D. Set the MAX_STRING_SIZE parameter to EXTENDED.

E. Restart the database Instance in RESTRICTED mode.

F. Restart the instance in normal mode.

G. Run the Database Migration Assistant.

正確答案: A,B,C,D,F

說明：（僅 VCESoft 成員可見）

問題3

You issue the following commands:

The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata' exist.
Which statement describes the outcome?

A. Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.

B. The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the tablespace is created with its data file in the '/u01/app/oracle/mydata/ AUGUST_SALES location.
mysales.dbf'

C. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.

D. The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.

正確答案: C

問題4

Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

A. The optimizer used a dynamic plan for the query.

B. The optimizer chose different plans because automatic dynamic sampling was enabled.

C. The optimizer chose different plan because extended statistics were created for the columns used.

D. The optimizer used re-optimization cardinality feedback for the query.

正確答案: D

說明：（僅 VCESoft 成員可見）

問題5

Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c?
(Choose two.)

A. By default, EM express is available for a database after database creation.

B. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

C. You can create and configure pluggable databases by using EM express.

D. Multiple databases on the same node (or host) may each be individually managed by using EM Express.

E. You cannot start up or shut down a database instance by using EM express.

正確答案: D,E

說明：（僅 VCESoft 成員可見）

問題6

Which three activities are supported by the Data Recovery Advisor?

A. Advising on inaccessible control files

B. Advising on block checksum failures

C. Advising on inaccessible block change tracking files

D. Advising on invalid block header field values

E. Advising on empty password files

正確答案: A,B,D

說明：（僅 VCESoft 成員可見）

問題7

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, 64G

B. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

C. Set DB_FLASH_CACHE_ZISE = 128G.

D. Set DB_FLASH_CACHE_ZISE = 64G.

正確答案: A

說明：（僅 VCESoft 成員可見）

問題8

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

B. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

C. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.

E. Data is never redacted for the EMP_V.SAL column.

正確答案: C,E

說明：（僅 VCESoft 成員可見）

問題9

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.

B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.

C. Take the USERDATA tablespace offlineinACCOUNTS_PDB.

D. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題10

You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN:
RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION
`+RECO';
Which five steps are performed by RMAN?

A. recovering the auxiliary database to the desired point in time

B. dropping the SCOTT.EMP table in the original database

C. exporting the SCOTT.EMP table from the auxiliary database

D. truncating the SCOTT.EMP table in the original database

E. flashing back the original database to the desired point in time

F. restoring the tablespaces required for point-in-time recovery

G. importing the SCOTT.EMP table into the original database

H. creating an auxiliary instance

正確答案: A,E,F,G,H

最新的Oracle Upgrade to Oracle Database 12c - 1Z0-060免費考試真題

最新更新

站內鏈接

聯系我們