Create Next App

Exam contains 267 questions

Page 1 of 45

Question 1 🔥

Examine the description of the PRODUCTS table:Which three queries use valid expressions? (Choose three.)

Which database solution meets these requirements?

A. SELECT product_id, unit_price, S "Discount", unit_price + surcharge - discount FROM products;

Highly voted

B. SELECT product_id, (unit_price * 0.15 / (4.75 + 552.25)) FROM products;

Highly voted

C. SELECT product_id, (expiry_date - delivery_date) * 2 FROM products;

Highly voted

D. SELECT product_id, unit_price || 5 "Discount", unit_price + surcharge - discount FROM products;

Highly voted

E. SELECT product_id, expiry_date * 2 FROM products;

Highly voted

F. SELECT product_id, unit_price, unit_price + surcharge FROM products;

Highly voted

Discussion of the question

Question 2 🔥

What is true about non-equijoin statement performance? (Choose two.)

Which database solution meets these requirements?

A. The BETWEEN condition always performs less well than using the >= and <= conditions.

Highly voted

B. The BETWEEN condition always performs better than using the >= and <= conditions.

Highly voted

C. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax.

Highly voted

D. Table aliases can improve performance.

Highly voted

E. The join syntax used makes no difference to performance.

Highly voted

Discussion of the question

Question 3 🔥

Which two are true? (Choose two.)

Which database solution meets these requirements?

A. ADD_MONTHS adds a number of calendar months to a date.

Highly voted

B. CEIL requires an argument which is a numeric data type.

Highly voted

C. CEIL returns the largest integer less than or equal to a specified number.

Highly voted

D. LAST_DAY returns the date of the last day of the current month only.

Highly voted

E. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

Highly voted

F. LAST_DAY returns the date of the last day of the previous month only.

Highly voted

Discussion of the question

Question 4 🔥

Which three statements are true about Oracle synonyms? (Choose three.)

Which database solution meets these requirements?

B. A synonym can be available to all users.

Highly voted

A. A synonym cannot be created for a PL/SQL package.

Highly voted

C. A SEQUENCE can have a synonym.

Highly voted

D. Any user can drop a PUBLIC synonym.

Highly voted

E. A synonym created by one user can refer to an object belonging to another user.

Highly voted

Discussion of the question

Question 5 🔥

Which two are true? (Choose two.)

Which database solution meets these requirements?

A. CONCAT joins two character strings together.

Highly voted

B. CONCAT joins two or more character strings together.

Highly voted

C. FLOOR returns the largest positive integer less than or equal to a specified number.

Highly voted

D. INSTR finds the offset within a character string, starting from position 0.

Highly voted

E. INSTR finds the offset within a string of a single character only.

Highly voted

F. FLOOR returns the largest integer less than or equal to a specified number.

Highly voted

Discussion of the question

Question 6 🔥

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