最新的Oracle Database 12c R2認證 1z1-074考試題庫

問題1

In your CDB, DEPTCDB, local undo is enabled. You successfully execute this command:
FLASHBACK PLUGGABLE DATABASE hrpdb to SCN 424366;
Which action must you perform next?

A. Open DEPTCDB with RESETLOGS

B. Open DEPTPDB

C. Open HRPDB with RESETLOGS

D. Take a backup of DEPTCDB

E. Take a backup of HRPDB

F. Open HRPDB

正確答案: C

問題2

U1.T1 is in a tablespace TBS_UNCMP which has no default compression and U1.T2 is in a tablespace, TBS_CMP with default compression for query low.
You execute commands:

Which three statements are true? (Choose three.)

A. T1 is in uncompressed format

B. The primary key constraints on T1 are dropped

C. T1 is in the TBS_UNCMP tablespace

D. T1 is in compressed format

E. T1 is in the TBS_CMP tablespace

F. All indexes on T1 remain valid

正確答案: A,C,F

問題3

You create a refreshable copy PDB, PDB_COPY, from the PDB_ORG PDB by using the REFRESH MODE EVERY 5 MINUTES clause.
What happens every five minutes?

A. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

B. An automatic refresh is done provided PDB_COPY is closed; otherwise the refresh is differed and attempted again after five minutes.

C. PDB_COPY is automatically closed provided there is no ongoing transaction in PDB_ORG and then reopened as read-only after the refresh is complete.

D. PDB_COPY'S state is automatically changed to read-only and then reopened as read-write after the refresh is complete.

E. PDB_COPY'S state is automatically changed to read-write and back to read-only after the refresh is complete.

正確答案: A

問題4

The ORCL CDB has a PDB, ORCL_PDB.
Examine these parameters in ORCL:

Examine these parameters in ORCL_PDB:

You switch to ORCL_PDB and plan to execute these commands:

What will be the outcome?

A. SGA_TARGET and SGA_MAX_SIZE are set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB.SGA_TARGET and SGA_MAX_SIZE are set to (1360-600)M and DB_CACHE_SIZE to
200M in ORCL.

B. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD

C. SGA_TARGET is set to 600M.The other values remain unchanged in both ORCL and ORCL_PDB.

D. Altering the DB_CACHE_SIZE results in an error because it cannot be altered in a PDB.SGA_TARGET size is changed to 600 M.

E. Altering the DB_CACHE_SIZE results in an error because SGA_TARGET should be altered to 600M first.

正確答案: B

問題5

The EMP_CDB1 and EMP_CDB2 CDBs are in ARCHIVELOG mode.
Oracle Managed Files is enabled in both CDBs.
EMP_CDB1 has a PDB, EMP_PDB1.
In EMP_CDB2, you log in as the SYS user.
You plan to execute this statement:
CREATE PLUGGABLE DATABASE emp_pdb2 FROM emp_pdb1@emp_link RELOCATE;
Which two statements are true? (Choose two.)

A. EMP_PDB2 should be opened in read-write mode to complete the relocation process.

B. EMP_PDB1 should be dropped manually from EMP_CDB1 after executing the relocating command.

C. Only EMP_PDB1 should be in local undo mode.

D. The AVAILABILITY MAX clause should be added to the command to ensure transaction consistency during the relocation process.

E. EMP_LINK should exist as a public link in EMP_CDB1 and EMP_CDB2.

F. SYSOPER privilege should be granted to the user defined in EMP_LINK and used to connect to the remote database.

正確答案: A,E

問題6

Which two are true about tables recovered by using the RMAN RECOVER TABLE command or the command itself, starting from Oracle Database 12c Release 2? (Choose two.)

A. They can be recovered by RMAN without an AUXILIARY instance

B. An AUXILIARY instance is started only if there is sufficient disk space

C. They may be recovered to a schema in a different PDB

D. They must be un-partitioned tables

E. They may be recovered to a different schema in the same pluggable database (PDB)

正確答案: B,E

問題7

Which three types of database objects can have their columns stored in the In-Memory column store? (Choose two.)

A. index-organized tables stored in system-defined tablespaces

B. clustered tables with dependent materialized views

C. sys-owned objects stored in sysaux-defined tablespaces

D. heap tables with dependent materialized views

E. heap tables with composite primary key constraints

正確答案: D,E

問題8

Which two statements are true about application containers? (Choose two.)

A. The application root stores user-created common objects and Oracle-supplied common objects.

B. An application PDB can belong to multiple application containers.

C. User-created common objects are accessible from the CDB root.

D. Multiple application roots can be created in one container database.

E. An application root can be unplugged from a CDB and plugged in to another CD

F. A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release 2 (12.2) PDB.

正確答案: A,C

最新的Oracle Upgrade Oracle DBA 11g or 12c to 12c R2 - 1z1-074免費考試真題

最新更新

站內鏈接

聯系我們