Create Next App

Exam contains 339 questions

Page 4 of 57

Question 19 🔥

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

Which database solution meets these requirements?

A. ALTER TABLE SPLIT PARTITION

Highly voted

B. ALTER TABLE MERGE PARTITION

Highly voted

C. ALTER TABLE TRUNCATE PARTITION

Highly voted

D. ALTER TABLE ADD PARTITION

Highly voted

E. ALTER TABLE DROP PARTITION

Highly voted

F. ALTER TABLE MOVE PARTITION

Highly voted

Discussion of the question

Question 20 🔥

View the Exhibit and examine the structure of the products table.Using the products table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.The query generates an error. What is the reason for the error?

Which database solution meets these requirements?

A. The parenthesis should be added to enclose the entire expression.

Highly voted

B. The double quotation marks should be removed from the column alias.

Highly voted

C. The column alias should be replaced with the expression in the where clause.

Highly voted

D. The column alias should be put in uppercase and enclosed within double quotation marks in the where clause.

Highly voted

Discussion of the question

Question 21 🔥

Evaluate these two SQL statements:SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC;SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC;What is true about them?

Which database solution meets these requirements?

A. The two statements produce identical results.

Highly voted

B. The second statement returns a syntax error.

Highly voted

C. There is no need to specify DESC because the results are sorted in descending order by default.

Highly voted

D. The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement. A

Highly voted

Discussion of the question

Question 22 🔥

Which four are attributes of single row functions? (Choose four.)

Which database solution meets these requirements?

A. cannot be nested

Highly voted

B. manipulate data items

Highly voted

C. act on each row returned

Highly voted

D. return one result per row

Highly voted

E. accept only one argument and return only one value

Highly voted

F. accept arguments which can be a column or an expression

Highly voted

Discussion of the question

Question 23 🔥

See the Exhibit and examine the structure of the PROMOSTIONS table:Exhibit:Which SQL statements are valid? (Choose all that apply.)

Which database solution meets these requirements?

A. SELECT promo_id, DECODE(NVL(promo_cost, 0), promo_cost, promo_cost * 0.25, 100) "Discount" FROM promotions;

Highly voted

B. SELECT promo_id, DECODE(promo_cost, 10000, DECODE(promo_category, 'G1', promo_cost *.25, NULL), NULL) "Catcost" FROM promotions;

Highly voted

C. SELECT promo_id, DECODE(NULLIF(promo_cost, 10000), NULL, promo_cost*.25, 'N/A') "Catcost" FROM promotions;

Highly voted

D. SELECT promo_id, DECODE(promo_cost, >10000, 'High', <10000, 'Low') "Range" FROM promotions;

Highly voted

Discussion of the question

Question 24 🔥

Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?

Which database solution meets these requirements?

A. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

Highly voted

B. It produces an error because positional notation cannot be used in the order by clause with set operators.

Highly voted

C. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

Highly voted

D. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_061

Exam contains 339 questions

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

Company

Product

Resources

Follow us