QUESTION 173 Choose two . Examine the description of the SALES table: Name -------------------------------PRODUCT_ID CUSTOMER_ID TIME_ID CHANNEL_ID PROMO_ID QUANTITY_SOLD PRICE AMOUNT_SOLD Examine this statement: CREATE TABLE sales1 ( prod_ id, cust_ id, quantity_ sold, price) AS SELECT product_ id, customer_ id, quantity_ sold, price FROM sales WHERE 1 = 1 ; Which two statements are true?

QUESTION 174 Choose two . Examine this query: SELECT ∗ FROM bricks , colors; Which two statements are true?

QUESTION 175 Choose two . Which two are true about unused columns?

QUESTION 176 Choose two . Which two are true about virtual columns?

QUESTION 177 Choose two . Which two are SQL features?

QUESTION 179 Choose two . Examine the description of the CUSTOMERS table: Name Null? Type ---------------------------------------------------------------CUSTOMER_ID CUSTOMER_NAME INSERT_ DATE NOT NULL NOT NULL NOT NULL NUMBER( 38) VARCHAR2 ( 100) DATE Which two statements will do an implicit conversion? A) SELECT ∗ FROM customers WHERE customer_id = '0001' ; B) SELECT ∗ FROM customers WHERE TO_CHAR (customer_id) = '0001' ; C) SELECT ∗ FROM customers WHERE customer_ id = 0001; D ) SELECT ∗ FROM customers WHERE insert_date = '01-JAN-19' ; E) SELECT ∗ FROM customers WHERE insert_date = DATE '2019-01-01' ; Answer: AD 18 5 、 Choose two. Which two statements are true about CURRENT_ TIMESTAMP?

QUESTION 180 Choose two . Examine the description of the EMPLOYEES table: Name Null? Type ------------------------------------------------------------------EMPLOYEE_ID FIRST_NAME LAST_NAME SALARY NOT NULL NOT NULL NUMBER (3 ) VARCHAR2 ( 15) VARCHAR2 ( 15) NUMBER(6 ,2 ) Which two queries will result in an error?

QUESTION 181 Choose two . Examine the description of the PRODUCTS table which contains data: Name Null? Type ----------------------------------------------------------------------------PROD_ID PROD_NAME EXPIRY_ DATE NOT NULL NOT NULL NUMBER (2 ) VARCHAR2 (20) DATE Which two are true?

QUESTION 182 Choose two . Which two are true about transactions in the Oracle Database?

QUESTION 187 Choose two Examine the description of the EMPLOYEES table: Name Null? Type--------------------------------------------------------------------------------------EMP_ID NOT NULL EMP_NAME DEPT_ ID SALARY NUMBER VARCHAR2 (40) NUMBER (2 ) NUMBER(8 , 2 ) DATE HIRE_ DATE NLS_DATE_FORMAT is DD-MON-RR. Which two queries will execute successfully?

QUESTION 189 Choose three. You currently have an active transaction in your session and have been granted SELECT access to V$TRANSACTION. Executing: SELECT xid, status FROM v$transaction; .in Your session returns: XID STATUS --------------------------------------------0A0007000A070000 ACTIVE In Which three situations will re-executing this query still return a row but with a different XID, indicating a new transaction has started?

QUESTION 190 Choose three.Which three statements are true about indexes and their administration in an Oracle database?

QUESTION 193 Choose two.Which two are true?

QUESTION 194 Choose two.Which two are true about scalar subquery expressions?

QUESTION 195 Choose two.Examine the description of the ORDER_ITEMS table: Name Null? Type -------------------------------------------------------------------------ORDER_ID PRODUCT_ID QUANTITY UNIT_PRICE NUMBER(38) NUMBER(38) NUMBER(38) NUMBER( 10 , 2 ) Examine this incomplete query: SELECT DISTINCT quantity ∗ unit_price total_paid FROM order_items ORDER BY ; Which two can replace so the query completes successfully?