最新的Oracle 1z0-074免費考試真題

問題1

Identify a situation where performance profiles can be used for application containers.

A. to enforce a limit on I/O throughput per second

B. to specify the total number of parallel execution servers available

C. to enforce a limit on the number of I/OS issued per second

D. to specify the maximum percentage of the parallel execution server pool that a particular application container can use

E. to specify the maximum time, in seconds, that a parallel statement can wait in the parallel statement queue before it is timed out

正確答案: B

問題2

To which two components does the term "shape" refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

A. number of storage LUNs

B. number of network interface cards (NICs)

C. amount of RAM

D. number of CPUs

E. number of database instances

正確答案: C,D

問題3

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. The AVAILABILITY MAX clause should be added to the command to ensure transaction consistency during the relocation process.

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

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

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

E. Only EMP_PDB1 should be in local undo mode.

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

正確答案: C,F

問題4

Identify two operations for which the bkup_api utility can be used. (Choose two.)

A. to define the cycle period for backups

B. to define the frequency of automatic backups

C. to define the retention period for backups

D. to define which system files are backed up

E. to define which database configuration files are backed up

正確答案: A,C

問題5

In which three situations would you recommend DB Replay to be used? (Choose three.)

A. to check the impact of database migration to the cloud

B. to check the impact of changing the storage system or the network

C. to check the impact of partitioning a table

D. to check the impact of new optimizer statistics

E. to check the impact of schema changes such as adding new indexes or materialized views

F. to check the impact of upgrading and patching databases

正確答案: A,B,F

問題6

In your database, DEFERRED_SEGMENT_CREATION is set to TRUE.
You successfully execute this command:

Which statement is true about the space allocated to the SALES_2016 table?

A. A single subpartition is allocated to the q1_2016 partition when the first row is inserted into q1_2016.

B. A single segment is allocated to the q1_2016 partition and its subpartitions at table creation.

C. Separate segments are allocated to the q1_2016 partition and each of its subpartitions when the first row is inserted into q1_2016.

D. Two subpartitions are allocated to the q1_2016 partition when the first row is inserted into q1_2016.

E. A segment is allocated to the q1_2016 partition but not its subpartitions at table creation.

正確答案: D

問題7

Which three statements are true about the SQL Performance Analyzer? (Choose three.)

A. It always executes triggers that are fired recursively in FULLDML mode.

B. It compares and analyzes execution plans for the SQL statements in a SQL Tuning Set (STS).

C. It generates execution plans for each SQL statement in an STS.

D. It recommends the creation of indexes for regressed SQL statements.

E. It recommends the use of SQL Tuning Advisor for regressed SQL statements.

正確答案: B,C,E

問題8

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 is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDThe other values remain unchanged in both ORCL and ORCL_PD

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

C. 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.

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.

正確答案: A

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

聯系我們

站內鏈接

最新更新