1Z0-074 Online Practice Questions and Answers

APP1 is an application container that has an application seed and two application PDBs, APP_PDB1 and APP_PDB2.

1.0 is the current version of the application. You execute this block in the application root:

What is the outcome?

A. An error is thrown because the version number should be sequential, either 1.1 or 2.0.

B. An error is thrown because the CONTAINER=ALL clause is missing.

C. An error is thrown because the c## prefix is missing in the role name.

D. A common role is created only in the application root.

E. A common role is created only in the application root and application seed.

F. A common role is created in the application root, application seed, APP_PDB1, and APP_PDB2.

Which two statements are true about a band join? (Choose two.)

A. The optimizer always uses the smaller of the two row sources to build a hash table on the join key.

B. It returns rows for SQL statements that contain an equijoin.

C. It is a non-equijoin in which the key values in one data set must fall within the specified range of the second data set.

D. For each row in the first row source, Oracle probes the second row source for matching rows and joins them.

E. The SQL runtime engine avoids unnecessary scanning of rows that fall outside the defined ranges.

Examine this parameter:

Examine these commands:

Which three are true after executing these commands? (Choose three.)

A. All statements executed by SH are captured and included in a baseline.

B. Statements executed by both SH and SYS may be captured and included in a baseline.

C. Only statements executed by SYS are captured and included in a baseline.

D. Only statements executed by SH containing the "TEST_ONLY" string are excluded from capture.

E. Statements executed by any user containing the "TEST_ONLY" string are excluded from capture.

F. Only repeatable statements executed by SYS and SH are considered for baselines.

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

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

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

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

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

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

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

A. to define the retention period for backups

B. to define which system files are backed up

C. to define which database configuration files are backed up

D. to define the cycle period for backups

E. to define the frequency of automatic backups

A CDB, CDB1, has a LOCATIONS application container.

NORTH_PDB and SOUTH_PDB are two application PDBs in LOCATIONS.

Both application PDBs are synchronized with the application installed in the LOCATIONS root...

In CDB2, you create a remote clone, LOC_R, of the LOCATIONS application root.

You want to query data across the LOCATIONS application PDBs created in CDB1 and CDB2.

How can you do this?

A. by creating a proxy PDB in LOCATIONS_ROOT in CDB1, referencing LOC_R

B. by creating a proxy PDB in CDB1 root, referencing LOC_R

C. by using private database links created in CDB1 and CDB2

D. by using public database links created in CDB1 and CDB2

E. by creating a proxy PDB in CDB2 root, referencing LOC_R

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_PDB2 should be opened in read-write mode to complete the relocation process.

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

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

F. Only EMP_PDB1 should be in local undo mode.

In a Database Cloud Service (DBCS) environment, which pre-created user has sudo privileges to run certain root commands?

A. grid

B. oracle

C. opc

D. nobody

E. oinstall

In an Oracle 12c Release 2 database, USER1 has CREATE SESSION, CREATE PROCEDURE, and

CREATE FUNCTION privileges.

Examine these commands:

SYS executes this command:

SQL> SELECT add_num(1,2) FROM DUAL;

What is the result?

A. An error is returned

B. The message "The result is 3" only is displayed

C. TESTDBA is created with the SYSDBA privilege only

D. Only "3" is displayed

E. TESTDBA is created will the SYSDBA privilege and the message "The result is 3" is displayed

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 closed; otherwise the refresh is differed and attempted again after five minutes.

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

C. PDB_COPY'S state is automatically changed to read-write and back to 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. An automatic refresh is done provided PDB_COPY is in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

Examine these statements:

Which statement is true?

A. Statements 2 and 3 will validate the conversion

B. Only statement 3 will validate the conversion

C. Only statement 1 will validate the conversion

D. Statement 1 will return an error

E. All the statements will validate the conversion

Which two statements are true about FLEX ASM? (Choose two.)

A. A database instance on any node can connect to an ASM instance on any node.

B. A separate ASM network is required.

C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.

D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.

E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASM instance.

In which four situations does the RMAN DUPLICATE command use the "pull" method? (Choose four.)

A. when the USING BACKUPSET clause is used

B. when the SET ENCRYPTION clause is added before the DUPLICATE command

C. when the SECTION SIZE clause is used

D. when the number of auxiliary channels allocated is less than the number of target channels allocated

E. when the USING COMPRESSED BACKUPSET clause is used

F. when no auxiliary channels are allocated

G. when IMAGE COPIES are used for the DUPLICATE operation

Which statement is true about the Automatic Diagnostic Repository (ADR)?

A. Space used by the ADR can be limited to a user-specified value.

B. Space used by the ADR is limited based only on the retention period.

C. The retention period for the ADR is set based on the space limit specified.

D. When the ADR reaches the space limit, it deletes incident dumps and metadata before deleting old core dumps.

E. Manual purging of all types of ADR files is allowed.

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

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

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

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

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

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