The details of the order ID, order date, order total, and customer ID are obtained from the ORDERS table. If the order value is more than 30000, the details have to be added to the LARGEjDRDERS table. The order ID,…

View the Exhibit and examine the details of the EMPLOYEES table. Evaluate the following SQL statement: SELECT phone_number, REGEXP_REPLACE(phone_number,'([[: digit: ]]{3}).([[: digit: ]]{3}).([[: digit: ]]{4})’, ,(1)2-3′) "PHONE NUMBER" FROM employees; The query was written to format the PHONE_NUMBER for the…

View the Exhibit and examine the structure of the ORDERS table. Which task would require subqueries? A. displaying the total order value for sales representatives 161 and 163 B. displaying the order total for sales representative 161 in the year…

Which statements are correct regarding indexes? (Choose all that apply.) A. When a table is dropped, the corresponding indexes are automatically dropped. B. For each DML operation performed, the corresponding indexes are automatically updated. C. Indexes should be created on…

Evaluate the following SQL statements that are issued in the given order: CREATE TABLE emp (emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY, enameVARCHAR2(15), salary NUMBER(8,2), mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp); ALTER TABLE emp DISABLE CONSTRAINT emp_emp_no_pk CASCADE; ALTER TABLE emp…

Which statement is true regarding Flashback Version Query? A. It returns versions of rows only within a transaction. B. It can be used in subqueries contained only in a SELECT statement. C. It will return an error if the undo…

Which two statements are true regarding roles? (Choose two.) A. A role can be granted to itself. B. A role can be granted to PUBLIC. C. A user can be granted only one role at any point of time. D.…

View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table: ALTER TABLE emp ADD CONSTRAINT emp_id_pk PRIMARY KEY (emp_id) USING INDEX emp_id_idx; Which statement is…

The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement? A. PUBLIC should be replaced with…

View the Exhibit and examine the data in ORDERS_MASTER and MONTHLYjDRDERS tables. Evaluate the following MERGE statement: MERGE INTO orders_master o USING monthly_orders m ON (o.order_id = m.order_id) WHEN MATCHED THEN UPDATE SET o.order_total = m.order_total DELETE WHERE (m.order_total IS…