Examine the structure of the PROMOTIONS table in the following Exhibit. 

You issued the following SQL statement: > SELECT PROMO_NAME, CASE WHEN PROMO_COST >= (SELECT AVG(PROMO_COST) FROM PROMOTIONS WHERE PROMO_CATEGORY=’TV’) THEN ‘HIGH’ ELSE ‘LOW’ END COST_REMARK FROM PROMOTIONS; 

Which from the following statements is true about the result of the above query?

You need to display the date 11-oct-2007 in a words format, as ‘eleven of october of two thousand seven'. 

Which from the following SQL statements will produce the required result?

Evaluate the CREATE TABLE statements for the STORE and SALES tables. 

>CREATE TABLE stores (store_id NUMBER (4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2 (12), store_addressVARCHAR2 (20), start_date DATE); > CREATE TABLE sales (sales_id NUMBER (4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER (4), NUMBER (10), sales_dateDATE, store_id NUMBER (4), CONSTRAINT store_id_fk FOREIGN KEY (store_id) REFERENCES stores (store_id)); 

You issued the following statement: 

> DELETE from stores -WHERE store_id = 900; It fails due to the integrity constraint error: ORA-02292: integrity constraint (HR.STORE_ID_FK) violated. 

Which of the following options would assure the statement is successfully executed? (Select three.)

Which of the following tasks can be performed using integrated SQL functions in an Oracle Database? (Select three.)

Analyze the structure of the PRODUCT, COMPONENT and PDT_COMP tables in the Exhibit. 

In the PRODUCT table, PDTNO is the primary key. In the COMPONENT table, COMPNO is the primary key. In the PDT_COMP table,

Examine the structure of the SALES table in the following Exhibit. 

The following query is issued to recover all products ID from the SALES table that have sold more than 55000 and have been ordered more than 10 times. 

> SELECT PROD_ID FROM SALES WHERE QUANTITY_SOLD > 55000 AND COUNT (*) 

> 10 GROUP BY PROD_ID HAVING COUNT(*) > 10;

 Which statement is true regarding the above SQL statement?

You have to generate a report in which the credit limit has been incremented by $1000 for each customer. 

In the output, the heading Name will be used for customer’s last names and New Credit Limit will be the heading for the incremented credit limit. 

Only the first letter of each word should be in uppercase in the column headings. Which from the following statements would satisfy the requirement?

Analyze the description of the SALES and PROMOTIONS tables in the following Exhibit.

 In order to remove rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has the blowout sales of every day low prices as values, 

which of th following DELETE statements are valid? (Select three.)