1Z0-074 Online Practice Questions and Answers

Which two statements are true about clean restore points in a regular PDB? (Choose two.)

A. They require a clone instance to be created when used in a PDB flashback operation

B. They can be created for a PDB when connected to either the PDB or to the root

C. They require backups to be restored when used in a PDB flashback operation

D. They are created as guaranteed restore points

E. They can be created only if shared undo is enabled

F. They can be created only for a PDB in the mount state

Examine these statements executed in the PROD1 database: Which statements are audited?

A. only the CREATE USER statement

B. only the ALTER SYSTEM statements

C. only the CREATE USER statement and the first change to JOB_QUEUE_PROCESSES

D. only the changes to JOB_QUEUE_PROCESSES and the CREATE USER statement

E. all the statements

Which two statements are true about a PDB lockdown profile? (Choose two.)

A. It is created by a local user with the SYSDBA privilege in each PDB where it needs to be applied.

B. It is created by a common user with the SYSDBA privilege in CDB$ROOT.

C. It is created by a common user with the SYSDBA privilege in each PDB where it needs to be applied.

D. It is enabled by default on creation.

E. It is enabled by using the PDB_LOCKDOWN parameter in each PDBs where it needs to be applied.

F. It is enabled in PDBs only after the CDB to which the PDBs belong is restarted.

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

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

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

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

D. to check the impact of partitioning a table

E. to check the impact of new optimizer statistics

F. to check the impact of upgrading and patching databases

Examine these commands executed in the cdb1 container database: Which statement is true about the c##USER1 account?

A. It is locked for two days after the password expires.

B. It is locked if the password is not changed within three weeks.

C. It is locked for 90 minutes after four failed login attempts.

D. It is locked after for consecutive failed login attempts.

E. It is not affected by the profile because the user has the SYSDBA privilege.

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 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 want to partition the SALES table on the CITY and SALE_DATE columns.

Which three partitioning methods can you use? (Choose three.)

A. range

B. interval

C. hash

D. list

E. virtual column-based

Which three statements are true about the deferred invalidation clause in DDL statements? (Choose three.)

A. It defers invalidating dependent cursor when possible.

B. It cannot be used for bitmap index creation.

C. The CURSOR_INVALIDATION parameter always overrides the deferred invalidation clause.

D. It always overrides the CURSOR_INVALIDATION setting.

E. It cannot be used for creating a secondary index on index organized tables

Which three resources can be controlled or managed by using Oracle Database Resource Manager? (Choose three.)

A. number of parallel queries issued by a consumer group

B. maximum number of DML operations performed by a consumer group

C. sessions that are blocking other sessions

D. sessions that are not blocking other sessions

E. UNDO quota for a consumer group