Best Quality 1z0-074 Questions Pool 2021

NEW QUESTION 1
Examine these statements executed in thePROD1database:

Which statements are audited?

• A. only theCREATE USERstatement
• B. only theALTER SYSTEMstatements
• C. only theCREATE USERstatement and the first change toJOB_QUEUE_PROCESSES
• D. only the changes toJOB_QUEUE_PROCESSESand theCREATE USERstatement
• E. all the statements

Answer: D

NEW QUESTION 2
You want to partition theSALEStable on theCITYandSALE_DATEcolumns. Which three partitioning methods can you use? (Choose three.)

• A. range
• B. interval
• C. hash
• D. list
• E. virtual column-based

Answer: ACD

NEW QUESTION 3
In which two situations does theINHERIT ANY PRIVILIGESprivilege regulate the privileges used?

• A. when a user creates a new user
• B. when a user performs a GRANT or REVOKE operation
• C. when a user queries aBEQUEATH CURRENT_USERview that references an invoker’s right procedure
• D. when a user runs a procedure created with invoker’s right
• E. when a user runs a procedure created with definer’s right

Answer: CD

NEW QUESTION 4
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.

Answer: CE

NEW QUESTION 5
HR.EMP.EMPLOYEE_IDis the primary key of theHR.EMPpartitioned table, which contains 108 rows and resides in theEXAMPLEtablespace.
HR executes this command:
SQL> CREATE TABLE employees TABLESPACE users FOR EXCHANGE WITH TABLE hr.emp;
Table created.
Which two statements are true? (Choose two.)

• A. Dependent objects ofHR.EMPare automatically created forHR.EMPLOYEES.
• B. HR.EMPis moved to theUSERStablespace.
• C. The column namesHR.EMPandHR.EMPLOYEESare identical.
• D. TheHR.EMPLOYEEStable has 108 records.
• E. HR.EMPLOYEES.EMPLOYEE_IDis thePRIMARY KEYofHR.EMPLOYEES
• F. The column orderHR.EMPandHR.EMPLOYEESare identical

Answer: CF

NEW QUESTION 6
Examine this parameter:

Examine these commands:

Which three are true after executing these commands? (Choose three.) (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.

Answer: AEF

NEW QUESTION 7
Identify four prerequisites for issuing theRMAN RECOVER TABLEcommand starting from ORACLE Database 12c Release 2.

• A. TheCOMPATIBLEparameter must be set to 12.0 or greater.
• B. The database must be inARCHIVELOGmode.
• C. FLASHBACK DATABASEmust be enabled.
• D. RMANmust use a recovery catalog.
• E. The database must be in theREAD WRITEstate.
• F. RMANcan 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.

Answer: ABEF

NEW QUESTION 8
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

Answer: ACE

NEW QUESTION 9
In your CDB1 container database, theDB_CREATE_FILE_DESTparameter is set to‘/u01/app/oracle/ oradata’.
CDB1has an application container calledREGIONS_APP.
There are no seeds forREGIONS_APPand 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 toREGIONS_APP
• B. Set the current container toCDB1
• C. Add theFILE_NAME_CONVERTclause to the command
• D. Add theCREATE_FILE_DESTclause to the command
• E. Set thePDB_FILE_NAME_CONVERTparameter to‘/u01/app/oracle/oradata’

Answer: E

NEW QUESTION 10
From which two failure scenarios can a database be restored and recovered with theREPAIR DATABASE
command? (Choose two.)

• A. loss ofARCHIVELOGS
• B. loss of a redo log member
• C. loss of a noncritical data file
• D. loss of all copies of the control file
• E. loss of a critical data file such asSYSTEM,SYSAUXorUNDO
• F. loss ofSPFILE

Answer: DE

NEW QUESTION 11
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.

Answer: E

NEW QUESTION 12
Which two statements are true about the In-Memory (IM) column store? (Choose two.)

• A. It may be used for columns in Index Organized Tables (IOTs)
• B. It may be used for columns in clustered tables
• C. IM area size is not controlled by Oracle Automatic Memory Management
• D. IM area size can be set at the CDB and PDB levels
• E. IM area size can be increased or decreased dynamically
• F. It is not used for partitioned tables

Answer: AE

NEW QUESTION 13
Your CDB has a PDB,EMP_PDB.
You successfully execute these commands as theSYSTEM USERinCDB$ROOT:

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

• A. It can connect toEMP_PDBand view the data only in tables created by common users.
• B. It can connect toEMP_PDBbut 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.

Answer: AE

NEW QUESTION 14
Which two statements are true about application containers? (Choose two.)

• A. A regular PDB can be plugged in to an application container provided it is an Oracle Database 12c Release2 (12.2) PDB.
• B. An application root can be unplugged from a CDB and plugged in to another CDB.
• C. An application PDB can belong to multiple application containers.
• D. User-created common objects are accessible from the CDB root.
• E. The application root stores user-created common objects and Oracle-supplied common objects.
• F. Multiple application roots can be created in one container database.

Answer: DE

NEW QUESTION 15
QUERY_REWRITE_INTEGRITYandQUERY_REWRITE_ENABLEDare set toTRUSTEDand TRUE
respectively in an Oracle 12c Release 2 database.
You create theSALES_EVALreal-time materialized view (MV) on theSALES, CUSTOMERS, andPRODUCTStables, which supportsCOMPLETE REFRESHby executing these statements.

There is a constraint on thePRODUCTStable withENABLE, NOVALIDATE, andRELYattributes. No updates have been done toSALES, CUSTOMERS, orPRODUCTSsince the MV was created. From where are rows returned and why?

• A. from theSALES_EVALMV because theQUERY_REWRITE_ENABLEDsetting permits rewrites on unverified constraints if the table is not stale
• B. from theSALES, CUSTOMERS, andPRODUCTS tables becauseQUERY_REWRITE_INTEGRITYis set to TRUSTED
• C. from theSALES, CUSTOMERS, andPRODUCTStables because the column in theGROUP BYclause is different from theSALES_EVALMV definition
• D. from theSALES, CUSTOMERS, andPRODUCTStables because the columns used in theSELECTlist are different from theSALES_EVALMV definition
• E. from theSALES_EVALMV because theWHEREclause in the query and in theSALES_EVALdefinition are the same

Answer: E

NEW QUESTION 16
In which four situations does theRMAN DUPLICATEcommand use the “pull” method? (Choose four.)

• A. when theUSING BACKUPSETclause is used
• B. when theSET ENCRYPTIONclause is added before theDUPLICATEcommand
• C. when theSECTION SIZEclause is used
• D. when the number of auxiliary channels allocated is less than the number of target channels allocated
• E. when theUSING COMPRESSED BACKUPSETclause is used
• F. when no auxiliary channels are allocated
• G. whenIMAGE COPIESare used for theDUPLICATEoperation

Answer: ACDE

NEW QUESTION 17
A multi-tenant container database (CDB) contains three PDBs.
Which three are prerequisites for performing a cross-platform transport of any of the PDBs? (Choose three.)

• A. The CDB should be inMOUNTstate.
• B. The source and target platforms must have the same endianness.
• C. TheCOMPATIBLEparameter must be set to 12.2 or greater in the CDB.
• D. The source PDBs must be closed for a cross-platform PDB backup.
• E. Flashback database must be enabled for the CDB.
• F. The CDB must use Automatic Memory Management.

Answer: BCD

NEW QUESTION 18
You create a refreshable copy PDB,PDB_COPY, from thePDB_ORGPDB by using theREFRESH MODE EVERY 5 MINUTESclause.
What happens every five minutes?

• A. An automatic refresh is done providedPDB_COPYis closed; otherwise the refresh is differed and attempted again after five minutes.
• B. PDB_COPYis automatically closed provided there is no ongoing transaction inPDB_ORGand then reopened as read-only after the refresh is complete.
• C. PDB_COPY’Sstate is automatically changed to read-write and back to read-only after the refresh is complete.
• D. PDB_COPY’Sstate is automatically changed to read-only and then reopened as read-write after the refresh is complete.
• E. An automatic refresh is done providedPDB_COPYis in read-only mode; otherwise the refresh is deferred and attempted again after five minutes.

Answer: E

NEW QUESTION 19
You log in to the ORCL database as SYSTEM and successfully execute these two blocks of code:

The SCOTT user has the SELECT privilege onHR.EMP.
Which statement is true about queries bynon-DBAusers with theSELECTprivilege onHR.EMP?

• A. All their queries display blanks forLAST_NAMEand the true contents of theSALARYcolumn.
• B. OnlySCOTT’Squeries display the true contents of theSALARYcolumn and blanks forLAST_NAME.
• C. All their queries display blanks forLAST_NAMEand zeroes forSALARY.
• D. OnlySCOTT’Squeries display the true contents of theSALARYandLAST_NAMEcolumns.
• E. OnlySCOTT’Squeries display zero forSALARYand the true contents of theLAST_NAMEcolumn.

Answer: A

NEW QUESTION 20
Which three statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose three.)

• A. It analyzes only those memory components of the database instance that are impacting performance.
• B. It determines the segments on which waits are occurring when the database has a high number of buffer busy waits.
• C. It analyzes the performance of the database instance based on the latest two AWR snapshots.
• D. It determines SQL statements that are performing poorly.
• E. It recommends implementing SQL profiles to generate better execution plans.
• F. It analyzes only the components and waits that are impacting database performance.

Answer: BCD

NEW QUESTION 21
......