Oracle Oracle Certifications 1Z0-074 Questions & Answers

• Question 51:

  In your CDB1 container database, the DB_CREATE_FILE_DEST parameter is set to `/u01/app/oracle/

  oradata'.

  CDB1 has an application container called REGIONS_APP.

  There are no seeds for REGIONS_APP and there are no other application containers.

  You plan to execute this command.

  CREATE PLUGGABLE DATABASE AS SEED ADMIN USER seed_adm IDENTIFIED BY admin_123;

  What must you do for the command to execute successfully?

  A. Set the current container to REGIONS_APP

  B. Set the current container to CDB1

  C. Add the FILE_NAME_CONVERT clause to the command

  D. Add the CREATE_FILE_DEST clause to the command

  E. Set the PDB_FILE_NAME_CONVERT parameter to `/u01/app/oracle/oradata'

  Correct Answer: E

• Question 52:

  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.

  Correct Answer: AEF

• Question 53:

  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

  Correct Answer: BCF

  Reference: https://www.oracle.com/technetwork/database/manageability/db-replay-ow08-134917.pdf

• Question 54:

  You create a new application container, SALES_APP, with application PDBs, SALES1_PDB, and SALES2_PDB. You want to install the NEW_APP application in SALES1_PDB and SALES2_PDB by using:

  

  Where should you execute these statements?

  A. All the statements should be executed in the application root.

  B. All the statements should be executed in the application seed.

  C. All the statements should be executed in the SALES1_PDB and SALES2_PDB application containers.

  D. BEGIN/END INSTALL statements should be executed in the application root and the SYNC statement in SALES1_PDB and SALES2_PDB.

  E. BEGIN/END INSTALL statements should be executed in the CDB root and the SYNC statement in the application root.

  Correct Answer: AD

• Question 55:

  The TESTDB container database (CDB) running in ARCHIVELOG mode contains two pluggable

  databases (PDBs) PDB1 and PDB2. A connect descriptor for TESTDB is mapped to the TNS alias testdb

  in tnsnames.ora.

  The default RMAN configuration is used.

  Examine these commands:

  

  Which files are backed up?

  A. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and FLASHBACKLOGS

  B. all root and PDB1 data files, and the CONTROLFILE, SPFILE, and ARCHIVELOGS

  C. all root and PDB1 data files, and the CONTROLFILE and SPFILE

  D. all root and PDB1 data files, and the CONTROLFILE, SPFILE, ONLINE REDO LOG FILES, and ARCHIVELOGS

  E. all root and PDB1 data files

  Correct Answer: E

  Reference: https://oracle-base.com/articles/12c/multitenant-rman-backup-recovery-cdb-and-pdb-12cr1

• Question 56:

  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

  Correct Answer: D

• Question 57:

  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.

  Correct Answer: A

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/atnms/provisioning-access-to-users.html#GUID-C3CF0056-0869-4AC2-99CC- 9D0ACF848A46

• Question 58:

  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.

  Correct Answer: BC

  Reference: https://blogs.oracle.com/multitenant/a-simple-guide-to-lockdown-profiles

• Question 59:

  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.

  Correct Answer: CE

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/tgsql/joins.html#GUID24F34188-110F-4245-9DE7-43954092AFE0

• Question 60:

  Examine these parameters in a PFILE used to start database instance.

  

  Which two statements are true after an instance restart is attempted and why? (Choose two.)

  A. PGA_AGGREGATE_TARGET and SGA_TARGET remain 1G and 2G respectively.

  B. PGA_AGGREGATE_TARGET and SGA_TARGET are set to zero for the instance.

  C. The MEMORY_MAX_TARGET parameter is set to zero for the instance.

  D. MEMORY_MAX_TARGET is automatically set to 4G for the instance.

  E. The instance does not start because AMM is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET are set to nonzero values.

  Correct Answer: CD