Free 1z0-082 – Oracle Database Administration I Practice Test Question

Select all that apply, then click Submit answer.

• ○

  The second ROLLBACK command does nothing

• ○

  The second ROLLBACK command replays the delete

• ○

  The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed

• ○

  The second ROLLBACK command undoes the insert

• ○

  The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
  
  

Select all that apply, then click Submit answer.

• ○

  The Oracle join syntax supports creation of a Cartesian product of two tables

• ○

  The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax

• ○

  The SQL:1999 compliant ANSI join syntax supports natural joins

• ○

  The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables

• ○

  The Oracle join syntax only supports right outer joins

• ○

  The Oracle join syntax supports natural joins

• ○

  The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
  
  

Select all that apply, then click Submit answer.

• ○

  MOD : returns the quotient of a division operation

• ○

  FLOOR : returns the smallest integer greater than or equal to a specified number

• ○

  TRUNC : can be used with NUMBER and DATE values

• ○

  CONCAT : can be used to combine any number of values

• ○

  CEIL : can be used for positive and negative numbers
  
  

Select all that apply, then click Submit answer.

• ○

  Data block headers contain their own Data Block Address (DBA)

• ○

  A table row piece can be chained across several database blocks

• ○

  Multiple row pieces from the same row may be stored in different database blocks

• ○

  Multiple row pieces from the same row may be stored in the same block

• ○

  Data block free space is always contiguous in the middle of the block

• ○

  Index block free space is always contiguous in the middle of the block
  
  

Select all that apply, then click Submit answer.

• ○

  You can no longer monitor it

• ○

  You can reattach to it and monitor it

• ○

  It is paused and can be resumed

• ○

  It continues to run in the background

• ○

  It terminates
  
  

Select an option, then click Submit answer.

• ○

  Dynamic service registration cannot be used for this database instance

• ○

  The LREG process registers services dynamically with the LISTENER_1 listener

• ○

  LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration

• ○

  There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances

• ○

  The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
  
  

Select an option, then click Submit answer.

• ○

  The command succeeds and HR will be connected to the orcl and abc.sql databases

• ○

  The command succeeds and HR will be connected to the orcl database instance, and the abc.sql script will be executed

• ○

  The command fails because the script must refer to the full path name

• ○

  The command fails and reports an error because @ is used twice
  
  

Select an option, then click Submit answer.

• ○

  It succeeds and the generated undo is stored in SYSTEM.

• ○

  It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'”.

• ○

  It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

• ○

  It succeeds and the generated undo is stored in SYSAUX.

• ○

  It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.
  
  

Select an option, then click Submit answer.

• ○

  COLUMN STORE COMPRESS FOR QUERY LOW

• ○

  ROW STORE COMPRESS BASIC

• ○

  COLUMN STORE COMPRESS FOR ARCHIVE LOW

• ○

  COLUMN STORE COMPRESS FOR ARCHIVE HIGH

• ○

  ROW STORE COMPRESS ADVANCED
  
  

Select an option, then click Submit answer.

• ○

  SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND due_amount IS NOT NULL;

• ○

  SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND cust_credit_level !=NULL;

• ○

  SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level <> NULL
  AND due_amount <> NULL;

• ○

  SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level != NULL
  AND due_amount != NULL;

• ○

  SELECT cust_first_name, cust_credit_limit * .05 AS DUE_AMOUNT
  FROM customers
  WHERE cust_income_level IS NOT NULL
  AND cust_credit_limit IS NOT NULL;