What would happen when the above statement is executed?

View the Exhibit and examine PRODUCTS and ORDER_ITEMS tables. You executed the following query to display PRODUCT_NAME and the number of times the product has been ordered: SELECT p.product_name, i.item_cnt FROM (SELECT product_id, COUNT (*) item_cnt FROM order_items GROUP BY product_id) i RIGHT OUTER JOIN products p ON i.product_id = p.product_id; What would happen when […]

Read More

Which CREATE VIEW statement would create the view successfully?

View the Exhibit and examine the data in ORDERS and ORDER_ITEMS tables. You need to create a view that displays the ORDER ID, ORDER_DATE, and the total number of items in each order. Which CREATE VIEW statement would create the view successfully? A. CREATE OR REPLACE VIEW ord_vu (order_id,order_date) AS SELECT o.order_id, o.order_date, COUNT(i.line_item_id) “NO […]

Read More

Which statement is true regarding the PROD_ID_PK constraint?

Evaluate the CREATE TABLE statement: CREATE TABLE products (product_id NUMBER(6) CONSTRAINT prod_id_pk PRIMARY KEY, product_name VARCHAR2(15)); Which statement is true regarding the PROD_ID_PK constraint? A. It would be created only if a unique index is manually created first. B. It would be created and would use an automatically created unique index. C. It would be […]

Read More

Which two statements is true regarding the above command?

View the Exhibit and examine the structure of the EMP table which is not partitioned and not an index- organized table. Evaluate the following SQL statement: ALTER TABLE emp DROP COLUMN first_name; Which two statements is true regarding the above command? (Choose two.) A. The FIRST_NAME column would be dropped provided it does not contain […]

Read More

You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted i

View the Exhibit and examine the description of the CUSTOMERS table. You want to add a constraint on the CUST_FIRST_NAME column of the CUSTOMERS table so that the value inserted in the column does not have numbers. Which SQL statement would you use to accomplish the task? A. ALTER TABLE CUSTOMERS ADD CONSTRAINT cust_f_name CHECK(REGEXP_LIKE(cust_first_name,’^A-Z’))NOVALIDATE […]

Read More