Category «1Z0-071»

Exam 1Z0-071: Oracle Database 12c SQL

What would be the outcome of the above SQL statement?

View the exhibits and examine the structures of the COSTS and PROMOTIONS tables. Evaluate the following SQL statement:SQL> SELECT prod_id FROM costsWHERE promo_id IN (SELECT promo_id FROM promotionsWHERE promo_cost < ALL(SELECT MAX(promo_cost) FROM promotionsGROUP BY (promo_end_datepromo_begin_date)));What would be the outcome of the above SQL statement? A. It displays prod IDs in the promo with the …

Which statements are true?

Which statements are true? (Choose all that apply.) A. The data dictionary is created and maintained by the database administrator. B. The data dictionary views consists of joins of dictionary base tables and user-defined tables. C. The usernames of all the users including the database administrators are stored in the data dictionary. D. The USER_CONS_COLUMNS …

Which two statements are true about the output?

Evaluate the following SELECT statement and view the exhibit to examine its output:SELECT constraint_name, constraint_type, search_condition, r_constraint_name,delete_rule, status,FROM user_constraintsWHERE table_name = ‘ORDERS’;CONSTRAINT_NAME CON SEARCH_CONDITIONR_CONSTRAINT_NAME DELETE_RULE STATUSORDER_DATE_NN C “ORDER_DATE” ISNOT NULLENABLEDORDER_CUSTOMER_ID_NNC “CUSTOMER_ID” ISNOT NULLENABLEDORDER_MODE_LOV C order _mode in(‘direct’,‘online’)ENABLEDORDER TOTAL MIN C order total >= 0 ENABLEDORDER PK P ENABLEDORDERS CUSTOMER ID R CUSTOMERS ID SET NULL …

Which statement is true regarding the above command?

View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables. The PROD_ID column is the foreign key in the SALES tables, which references the PRODUCTS table.Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing theCUSTOMERS and TIMES tables, respectively.Evaluate the following CREATE TABLE command:CREATE …

Which query gives the required output?

Examine the data in the CUST_NAME column of the CUSTOMERS table.CUST_NAME——————-Renske LadwigJason MallinSamuel McCainAllan MCEwenIrene MikilineniJulia NayerYou need to display customers’ second names where the second name starts with “Mc” or “MC”.Which query gives the required output? A. SELECT SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1) FROM customers WHERE SUBSTR (cust_name, INSTR (cust_name, ‘ ‘)+1) LIKE …

What would be the outcome?

Evaluate the following query:SQL> SELECT TRUNC (ROUND(156.00, -1),-1)FROM DUAL;What would be the outcome? A. 150 B. 200 C. 160 D. 16 E. 100 Explanation:https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions135.htmhttps://docs.oracle.com/cd/B28359_01/olap.111/b28126/dml_functions_2127.htm Show Answer

Identify the option that contains the steps in the correct sequence in which the Oracle server evaluates a correlated subquery.

The following are the steps for a correlated subquery, listed in random order:1. The WHERE clause of the outer query is evaluated.2. The candidate row is fetched from the table specified in the outer query.3. The procedure is repeated for the subsequent rows of the table, till all the rows are processed.4. Rows are returned …

Which statement describes the outcome of the FLASHBACK command?

The first DROP operation is performed on PRODUCTS table using the following command:DROP TABLE products PURGE;Then you performed the FLASHBACK operation by using the following command:FLASHBACK TABLE products TO BEFORE DROP;Which statement describes the outcome of the FLASHBACK command? A. It recovers only the table structure. B. It recovers the table structure, data, and the …