Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 81:

  Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

  A. An undo segment may be used by multiple transactions simultaneously
  B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
  C. Undo segments have a minimum of three extents
  D. Undo segments can extend when a transaction fills the last extent of the undo segment
  E. A single transaction may use multiple undo segments simultaneously
  F. Undo segments must be stored in a BIGFILE tablespace
  G. Undo segments must be stored in a SMALLFILE tablespace
  A. An undo segment may be used by multiple transactions simultaneously
  B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
  D. Undo segments can extend when a transaction fills the last extent of the undo segment

• Question 82:

  The orders table has a column ORDER_DATE of data type DATE.

  The default display format for a date is DD-MON-RR.

  Which two WHERE conditions demonstrate the correct usage of conversion functions? (Choose two.)

  A. WHERE order_date > TO_DATE(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
  B. WHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY')
  C. WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'
  D. WHERE order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
  E. WHERE order_date IN (TO_DATE('Oct 21 2018', 'Mon DD YYYY'), TO_CHAR('Nov 21 2018', 'Mon DD YYYY'))
  B. WHERE order dare > TO DATE('JUL 10 2018', 'MON DD YYYY')
  C. WHERE TO_CHAR(order date, 'MON DD YYYY') = 'JAN 20 2019'

  ---

  Explanation/Reference:

• Question 83:

  Which two statements are true about the rules of precedence for operators? (Choose two.)

  A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
  B. NULLS influence the precedence of operators in an expression
  C. The + binary operator has the highest precedence in an expression in a SQL statement
  D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
  E. Multiple parentheses can be used to override the default precedence of operators in an expression
  D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
  E. Multiple parentheses can be used to override the default precedence of operators in an expression

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm

  https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm

  Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

• Question 84:

  Which two statements are true regarding a SAVEPOINT? (Choose two.)

  A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
  B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
  C. Only one SAVEPOINT may be issued in a transaction
  D. A SAVEPOINT does not issue a COMMIT
  E. Rolling back to a SAVEPOINT can undo a DELETE statement
  D. A SAVEPOINT does not issue a COMMIT
  E. Rolling back to a SAVEPOINT can undo a DELETE statement

• Question 85:

  Examine the structure of the two tables:

  

  Which two queries execute successfully? (Choose two.)

  A. SELECT * FROM products MINUS SELECT prod_id FROM new_products;
  B. SELECT prod_id, prod_name FROM products INTERSECT SELECT 100, prod_name FROM new_products;
  C. SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id, NULL FROM new_products;
  D. SELECT * FROM products UNION SELECT * FROM new_products;
  E. SELECT prod_id FROM products UNION ALL SELECT prod_id, prod_name FROM new_products;
  C. SELECT prod_id, exp_date FROM products UNION ALL SELECT prod_id, NULL FROM new_products;
  D. SELECT * FROM products UNION SELECT * FROM new_products;

• Question 86:

  Which three files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)

  A. dump files
  B. control files
  C. password files
  D. bad files
  E. input files
  B. control files
  D. bad files
  E. input files

  ---

  Explanation/Reference:

  SQLLDR CONTROL=sample.ctl, LOG=sample.log, BAD=baz.bad, DATA=etc.dat USERID=scott/tiger, ERRORS=999, LOAD=2000, DISCARD=toss.dsc, DISCARDMAX=5

  https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_params.htm

• Question 87:

  Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

  A. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
  B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
  C. A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
  D. A GLOBAL TEMPORARY TABLE 's definition is available to multiple sessions.
  E. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
  F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
  C. A TRUNCATE command issued in a session causes all news in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
  D. A GLOBAL TEMPORARY TABLE 's definition is available to multiple sessions.
  F. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.

  ---

  Explanation/Reference:

  https://docs.oracle.com/javadb/10.8.3.0/ref/rrefdeclaretemptable.html

• Question 88:

  Examine this description of the TRANSACTIONS table:

  

  Which two SQL statements execute successfully? (Choose two.)

  A. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount + 100 "DUES" FROM transactions;
  B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
  C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
  D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
  E. SELECT customer_id AS `CUSTOMER-ID', transaction_date AS DATE, amount + 100 `DUES AMOUNT' FROM transactions;
  B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
  D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;

• Question 89:

  Examine the description of the PRODUCT_INFORMATION table:

  

  Which query retrieves the number of products with a null list price?

  A. SELECT COUNT(list_price) FROM product_information WHERE list_price IS NULL;
  B. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;
  C. SELECT COUNT(DISTINCT list price) FROM product_information WHERE list_price IS NULL;
  D. SELECT COUNT(list_price) FROM product_information WHERE list_price = NULL;
  B. SELECT COUNT(NVL(list_price, 0)) FROM product_information WHERE list_price IS NULL;

  ---

  Explanation/Reference:

• Question 90:

  Examine these statements executed in a single Oracle session:

  

  Which three statements are true? (Choose three.)

  A. The code for pen is 10.
  B. There is no row containing fountain pen.
  C. There is no row containing pen.
  D. The code for fountain pen is 3.
  E. The code for pen is l.
  F. There is no row containing pencil.
  A. The code for pen is 10.
  D. The code for fountain pen is 3.
  F. There is no row containing pencil.

  ---

  Explanation/Reference: