Get real exam questions for 1z0-071 Oracle Database 12c SQL. 100% Free.
Q1. Which three statements are true regarding group functions? (Choose three.)A. They can be used on columns or expressions.B. They can be passed as an argument to another group function.C. They can be used only with a SQL statement that has the GROUP BY clause.D. They can be used on only one column in the SELECT clause of a SQL statement.E. They can be used along with the single-row function in
Q1. You execute the following commands:For which substitution variables are you prompted for the input?A. None, because no input requiredB. Both the substitution variables 'hiredate' and 'mgr_id\C. Only 'hiredate'D. Only 'mgr_id'View AnswerAnswer: BQ2. Evaluate the following SELECT statement and view the Exhibit to examine its output:SELECT constraint_name, constrain
Q1. Which three statements are true regarding the data types?A. Only one LONG column can be used per table.B. ATIMESTAMP data type column stores only time values with fractional seconds.C. The BLOB data type column is used to store binary data in an operating system file.D. The minimum column width that can be specified for a varchar2 data type column is one.E. The value for a CHAR data type colu
Q1. Which two statements are true regarding the GROUP BY clause in a SQL statement? (Choose two.)A. You can use column alias in the GROUP BY clause.B. Using the WHERE clause after the GROUP BY clause excludes the rows after creating groups.C. The GROUP BY clause is mandatory if you are using an aggregate function in the SELECT clause.D. Using the WHERE clause before the GROUP BY clause excludes t
Q1. Evaluate the following SQL statement:SQL> SELECT cust_id, cust_last_name "Last Name" FROM customersWHERE country_id = 10 UNIONSELECT cust_id CUST_NO, cust_last_name FROM customersWHERE country_id = 30;Which ORDER BY clause are valid for the above query? (Choose all that apply.)A. ORDER BY 2,1B. ORDER BY CUST_NOC. ORDER BY 2,cust_idD. ORDER BY "CUST_NO"E. ORDER BY "Last Name"View AnswerAnsw
Q1. Which two tasks can be performed by using Oracle SQL statements?A. changing the password for an existing databaseB. connecting to a database instanceC. querying data from tables across databasesD. starting up a database instanceE. executing operating system (OS) commands in a sessionView AnswerAnswer: C,EQ2. See the Exhibit and examine the structure of the PROMOTIONS table: Exhibit:Using the