Create Next App

Exam contains 267 questions

Page 2 of 45

Question 7 🔥

Examine this SQL statement:Which two are true? (Choose two.)

Which database solution meets these requirements?

A. All existing rows in the ORDERS table are updated.

Highly voted

B. The subquery is executed before the UPDATE statement is executed.

Highly voted

C. The subquery is not a correlated subquery.

Highly voted

D. The subquery is executed for every updated row in the ORDERS table.

Highly voted

E. The UPDATE statement executes successfully even if the subquery selects multiple rows.

Highly voted

Discussion of the question

Question 8 🔥

Which two statements are true about TRUNCATE and DELETE? (Choose two.)

Which database solution meets these requirements?

A. DELETE can use a WHERE clause to determine which row(s) should be removed.

Highly voted

B. TRUNCATE can use a WHERE clause to determine which row(s) should be removed.

Highly voted

C. TRUNCATE leaves any indexes on the table in an UNUSABLE state.

Highly voted

D. The result of a TRUNCATE can be undone by issuing a ROLLBACK.

Highly voted

E. The result of a DELETE can be undone by issuing a ROLLBACK.

Highly voted

Discussion of the question

Question 9 🔥

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?

Which database solution meets these requirements?

A. WHERE TO_NUMBER(start_date - SYSDATE) <= 25

Highly voted

B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25

Highly voted

C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25

Highly voted

D. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE

Highly voted

Discussion of the question

Question 10 🔥

Which three are true about scalar subquery expressions? (Choose three.)

Which database solution meets these requirements?

A. They can be nested.

Highly voted

B. They cannot be used in the VALUES clause of an INSERT statement.

Highly voted

C. A scalar subquery expression that returns zero rows evaluates to zero.

Highly voted

D. They can be used as default values for columns in a CREATE TABLE statement.

Highly voted

E. A scalar subquery expression that returns zero rows evaluates to NULL.

Highly voted

F. They cannot be used in GROUP BY clauses.

Highly voted

Discussion of the question

Question 11 🔥

Examine this query:Which two methods should you use to prevent prompting for a hire date value when this query is executed? (Choose two.)

Which database solution meets these requirements?

A. Use the DEFINE command before executing the query.

Highly voted

B. Replace '&1' with '&&1' in the query.

Highly voted

C. Use the UNDEFINE command before executing the query.

Highly voted

D. Execute the SET VERIFY OFF command before executing the query.

Highly voted

E. Execute the SET VERIFY ON command before executing the query.

Highly voted

F. Store the query in a script and pass the substitution value to the script when executing it.

Highly voted

Discussion of the question

Question 12 🔥

Examine the description of the PROMOTIONS table:You want to display the unique promotion costs in each promotion category.Which two queries can be used? (Choose two.)

Which database solution meets these requirements?

A. SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM promotions ORDER BY 1;

Highly voted

B. SELECT DISTINCT promo_cost || ' in ' || DISTINCT promo_category FROM promotions ORDER BY 1;

Highly voted

C. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

Highly voted

D. SELECT promo_category DISTINCT promo_cost, FROM promotions ORDER BY 2;

Highly voted

E. SELECT promo_cost, promo_category FROM promotions ORDER BY 1;

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_071

Exam contains 267 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us