1z0-082 Practice Test

1z0-082 Practice Test practice questions, page 6 of 7, with answer review and explanations.

Question 26

In which three situations does a new transaction always start? (Choose three.)

  1. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
  2. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
  3. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
  4. when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
  5. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
  6. when issuing a DML statement after a DML statement failed in the same session

Question 27

Examine the description of the SALES1 table: SALES2 is a table with the same description as SALES1. Some sales data is duplicated in both tables. You want to display the rows from the SALES1 table which are not present in the SALES2 table. Which set operator generates the required output?

  1. INTERSECT
  2. UNION ALL
  3. UNION
  4. SUBTRACT
  5. MINUS

Question 28

Your database instance is started with a PFILE. Examine these parameters: You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; What is the outcome?

  1. The value is changed only in the PFILE and takes effect at the next instance startup
  2. The value is changed for the current instance and in the PFILE
  3. It fails because the SCOPE clause is missing
  4. Change is applied to the current instance, but does not persist after instance restart

Question 29

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

  1. Oracle Managed Files (OMF)
  2. Online table segment shrink
  3. Online index segment shrink
  4. Automatic data file extension (AUTOEXTEND)
  5. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Question 30

You execute this command: During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=immediate - Are you sure you wish to stop the job ([yes]/no): yes Which two statements are true about the job? (Choose two.)

  1. You can no longer monitor it
  2. You can reattach to it and monitor it
  3. It is paused and can be resumed
  4. It continues to run in the background
  5. It terminates