Create Next App

Exam contains 267 questions

Page 4 of 45

Question 19 🔥

Examine this partial command:Which two clauses are required for this command to execute successfully? (Choose two.)

Which database solution meets these requirements?

A. the access driver TYPE clause

Highly voted

B. the DEFAULT DIRECTORY clause

Highly voted

C. the REJECT LIMIT clause

Highly voted

D. the LOCATION clause

Highly voted

E. the ACCESS PARAMETERS clause

Highly voted

Discussion of the question

Question 20 🔥

Which two are true about unused columns? (Choose two.)

Which database solution meets these requirements?

A. A query can return data from unused columns, but no DML is possible on those columns.

Highly voted

B. Unused columns retain their data until they are dropped.

Highly voted

C. Once a column has been set to unused, a new column with the same name can be added to the table.

Highly voted

D. The DESCRIBE command displays unused columns.

Highly voted

E. A primary key column cannot be set to unused.

Highly voted

F. A foreign key column cannot be set to unused.

Highly voted

Discussion of the question

Question 21 🔥

Which two are true about the precedence of operators and conditions? (Choose two.)

Which database solution meets these requirements?

A. || has a higher order of precedence than + (addition).

Highly voted

B. + (addition) has a higher order of precedence than * (multiplication).

Highly voted

C. NOT has a higher order of precedence than AND and OR in a condition.

Highly voted

D. AND and OR have the same order of precedence in a condition.

Highly voted

E. Operators are evaluated before conditions.

Highly voted

Discussion of the question

Question 22 🔥

In your session, the NLS_DATE_FORMAT is DD-MM-YYYY.There are 86400 seconds in a day.Examine this result:DATE ------------02-JAN-2020Which statement returns this?

Which database solution meets these requirements?

A. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

Highly voted

B. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY - INTERVAL '360' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

Highly voted

C. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

Highly voted

D. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY - INTERVAL '86410' SECOND, 'DD-MON- YYYY') AS "date" FROM DUAL;

Highly voted

E. SELECT TO_CHAR(TO_DATE('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY - INTERVAL '120' SECOND, 'DD-MON-YYYY') AS "date" FROM DUAL;

Highly voted

Discussion of the question

Question 23 🔥

Examine the data in the INVOICES table:Examine the data in the CURRENCIES table:Which query returns the currencies in CURRENCIES that are not present in INVOICES?A.B.C.D.

Question 24 🔥

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