Download 1z0-074 Lab 2021

NEW QUESTION 1
You receive complaints about poor performance in an Oracle 12c database while long running queries execute.
You must obtain statistics such as elapsed time, CPU time, number of reads and writes, I/O wait time, and other wait times for each step of each execution plan to help diagnose the problem during query execution.
How would you achieve this?

• A. by viewing Active Reports for that time period
• B. by enabling SQL trace for each query
• C. by running the Automatic Workload Repository (AWR) report for that time period
• D. by running the Active Session History (ASH) report for that time period
• E. by enabling tracing for sessions that run these queries

Answer: E

NEW QUESTION 2
You execute this command in your database:
ALTER SYSTEM SET ENCRYPT_NEW_TABLESPACES = DDL;
How does this affect the creation of tablespaces?

• A. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are not encrypted anywhere.
• B. TEMPandUNDOtablespaces are transparently encrypted with AES128 by default only in the cloud.
• C. TEMPandUNDOtablespaces are transparently encrypted with AES128 by default in an on-premise database.
• D. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are transparently encrypted with AES128 only in an on-premise database.
• E. User tablespaces with noENCRYPTIONclause specified in theCREATE TABLESPACEstatement are transparently encrypted with AES128 only in the cloud.

Answer: B

NEW QUESTION 3
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 4
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 5
In a Database Cloud Service (DBCS) environment, which pre-created user hassudoprivileges to run certainrootcommands?

• A. grid
• B. oracle
• C. opc
• D. nobody
• E. oinstall

Answer: C

NEW QUESTION 6
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 7
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 8
Identify two types of files that are generated by the Pre-Upgrade Information tool as part of the database upgrade prerequisite checks? (Choose two.)

• A. expdpscripts to export database objects belonging to the SYS schema
• B. a log file containing a list of pre-upgrade patches to be applied
• C. RMANdatabase backup scripts
• D. a log file with tool recommendations and requirements
• E. pre- and post-upgrade fixup scripts

Answer: DE

NEW QUESTION 9
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 10
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 11
TheEMP_CDB1andEMP_CDB2CDBs are in ARCHIVELOG mode. Oracle Managed Files is enabled in both CDBs.
EMP_CDB1has a PDB,EMP_PDB1.
InEMP_CDB2, you log in as theSYSuser. 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. TheAVAILABILITY MAXclause should be added to the command to ensure transaction consistency during the relocation process.
• B. SYSOPERprivilege should be granted to the user defined inEMP_LINKand used to connect to the remotedatabase.
• C. EMP_PDB2should be opened in read-write mode to complete the relocation process.
• D. EMP_PDB1should be dropped manually fromEMP_CDB1after executing the relocating command.
• E. EMP_LINKshould exist as a public link inEMP_CDB1andEMP_CDB2.
• F. OnlyEMP_PDB1should be in local undo mode.

Answer: CE

NEW QUESTION 12
ACDB,CDB1, has aLOCATIONSapplication container. NORTH_PDBandSOUTH_PDBare two application PDBs inLOCATIONS.
Both application PDBs are synchronized with the application installed in theLOCATIONS root… InCDB2, you create a remote clone,LOC_R, of theLOCATIONSapplication root.
You want to query data across theLOCATIONSapplication PDBs created inCDB1andCDB2. How can you do this?

• A. by creating a proxy PDB inLOCATIONS_ROOTinCDB1, referencingLOC_R
• B. by creating a proxy PDB inCDB1root, referencingLOC_R
• C. by using private database links created inCDB1andCDB2
• D. by using public database links created inCDB1andCDB2
• E. by creating a proxy PDB inCDB2root, referencingLOC_R

Answer: E

NEW QUESTION 13
You plan to execute this command:

Which statement is true and why?

• A. It creates partitionsP1andP2whereCOUNTRYis a single column partition key andCHANNELis a subpartition key.
• B. It returns an error because only one set of multiple values can be specified for each partition.
• C. It returns an error because only a single column key can be used for a list-partitioned table.
• D. It returns an error because theAUTOMATICoption must be specified.
• E. It creates partitionsP1andP2whereCOUNTRYandCHANNELare multi-column partition keys.

Answer: E

NEW QUESTION 14
Which three database objects can have columns stored in the In-Memory (IM) column store? (Choose three.)

• A. subpartitions
• B. clustered tables
• C. materialized views
• D. index-organized tables
• E. heap tables
• F. any SYS owned objects

Answer: BDF

NEW QUESTION 15
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 16
Examine these commands executed in thecdb1container database:

Which statement is true about thec##USER1account?

• 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 theSYSDBAprivilege.

Answer: D

NEW QUESTION 17
USER1is an OS user with the passwordoracleand is only a member of theoinstallgroup. In theORCLdatabase, theOS_AUTHEN_PREFIXvalue isops$.
Examine these commands executed by the DBA:
SQL> CREATE USER ops$user1 IDENTIFIED externally; SQL> GRANT create session TO ops$user1;
How canUSER1be given theSYSRACprivilege?

• A. MakeUser1a member of the OSDBA group in Linux or theORA_%HOMENAME%_SYSDBAgroup in Windows only.
• B. GrantSYSRACtouser1.
• C. GrantSYSRACtoops$user1.
• D. MakeUSER1a member of theOSRACDBAgroup in Linux or theORA_%HOMENAME%_SYSRACgroup in Windows.
• E. GrantSYSDBAtoops$user1

Answer: C

NEW QUESTION 18
In an Oracle 12c Release 2 database,USER1hasCREATE SESSION,CREATE PROCEDURE, andCREATEFUNCTIONprivileges.
Examine these commands:

SYSexecutes 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. TESTDBAis created with theSYSDBAprivilege only
• D. Only “3” is displayed
• E. TESTDBA is created will theSYSDBAprivilege and the message “The result is 3” is displayed

Answer: C

NEW QUESTION 19
You plan to use Information Lifecycle Management (ILM) for theORDERStable. Which is true about Heat Map statistics whenHEAT_MAPisON?

• A. They are collected for all segments except for those in theSYSTEMandSYSAUXtablespaces, and are stored in theSYSTEMtablespace.
• B. They are collected for all segments except for those in theSYSTEMandSYSAUXtablespaces, and are stored in theSYSAUXtablespace.
• C. They are collected for all segments and are stored in theSYSAUXtablespace.
• D. They are collected for all segments and are stored in theSYSTEMtablespace.
• E. They are collected only for theORDERStable if it has an associated ADO policy.

Answer: D

NEW QUESTION 20
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 21
Which two operations is theopcuser authorized to perform in an Oracle Database Cloud environment? (Choose two.)

• A. Log in to the database deployment compute node.
• B. Run some commands asroot.
• C. Run all commands asroot.
• D. Only run all commands asoracle.
• E. Only run some commands asoracle.

Answer: AC

NEW QUESTION 22
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 23
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 24
......