1Z0-074 Online Practice Questions and Answers

Your CDB has a PDB, EMP_PDB.

You successfully execute these commands as the SYSTEM USER in CDB$ROOT:

Which two statements are true about C##USR1? (Choose two.)

A. It can connect to EMP_PDB and view the data only in tables created by common users.

B. It can connect to EMP_PDB but cannot view the data in any table in it.

C. It can connect only to the root.

D. It is a common user.

E. It is a local user.

Users BIXBY, RLAYTON, and MURDOK each have a table named CUST_RECORDS in their schema.

BIXBY has created a procedure, UPDATE_CUST, which updates the CUST_RECORDS table with

invoker's right.

BIXBY grants the execute permission on UPDATE_CUST to the RLAYTON user.

When RLAYTON executes the UPDATE_CUST procedure, which table does the procedure attempt to

update?

A. CUST_RECORDS table in Bixby's schema

B. CUST_RECORDS table in Murdok's schema

C. CUST_RECORDS table in Rlayton's schema

D. CUST_RECORDS table in the schema of Bixby and Rlayton

E. CUST_RECORDS table in the schema of Bixby, Rlayton, and Murdok

You want to restrict PGA usage to 200 MB for a set of database users' sessions as part of your organization's security requirements for combating denial of service (DOS) attacks. Which statement is true about limiting PGA usage for those users' sessions?

A. You can limit their PGA usage by setting SORT_AREA_SIZE to 200 MB.

B. You cannot limit PGA for a set of database user sessions.

C. You can limit their PGA usage by setting PGA_AGGREGATE_LIMIT to 200 MB.

D. You can limit their PGA usage by setting PGA_AGGREGATE_TARGET to 200 MB.

E. You can limit their PGA usage by setting the SESSION_PGA_LIMIT directive by using Database Resource Manager

You set the maximum size of the diagnostic collection repository by issuing this command as root.tfact1 set reposizeMB=5120 You then notice that the current repository size is 5 GB and that old files are not being purged.

Which statement is true?

A. The tfact1 command fails because it can be set only by the Oracle software owner.

B. TFA collects new diagnostic data if the Max Size of TFA Log parameter value is greater than 5 GB.

C. TFA does not collect new diagnostic data when the maximum repository size is reached.

D. TFA collects new diagnostic data but logs a warning message.

E. TFA collects new diagnostic data while the repository directory's file system has free space.

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. The other values remain unchanged in both ORCL and ORCL_PDB.

B. SGA_TARGET is set to 600M and DB_CACHE_SIZE to 200M in ORCL_PDB. 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 SGA_TARGET should be altered to 600M first.

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

Examine this command:

Which statement is true?

A. Up to four worker processes are allocated to export data and metadata

B. Four worker processes are allocated to export only data

C. Four worker processes are active to export only metadata

D. Four worker processes are allocated to export data and metadata

E. Four worker processes are allocated when there is sufficient CPU available

Identify four prerequisites for issuing the RMAN RECOVER TABLE command starting from ORACLE Database 12c Release 2.

A. The COMPATIBLE parameter must be set to 12.0 or greater.

B. The database must be in ARCHIVELOG mode.

C. FLASHBACK DATABASE must be enabled.

D. RMAN must use a recovery catalog.

E. The database must be in the READ WRITE state.

F. RMAN can recover the table only from a backupset.

G. An export dump file of the table must be available.

H. There must be sufficient space to start the auxiliary instance.

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

Your CDB is in ARCHIVELOG mode and has an application container with a container PDB. A backup

exists for the CDB. When you connect to the container PDB and try to execute a query, you get an error

that a SYSTEM data file is missing in the container PDB. You want to use the RMAN RESTORE

DATABASE and RECOVER DATABASE commands to perform the recovery.

Examine these actions:

Connect to CDB$ROOT and execute SHUTDOWN ABORT and STARTUP MOUNT.

Connect to the application container and execute SHUTDOWN ABORT.

Connect to the application container and execute ALTER PLUGGABLE DATABASE CLOSE ABORT.

Which option correctly lists the actions that you must execute before performing the recovery?

A. 1 and 3

B. 1 and 2

C. only 2 D. only 3