Oracle 1z0-074 Dumps 2021

NEW QUESTION 1
U1.T1is in a tablespaceTBS_UNCMPwhich has no default compression andU1.T2is in a tablespace,TBS_CMPwith default compression for query low.
You execute commands:

Which three statements are true? (Choose three.)

• A. The primary key constraints onT1are dropped
• B. T1is in the TBS_UNCMP tablespace
• C. T1is in the TBS_CMP tablespace
• D. T1is in compressed format
• E. T1is in uncompressed format
• F. All indexes onT1remain valid

Answer: ACE

NEW QUESTION 2
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 settingSORT_AREA_SIZEto 200 MB.
• B. You cannot limit PGA for a set of database user sessions.
• C. You can limit their PGA usage by settingPGA_AGGREGATE_LIMITto 200 MB.
• D. You can limit their PGA usage by settingPGA_AGGREGATE_TARGETto 200 MB.
• E. You can limit their PGA usage by setting theSESSION_PGA_LIMITdirective by using Database ResourceManager

Answer: C

NEW QUESTION 3
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 4
Which two are true about the ADR retention advisor in Oracle Database 12c Release 2? (Choose two.)

• A. ESTIMATE (SHORTP_POLICY = 192)estimates the space requirement based on theSHORTP_POLICYvalue of 192 minutes.
• B. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 2160)estimates the space requirement based on current ADR diagnostics file space usage.
• C. ESTIMATE (SIZEP_POLICY = 209715200)estimates only the long retention policy.
• D. ESTIMATE (SHORTP_POLICY = 192, LONGP_POLICY = 8760)provides estimates that users can use to setSIZEP_POLICY.
• E. ESTIMATE (SIZEP_POLICY = 209715200)estimates the value ofLONGP_POLICY.

Answer: DE

NEW QUESTION 5
The In-Memory compression level is set toMEMCOMPRESS FOR QUERY HIGH. For what purpose is this optimized?

• A. for parallel query performance only
• B. for query performance and space saving
• C. for query performance and space saving with greater bias toward space saving
• D. for query performance only
• E. for space saving only

Answer: B

NEW QUESTION 6
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 7
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 inCDB$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 thePDB_LOCKDOWNparameter 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.

Answer: BC

NEW QUESTION 8
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 9
Which two statements are true about FLEX ASM? (Choose two.)

• A. A database instance on any node can connect to an ASM instance on any node.
• B. A separate ASM network is required.
• C. It is impossible to connect to a database instance on one node if the database password file for the same database is corrupt on another node in the cluster.
• D. Database instances that depend on an ASM instance that is terminated fail over to a node that has a surviving ASM instance.
• E. Database instances that depend on an ASM instance that is terminated connect to a surviving ASMinstance.

Answer: DE

NEW QUESTION 10
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 11
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 12
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 13
In which situation can the optimizer choose a hash join?

• A. when a non-equijoin is used and the join column in at least one of the tables is a primary key
• B. when a non-equijoin is used and the join column for both tables is a primary key
• C. when a non-equijoin is used between a table and a sorted hash cluster
• D. when an equality operator is used
• E. when any self-join is done

Answer: D

NEW QUESTION 14
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 15
In a database on an Oracle Exadata Database machine, a DBA executes this command: SQL> exec DBMS_INMEMORY_ADMIN.ENABLE_FASTSTART (‘fs_tbs’);
What is the result?

• A. All columns for all tables in theFS_TBStablespace are loaded into the In-Memory column store.
• B. Any data in the In-Memory column store is copied in compressed columnar format to theFS_TBS tablespace.
• C. Any data in the In-Memory column store is copied in uncompressed columnar format to theFS_TBS tablespace.
• D. Any data in the In-Memory column store is copied in row major format to theFS_TBStablespace.

Answer: A

NEW QUESTION 16
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 17
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