Oracle Oracle Certifications 1Z0-072 Questions & Answers

• Question 41:

  What three are true about Oracle Flashback technology? (Choose three.)

  A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.

  B. FLASHBACK TABLE can be used to rewind a table back in time.

  C. FLASHBACK DATABASE can be used to rewind a database back and forth in time.

  D. FLASHBACK TABLE can be used to undo dropping a column from a table.

  E. FLASHBACK QUERY can be used to view committed data at any given point in time.

  Correct Answer: ACD

• Question 42:

  Which three types of files are created by expdp operations? (Choose three.)

  A. SQL files

  B. dump files

  C. reject files

  D. log files

  E. input data files

  F. bad files

  G. control files

  Correct Answer: ABD

  Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_export.htm#g1022624

• Question 43:

  In your database, you want to create a tablespace of non-standard block size by using this command:

  

  Which is a requirement for this command to succeed?

  A. All other DB_nK_CACHE_SIZE parameters should be set to zero.

  B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.

  C. The value of the DB_CACHE_SIZE parameter should not be 16 KB.

  D. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.

  E. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.

  Correct Answer: B

• Question 44:

  Your client application and Oracle database are located on different hosts. Which statement is true about establishing a connection between them?

  A. Oracle Connection Manager must be installed on the client.

  B. Net service names must be configured on both the client and database servers.

  C. The Listener Control utility must be installed on the client if you are using the default listener on the server.

  D. Only Oracle Net can be used.

  E. Oracle Net Listener is required.

  Correct Answer: D

  Reference: https://docs.oracle.com/cd/E25178_01/server.1111/e25789/dist_pro.htm

• Question 45:

  Which three failures do not require intervention for recovery? (Choose three.)

  A. user process failure

  B. media failure

  C. statement failure

  D. network interface card (NIC) failure

  E. transaction failure

  Correct Answer: ACE

• Question 46:

  A database is configured to use automatic undo management with temporary undo enabled. An update is executed on a heap-organized table stored in the TBS1 tablespace. Where is the undo stored?

  A. in the SYSAUX tablespace

  B. in the undo tablespace

  C. in the redo logs

  D. in rollback segments

  E. in the temporary tablespace

  Correct Answer: A

• Question 47:

  Which action helps in applying the principle of least privilege?

  A. disabling audit for users with system privileges

  B. revoking all system privileges from the SYSTEM user

  C. setting the REMOTE_OS_AUTHENT parameter to true

  D. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true

  E. restricting access to directory objects in the database

  Correct Answer: E

  Reference: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/dbseg/configuring-privilegeand-role-authorization.html#GUID-A28E6A5D-4F06-4328-AF3A-58F6F4B66B28

• Question 48:

  Which is a machine image in Oracle Cloud?

  A. the number of OCPUs and amount of memory allocated to an instance

  B. the physical persistent block storage space allocated to an instance

  C. the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance

  D. a template of a virtual hard disk of specific size without an operating system installed

  E. a template of a virtual hard disk of specific size with an installed operating system

  Correct Answer: E

  Reference: https://docs.oracle.com/en/cloud/iaas/compute-iaas-cloud/stopc/machine-image.html#GUID3CE8D227-81EC-43EF-A80B-B6D3380ED526

• Question 49:

  Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.

  Examine these steps:

  1.

  Shut down the database instance.

  2.

  Modify the parameter in the spfile with scope = SPFILE.

  3.

  Modify the parameter in a pfile.

  4.

  Use the spfile to create a pfile.

  5.

  Use the pfile to create a spfile.

  6.

  Modify the parameter in the spfile with scope = BOTH.

  7.

  Start up the database instance.

  Which are the minimum required steps in the correct order?

  A. 2, 1, 7

  B. 1, 7, 2

  C. 1, 2, 7

  D. 6, 1, 7

  E. 1, 4, 3, 5, 7

  Correct Answer: C

• Question 50:

  Which two are true about complete and incomplete recovery? (Choose two.)

  A. Uncommitted transactions will be rolled back after complete recovery completes.

  B. The database must have FLASHBACK enabled in order to perform incomplete recovery.

  C. Uncommitted transactions will be rolled back after incomplete recovery completes.

  D. Incomplete recovery is possible only when the database is open.

  E. Only incremental backups can be used to roll forward the database while performing complete recovery.

  Correct Answer: AE