Create Next App

Exam contains 267 questions

Page 9 of 45

Question 49 🔥

Examine the description of the PRODUCT_DETAILS table:Which two statements are true? (Choose two.)

Which database solution meets these requirements?

A. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it.

Highly voted

B. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it.

Highly voted

C. PRODUCT_NAME cannot contain duplicate values.

Highly voted

D. EXPIRY_DATE cannot be used in arithmetic expressions.

Highly voted

E. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.

Highly voted

F. PRODUCT_ID can be assigned the PRIMARY KEY constraint.

Highly voted

Discussion of the question

Question 50 🔥

Examine the description of the EMPLOYEES table:Which two queries will result in an error? (Choose two.)A.B.C.D.E.F.

Question 51 🔥

You create a table named 123.Which statement runs successfully?

Which database solution meets these requirements?

A. SELECT * FROM TABLE(123);

Highly voted

B. SELECT * FROM "123";

Highly voted

C. SELECT * FROM \'123\';

Highly voted

D. SELECT * FROM '123';

Highly voted

Discussion of the question

Question 52 🔥

Which two statements are true regarding indexes? (Choose two.)

Which database solution meets these requirements?

A. An update to a table can result in updates to any or all of the table's indexes.

Highly voted

B. An update to a table can result in no updates to any of the table's indexes.

Highly voted

C. A UNIQUE index can be altered to be non-unique.

Highly voted

D. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped.

Highly voted

E. A table belonging to one user cannot have an index that belongs to a different user.

Highly voted

Discussion of the question

Question 53 🔥

Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)? (Choose two.)

Which database solution meets these requirements?

A. The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.

Highly voted

B. None of the set operators can be used when selecting CLOB columns.

Highly voted

C. There must be an equal number of columns in each SELECT list.

Highly voted

D. Each SELECT statement in the query can have an ORDER BY clause.

Highly voted

E. The FOR UPDATE clause cannot be specified.

Highly voted

Discussion of the question

Question 54 🔥

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