Create Next App

Exam contains 267 questions

Page 5 of 45

Question 25 🔥

Which three statements are true about single-row functions? (Choose three.)

Which database solution meets these requirements?

A. They return a single result row per table.

Highly voted

B. They can be nested to any level.

Highly voted

C. They can accept only one argument.

Highly voted

D. The argument can be a column name, variable, literal or an expression.

Highly voted

E. They can be used only in the WHERE clause of a SELECT statement.

Highly voted

F. The data type returned can be different from the data type of the argument.

Highly voted

Discussion of the question

Question 26 🔥

Which two statements are true about *_TABLES views? (Choose two.)

Which database solution meets these requirements?

A. USER_TABLES displays all tables owned by the current user.

Highly voted

B. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in USER_TABLES.

Highly voted

C. All users can query DBA_TABLES successfully.

Highly voted

D. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in DBA_TABLES.

Highly voted

E. ALL_TABLES displays all tables owned by the current user.

Highly voted

F. You must have ANY TABLE system privileges, or be granted object privileges on the table, to view a table in ALL_TABLES.

Highly voted

Discussion of the question

Question 27 🔥

Which two statements are true about conditional INSERT ALL? (Choose two.)

Which database solution meets these requirements?

A. Each row returned by the subquery can be inserted into only a single target table.

Highly voted

B. A single WHEN condition can be used for multiple INTO clauses.

Highly voted

C. Each WHEN condition is tested for each row returned by the subquery.

Highly voted

D. It cannot have an ELSE clause.

Highly voted

E. The total number of rows inserted is always equal to the number of rows returned by the subquery.

Highly voted

Discussion of the question

Question 28 🔥

Which two statements are true about the COUNT function? (Choose two.)

Which database solution meets these requirements?

A. COUNT(*) returns the number of rows in a table including duplicate rows and rows containing NULLs in any column.

Highly voted

B. It can only be used for NUMBER data types.

Highly voted

C. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

Highly voted

D. COUNT(inv_amt) returns the number of rows in a table including rows with NULL in the INV_AMT column

Highly voted

E. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.

Highly voted

Discussion of the question

Question 29 🔥

The EMPLOYEES table contains columns EMP_ID of data type NUMBER and HIRE_DATE of data type DATE.You want to display the date of the first Monday after the completion of six months since hiring.The NLS_TERRITORY parameter is set to AMERICA in the session and, therefore, Sunday is the first day of the week.Which query can be used?

Which database solution meets these requirements?

A. SELECT emp_id, ADD_MONTHS(hire_date, 6), NEXT_DAY('MONDAY') FROM employees;

Highly voted

B. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 1) FROM employees;

Highly voted

C. SELECT emp_id, NEXT_DAY(MONTHS_BETWEEN(hire_date, SYSDATE), 6) FROM employees;

Highly voted

D. SELECT emp_id, NEXT_DAY(ADD_MONTHS(hire_date, 6), 'MONDAY') FROM employees;

Highly voted

Discussion of the question

Question 30 🔥

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