Category «1Z0-071»

What is the output of this query?

Examine the following query:SQL> SELECT prod_id, amount_soldFROM salesORDER BY amount_soldFETCH FIRST 5 PERCENT ROWS ONLY;What is the output of this query? A. It displays 5 percent of the products with the highest amount sold. B. It displays the first 5 percent of the rows from the SALES table. C. It displays 5 percent of the …

Which statement is true regarding the INTERSECT operator?

Which statement is true regarding the INTERSECT operator? A. The names of columns in all SELECT statements must be identical. B. It ignores NULL values. C. Reversing the order of the intersected tables alters the result. D. The number of columns and data types must be identical for all SELECT statements in the query. Explanation:http://oraclexpert.com/using-the-set-operators/

Which statement is true about transactions?

Which statement is true about transactions? A. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction. B. Each Data Definition Language (DDL) statement executed forms a single transaction. C. A set of DDL statements executed in a sequence ending with a COMMIT forms a …

What could be the reason for this?

View the exhibit and examine the description of the DEPARTMENTS and EMPLOYEES tables. The retrieve data for all the employees for their EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT NAME, thefollowing SQL statement was written:SELECT employee_id, first_name, department_nameFROM employeesNATURAL JOIN departments;The desired output is not obtained after executing the above SQL statement. What could be the reason forthis? …

Which statements are correct regarding indexes?

Which statements are correct regarding indexes? (Choose all that apply.) A. A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index. B. Indexes should be created on columns that are frequently referenced as part of any expression. C. When a table is dropped, the corresponding indexes are automatically dropped. …

Which INSERT statement should be used to add a row into

View the exhibit and examine the structure of ORDERS and CUSTOMERS tables.ORDERSName Null? TypeORDER_ID NOT NULL NUMBER(4)ORDER_DATE NOT NULL DATEORDER_MODE VARCHAR2(8)CUSTOMER_ID NOT NULL NUMBER(6)ORDER_TOTAL NUMBER(8, 2)CUSTOMERSName Null? TypeCUSTOMER_ID NOT NULL NUMBER(6)CUST_FIRST_NAME NOT NULL VARCHAR2(20)CUST_LAST_NAME NOT NULL VARCHAR2(20)CREDIT_LIMIT NUMBER(9,2)CUST_ADDRESS VARCHAR2(40)Which INSERT statement should be used to add a row into the ORDERS table for the customer …