READ Free Dumps For Oracle- 1z1-051
| Question ID 4962 | Which two are true about aggregate functions? (Choose two.) |
| Option A | A. You can use aggregate functions in any clause of a SELECT statement. |
| Option B | B. You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement. |
| Option C | C. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. |
| Option D | D. You can pass column names, expressions, constants, or functions as parameter to an aggregate function. |
| Option E | E. You can use aggregate functions on a table, only by grouping the whole table as one single group. |
| Option F | F. You cannot group the rows of a table by more than one column while using aggregate functions. |
| Correct Answer | A,D |
| Question ID 4963 | Which statement correctly describes SQL and /SQL*Plus? |
| Option A | A. Both SQL and /SQL*plus allow manipulation of values in the database. |
| Option B | B. /SQL*Plus recognizes SQL statements and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements. |
| Option C | 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. |
| Option D | D. SQL manipulates data and table definitions in the database; /SQL*Plus does not allow manipulation of values in the database. |
| Correct Answer | A |