Examine the create table statements for the stores and sales tables.SQL> CREATE TABLE stores(store_id NUMBER(4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2(12), store_addressVARCHAR2(20), start_date DATE);SQL> CREATE TABLE sales(sales_id NUMBER(4) CONSTRAINT sales_id_pk PRIMARY KEY, item_id NUMBER(4), quantity NUMBER(10), sales_dateDATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));You executed the following statement:SQL> DELETE from stores -WHERE store_id=900;The statement fails due to the integrity constraint error:ORA-02292: integrity constraint (HR.STORE_ID_FK) violatedWhich three options ensure that the statement will execute successfully?
You want to create a sales table with the following column specifications and data types:SALESID: Number -STOREID: Number -ITEMID: Number -QTY: Number, should be set to 1 when no value is specifiedSLSDATE: Date, should be set to current date when no value is specifiedPAYMENT: Characters up to 30 characters, should be set to CASH when no value is specifiedWhich statement would create the table?
Examine the data in the CUST_NAME column of the customers table.You need to display customers' second names where the second name starts with "Mc" or "MC."Which query gives the required output?
Evaluate the following query:SQL> SELECT TRUNC(ROUND(156.00, -1), -1)FROM DUAL;What would be the outcome?
You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the sameAMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.Which query will provide the required result?
Evaluate the following SQL statement:Which statement is true regarding the outcome of the above query?
