Create Next App

Exam contains 339 questions

Page 14 of 57

Question 79 🔥

Which three statements are true regarding sub queries? (Choose three.)

Which database solution meets these requirements?

A. Multiple columns or expressions can be compared between the main query and sub query

Highly voted

B. Main query and sub query can get data from different tables

Highly voted

C. Sub queries can contain GROUP BY and ORDER BY clauses

Highly voted

D. Main query and sub query must get data from the same tables

Highly voted

E. Sub queries can contain ORDER BY but not the GROUP BY clause

Highly voted

F. Only one column or expression can be compared between the main query and subqeury

Highly voted

Discussion of the question

Question 80 🔥

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 81 🔥

Where can sub queries be used? (Choose all that apply)

Which database solution meets these requirements?

A. field names in the SELECT statement

Highly voted

B. the FROM clause in the SELECT statement

Highly voted

C. the HAVING clause in the SELECT statement

Highly voted

D. the GROUP BY clause in the SELECT statement

Highly voted

E. the WHERE clause in only the SELECT statement

Highly voted

F. the WHERE clause in SELECT as well as all DML statements

Highly voted

Discussion of the question

Question 82 🔥

Which statement correctly describes SQL and /SQL*Plus?

Which database solution meets these requirements?

A. Both SQL and /SQL*plus allow manipulation of values in the database.

Highly voted

B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements.

Highly voted

C. /SQL*Plus is a language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server.

Highly voted

D. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database.

Highly voted

Discussion of the question

Question 83 🔥

Which four are types of functions available in SQL? (Choose 4)

Which database solution meets these requirements?

Discussion of the question

Question 84 🔥

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