Oracle 1Z0-071 Online Practice Questions and Exam Preparation

Oracle 1Z0-071 Online Questions & Answers

• Question 91:

  Examine this list of queries:

  

  Which two statements are true? (Choose two.)

  A. 1 and 4 give the same result.
  B. 2 returns the value 20.
  C. 2 and 3 give the same result.
  D. 3 returns an error.
  E. 1 and 4 give different results.
  A. 1 and 4 give the same result.
  B. 2 returns the value 20.

• Question 92:

  In the PROMOTIONS table, the PROMO_BEGIN_DATE column is of data type DATE and the default date format is DD-MON-RR.

  Which two statements are true about expressions using PROMO_BEGIN_DATE contained in a query? (Choose two.)

  A. TO_NUMBER(PROMO_BEGIN_DATE) ?5 will return a number.
  B. PROMO_BEGIN_DATE ?SYSDATE will return a number.
  C. PROMO_BEGIN_DATE ?SYSDATE will return an error.
  D. PROMO_BEGIN_DATE ?5 will return a date.
  E. TO_DATE(PROMO_BEGIN_DATE * 5) will return a date.
  B. PROMO_BEGIN_DATE ?SYSDATE will return a number.
  D. PROMO_BEGIN_DATE ?5 will return a date.

• Question 93:

  Which two statements are true regarding the EXISTS operator used in the correlated subqueries? (Choose two.)

  A. The outer query stops evaluating the result set of the inner query when the first value is found.
  B. It is used to test whether the values retrieved by the inner query exist in the result of the outer query.
  C. It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.
  D. The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.
  A. The outer query stops evaluating the result set of the inner query when the first value is found.
  C. It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.

  ---

  Explanation/Reference:

  References: http://www.techonthenet.com/oracle/exists.php

• Question 94:

  Which two statements are true about the ORDER BY clause? (Choose two.)

  A. In a character sort, the values are case-sensitive.
  B. NULLS are not included in the sort operation.
  C. Numeric values are displayed in descending order if they have decimal positions.
  D. Column aliases can be used in the ORDER BY clause.
  E. Only columns that are specified in the SELECT list can be used in the ORDER BY clause.
  A. In a character sort, the values are case-sensitive.
  D. Column aliases can be used in the ORDER BY clause.

• Question 95:

  Examine the description of the PRODUCTS table:

  

  You successfully execute this command:

  CREATE TABLE new_prices (prod_id NUMBER(2), price NUMBER(8,2))

  Which two statements execute without errors? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  C. Option C
  D. Option D

• Question 96:

  Examine the description of the PRODUCTS table:

  

  Which three queries use valid expressions? (Choose three.)

  A. SELECT product_id, unit_price, S "Discount", unit_price + surcharge - discount FROM products;
  B. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;
  C. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;
  D. SELECT product_id, unit_price || 5 "Discount", unit_price + surcharge - discount FROM products;
  E. SELECT product_id, expiry_date * 2 FROM products;
  F. SELECT product_id, unit_price, unit_price + surcharge FROM products;
  B. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;
  C. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;
  F. SELECT product_id, unit_price, unit_price + surcharge FROM products;

• Question 97:

  Which statement is true about Data Manipulation Language (DML)?

  A. DML automatically disables foreign ley constraints when modifying primary key values in the parent table.
  B. Each DML statement forms a transaction by default.
  C. A transaction can consist of one or more DML statements.
  D. DML disables foreign key constraints when deleting primary key values in the parent table, only when the ON DELETE CASCADE option is set for the foreign key constraint.
  C. A transaction can consist of one or more DML statements.

• Question 98:

  Examine the description of the transactions table:

  

  Which two SQL statements execute successfully?

  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 DATE, amount + 100 "DUES" FROM transactions;
  D. SELECT customer_id AS CUSTOMER_ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;
  E. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
  A. SELECT customer_id AS "CUSTOMER_ID", transaction_date AS "DATE", amount + 100 DUES FROM transactions;
  D. SELECT customer_id AS CUSTOMER_ID, transaction_date AS TRANS_DATE, amount + 100 "DUES AMOUNT" FROM transactions;

• Question 99:

  Which two statements will return the names of the three employees with the lowest salaries? (Choose two.)

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  B. Option B
  C. Option C

• Question 100:

  You execute the SQL statement:

  

  What is the outcome?

  A. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.
  B. It succeeds and CITY can contain only `SEATTLE' or null for all rows.
  C. It fails because the condition for the CNAMES constraint is not valid.
  D. It succeeds and an index is created for CITIZEN_ID.
  A. It fails because the NOT NULL and DEFAULT options cannot be combined for the same column.