1z0-062

1z0-062 practice questions, page 8 of 16, with answer review and explanations.

Question 36

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
gt; sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command? (Choose two.)

  1. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
  2. It fails because no SQL *Loader data file location is specified.
  3. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
  4. It fails because no SQL *Loader control file location is specified.

Question 37

After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: After changing the value, you notice that FULL redaction continues to redact numeric data with zero. What must you do to activate the new default value for numeric full redaction?

  1. Re-enable redaction policies that use FULL data redaction.
  2. Re-create redaction policies that use FULL data redaction.
  3. Re-connect the sessions that access objects with redaction policies defined on them.
  4. Flush the shared pool.
  5. Restart the database instance.

Question 38

You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions? (Choose two.)

  1. Enable supplemental logging for the database.
  2. Specify undo retention guarantee for the database.
  3. Create a Flashback Data Archive in the tablespace where the tables are stored.
  4. Create a Flashback Data Archive in any suitable tablespace.
  5. Enable Flashback Data Archiving for the tables that require tracking.

Question 39

You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the tables indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?

  1. Oracle Data Pump.
  2. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
  3. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
  4. Online Table Redefinition.
  5. Edition-Based Table Redefinition.

Question 40

To implement Automatic Management (AMM), you set the following parameters: When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup - ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information. Identify the reason the instance failed to start.

  1. The PGA_AGGREGATE_TARGET parameter is set to zero.
  2. The STATISTICS_LEVEL parameter is set to BASIC.
  3. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
  4. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.