📘 Free 1Z0-071 Sample Questions
You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.)
A
SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
B
SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;
C
SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
D
SELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;
E
. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
Correct Answer:
A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
Explanation:
A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;
C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
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;
Correct Answer:
B. SELECT product_id, (unit_price * 0.15/(4.75+552.25)) FROM products;
Explanation:
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;
What is true about non-equijoin statement performance? (Choose two.)
A
The BETWEEN condition always performs less well than using the >= and <= conditions.
B
The BETWEEN condition always performs better than using the >= and <= conditions.
C
The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.
D
Table aliases can improve performance.
E
The join syntax used makes no difference to performance.
Correct Answer:
D. Table aliases can improve performance.
Explanation:
D. Table aliases can improve performance.
E. The join syntax used makes no difference to performance.
Which two are true? (Choose two.)
A
. ADD_MONTHS adds a number of calendar months to a date.
B
CEIL requires an argument which is a numeric data type.
C
CEIL returns the largest integer less than or equal to a specified number.
D
LAST_DAY returns the date of the last day of the current month only.
E
LAST_DAY returns the date of the last day of the month for the date argument passed to the function.
Correct Answer:
A. . ADD_MONTHS adds a number of calendar months to a date.
Explanation:
A. ADD_MONTHS adds a number of calendar months to a date.
E. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.
Which three statements are true about Oracle synonyms? (Choose three.)
A
A synonym cannot be created for a PL/SQL package.
B
A synonym can be available to all users.
C
. A SEQUENCE can have a synonym.
D
Any user can drop a PUBLIC synonym.
E
. A synonym created by one user can refer to an object belonging to another user.
Correct Answer:
B. A synonym can be available to all users.
Explanation:
B. A synonym can be available to all users.
C. A SEQUENCE can have a synonym.
E. A synonym created by one user can refer to an object belonging to another user.
Which two are true? (Choose two.)
A
CONCAT joins two character strings together.
B
. CONCAT joins two or more character strings together.
C
. FLOOR returns the largest positive integer less than or equal to a specified number.
D
INSTR finds the offset within a character string, starting from position 0.
E
. INSTR finds the offset within a string of a single character only.
F
FLOOR returns the largest integer less than or equal to a specified number.
Correct Answer:
A. CONCAT joins two character strings together.
Explanation:
A. CONCAT joins two character strings together.
F. FLOOR returns the largest integer less than or equal to a specified number.
Which two statements are true after execution? (Choose two.)
A
. The primary key constraint will be enabled and IMMEDIATE.
B
. The foreign key constraint will be enabled and DEFERRED.
C
. The primary key constraint will be enabled and DEFERRED.
D
The foreign key constraint will be disabled.
E
The foreign key constraint will be enabled and IMMEDIATE.
Correct Answer:
A. . The primary key constraint will be enabled and IMMEDIATE.
Explanation:
A. The primary key constraint will be enabled and IMMEDIATE.
D. The foreign key constraint will be disabled.
Which two are true? (Choose two.)
A
. All existing rows in the ORDERS table are updated.
B
. The subquery is executed before the UPDATE statement is executed.
C
. The subquery is not a correlated subquery.
D
The subquery is executed for every updated row in the ORDERS table.
E
. The UPDATE statement executes successfully even if the subquery selects multiple rows.
Correct Answer:
A. . All existing rows in the ORDERS table are updated.
Explanation:
A. All existing rows in the ORDERS table are updated.
D. The subquery is executed for every updated row in the ORDERS table.
Which two statements are true about TRUNCATE and DELETE? (Choose two.)
A
DELETE can use a WHERE clause to determine which row(s) should be removed.
B
TRUNCATE can use a WHERE clause to determine which row(s) should be removed.
C
. TRUNCATE leaves any indexes on the table in an UNUSABLE state.
D
. The result of a TRUNCATE can be undone by issuing a ROLLBACK.
E
The result of a DELETE can be undone by issuing a ROLLBACK.
Correct Answer:
A. DELETE can use a WHERE clause to determine which row(s) should be removed.
Explanation:
A. DELETE can use a WHERE clause to determine which row(s) should be removed. ---> Is correct
truncate will delete every rows in a table except the table definitions.
everything except table definition or skeleton of the table
B. TRUNCATE can use a WHERE clause to determine which row(s) should be removed. ---> Its wrong bcoz
C. TRUNCATE leaves any indexes on the table in an UNUSABLE state ----- > its wrong truncate will remove
D. The result of a TRUNCATE can be undone by issuing a ROLLBACK ------ > Its wrong because TRUNCATE is a
ddl statement whereas it can be done for DELETE since its dml statement
E. The result of a DELETE can be undone by issuing a ROLLBACK ----- > Its correct because DELETE is DML
statement and each delete of row are recorded in transaction log or the redo logs.
The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted. You only want to display details of rows where START_DATE is within the last 25 months. Which WHERE clause can be used?
A
. WHERE TO_NUMBER(start_date - SYSDATE) <= 25
B
WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
C
WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
D
. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
Correct Answer:
C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
Explanation:
WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25.
Questions: 1-10 out of 374
Continue Full Practice..
GET ALL 374 QUESTIONS