Oracle 1z0-074 Exam Dumps 2021

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

Answer: A

NEW QUESTION 2
TheTESTDBcontainer database (CDB) contains two pluggable databases (PDBs),PDB1andPDB2. USER1is a local user inPDB1and has theSYSBACKUPprivilege.
Connect descriptors for PDB1 and PDB2 are mapped to TNS aliasespdb1andPDB2intnsnames.ora. Examine these commands executed by USER1 when all PDBs are open:

What is the outcome and why?

• A. An error is returned because the user is connected to a pluggable database.
• B. The current date is displayed.
• C. An error is returned because SQL commands cannot be executed from RMAN without using the SQL shell syntax:SQL”<command>”.
• D. An error is returned because the user is notSYS.
• E. An error is returned because the user is not a common user.

Answer: C

NEW QUESTION 3
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 4
To which two components does the term “shape” refer in Oracle Database Cloud Service (DBaaS)? (Choose two.)

• A. number of network interface cards (NICs)
• B. number of database instances
• C. number of CPUs
• D. amount of RAM
• E. number of storage LUNs

Answer: CD

NEW QUESTION 5
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 6
Which statement is true about Trace File Analyzer (TFA) Collector?

• A. TFA collects diagnostic data only for Oracle 12c Release 2 databases or later versions.
• B. If TFA is installed on any cluster node, it automatically collects diagnostic data on all other cluster nodes.
• C. It can be used to collect diagnostic data for predefined events, and can be configured to automatically collect data for other events.
• D. In Oracle 12c Release 2, TFA installation can be done only while executingroot.sh.
• E. It is used to collect diagnostic data only for ORA-600, ORA-7445, and ORA-4031 events.

Answer: D

NEW QUESTION 7
One of your databases supports an OLTP workload.
If a better plan is discovered for a statement, then you want that plan to be used. Which two can cause better plans to be used for a statement? (Choose two.)

• A. adaptive cursor sharing
• B. using literals in SQL statements
• C. SQL Access Advisor
• D. SQL Performance Analyzer
• E. adaptive execution plans

Answer: CE

NEW QUESTION 8
You create a new application container,SALES_APP, with applicationPDBs,SALES1_PDB, andSALES2_PDB.
You want to install theNEW_APPapplication inSALES1_PDBandSALES2_PDBby 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 theSALES1_PDBandSALES2_PDBapplication containers.
• D. BEGIN/END INSTALLstatements should be executed in the application root and the SYNC statement inSALES1_PDBandSALES2_PDB.
• E. BEGIN/END INSTALLstatements should be executed in the CDB root and the SYNC statement in the application root.

Answer: AD

NEW QUESTION 9
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 10
InTESTDB, U1hasSYSDBAprivileges and the passwordOracle_4U. You recreate the password file:
$ orapwd FILE=orapwtestdb FORMAT=12.2 password=Oracle_123 ENTRIES=5 Examine the command and result:
$ sqlplus u1/Oracle_4U@testdb as sysdba ERROR:
ORA-01017: invalid username/password; logon denied What can you do to fix this error?

• A. Recreate the password file with the password set toOracle_4U.
• B. Change the password ofU1 to Oracle_123.
• C. Set theREMOTE_LOGIN_PASSWORDFILEparameter value to NONE.
• D. RegrantSYSDBA to U1.
• E. Restart the database instance.

Answer: A

NEW QUESTION 11
You set the maximum size of the diagnostic collection repository by issuing this command asroot.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. Thetfact1command fails because it can be set only by the Oracle software owner.
• B. TFA collects new diagnostic data if theMax 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.

Answer: A

NEW QUESTION 12
TheORCLCDB has a PDB,ORCL_PDB.
Examine these parameters inORCL:

Examine these parameters inORCL_PDB:

You switch toORCL_PDBand plan to execute these commands:

What will be the outcome?

• A. SGA_TARGETis set to 600M.The other values remain unchanged in bothORCLandORCL_PDB.
• B. SGA_TARGETis set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
• C. The other values remain unchanged in bothORCLandORCL_PDB.
• D. SGA_TARGETandSGA_MAX_SIZEare set to 600M andDB_CACHE_SIZEto 200M inORCL_PD
• E. SGA_TARGETandSGA_MAX_SIZEare set to (1360-600)M andDB_CACHE_SIZEto 200M inORCL.
• F. Altering theDB_CACHE_SIZEresults in an error becauseSGA_TARGETshould be altered to 600M first.
• G. Altering theDB_CACHE_SIZEresults in an error because it cannot be altered in a PD
• H. SGA_TARGETsize is changed to 600 M.

Answer: D

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

Answer: EF

NEW QUESTION 14
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 15
You create and enable a unified audit policy on a database that has the default auditing configuration.

The OE user, who has the DBA role, executes these statements.

What is true about the SELECT statement and why?

• A. It is audited because unified auditing is disabled be default.
• B. It is audited because, by default, the database is in mixed auditing mode with default policies enabled.
• C. It is audited because, by default, all user activities in the database are audited.
• D. It is not audited because the table belongs to another schemA.
• E. It is not audited because audit records are stored only when unified auditing is enabled in the database.

Answer: C

NEW QUESTION 16
TheCOMPATIBLEparameter is set to 12.2.0.0.0.
Which two statements are true about SQL identifier lengths? (Choose two.)

• A. Disk group, PDB, and tablespace names are limited to 30 bytes.
• B. Table names can be as long as 128 bytes.
• C. Database names can be as long as 30 bytes.
• D. Database link names can be as long as 30 bytes.
• E. Database names can be as long as 128 bytes.

Answer: BE

NEW QUESTION 17
You notice a large number oflatch: cache buffers lru chain and latch: cache buffers chainswait events.
Which four might be reasons for these? (Choose four.)

• A. The same small number of blocks are repeatedly accessed by different sessions simultaneously.
• B. The buffer cache is undersized.
• C. Cursors are closed explicitly after each execution.
• D. A large number of connected user sessions are idle.
• E. DBWR is not writing the dirty buffers fast enough.
• F. Blocks are ageing out of the buffer cache frequently.
• G. Too many sort operations are being performed.

Answer: AEFG