Examine these statements and results SQL> SELECT COUNT(*) FROM emp COUNT(*) --------------------- 14 sQL> CREATE GLOBAL TEMPORARY TABLE t emp As SELECT * FROM emp; Table created SQL> INSERT INTo temp SELECT * FROM emp; 14 rows created SQL> COMMIT: Commit complete* SQL> INSERT INTo temp SELECT * EROM emp; 14. rows created SQL> SELECT COUNT(*) FROM t emp How many rows are retrieved by the last query?

Examine the structure of the MEMBERS table:Name Null? Type------------------ --------------- ------------------------------MEMBER_ID NOT NULL VARCHAR2 (6)FIRST_NAME VARCHAR2 (50)LAST_NAME NOT NULL VARCHAR2 (50) ADDRESS VARCHAR2 (50)You execute the SQL statement:SQL > SELECT member_id, ' ' , first_name, ' ' , last_name "ID FIRSTNAME LASTNAME " FROM members;What is the outcome?

Which three statements are true reading subqueries? (Choose three.)

View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it iscreated with the ON DELETE CASCADE option. Which DELETE statement would execute successfully?

Examine the structure of the INVOICE table.Which two SQL statements would execute successfully?

View the Exhibit and examine the structure in the DEPARTMENTS tables. (Choose two.)Examine this SQL statement:SELECT department_id "DEPT_ID", department_name, 'b' FROM departmentsWHERE departments_id=90UNIONSELECT department_id, department_name DEPT_NAME, 'a' FROM departmentsWHERE department_id=10Which two ORDER BY clauses can be used to sort the output?

View the exhibit and examine the structure of the CUSTOMERS table.Which two tasks would require subqueries or joins to be executed in a single statement?

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

You must write a query that prompts users for column names and conditions every time it is executed.The user must be prompted only once for the table name.Which statement achieves those objectives?

Which three statements are true regarding subqueries? (Choose three.)

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

View the exhibit and examine the structure of ORDERS and CUSTOMERS tables. ORDERS Name Null? Type ORDER_ID NOT NULL NUMBER(4) ORDER_DATE NOT NULL DATE ORDER_MODE VARCHAR2(8) CUSTOMER_ID NOT NULL NUMBER(6) ORDER_TOTAL NUMBER(8, 2) CUSTOMERS Name Null? Type CUSTOMER_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 whose CUS

Which statement correctly grants a system privilege?

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data?(Choose four.)

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

View the Exhibit and examine the structure of the CUSTOMERS table.Using the CUSTOMERS table, you must generate a report that displays a credit limit increase of 15% for all customers.Customers with no credit limit should have Not Available displayed.Which SQL statement would produce the required result?

Examine the structure of the EMPLOYEES table. (Choose two.) You must display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would provide the correct output?

A non-correlated subquery can be defined as __________. (Choose the best answer.)

Which two are SQL features?

Which two statements are true regarding roles? (Choose two.)

Examine the description of the PRODUCT_DETAILS table:Which two statements are true? (Choose two.)

Which three statements are true about Structured Query Language (SQL)? (Choose three.)

View the Exhibit and examine the structure of CUSTOMERS table.Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for allcustomers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.Which SQL statement would produce the required result?

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index-organized table. (Choose two.) Evaluate this SQL statement: ALTER TABLE emp DROP COLUMN first_name; Which two statements are true?

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.) You executed this UPDATE statement: UPDATE ( SELECT order_date, order_total, customer_id FROM orders) Set order_date = '22-mar-2007' WHERE customer_id IN (SELECT customer_id FROM customers WHERE cust_last_name = 'Roberts' AND credit_limit = 600); Which statement is true regarding the execution?