View the Exhibit and examine the structure of the products table. All products have a list price. You issue the following command to display the total price of each product after a discount of 25% and a tax of 15%…
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE. Examine the sample output: Which query will provide the required output? A. Option A B. Option B C. Option C D. Option D
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 same AMOUNT_SOLD even if this causes the output to exceed 5…
You issued the following command: SQL> DROP TABLE employees; Which three statements are true? A. All uncommitted transactions are committed. B. All indexes and constraints defined on the table being dropped are also dropped. C. Sequences used in the employees…
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 specified SLSDATE: Date, should be set to current…
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_address VARCHAR2(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_date…
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? A. Option A B. Option B C.…
Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL; What would be the outcome? A. 16 B. 100 C. 160 D. 200 E. 150
View the Exhibit and examine the structure of the products table. Evaluate the following query: What would be the outcome of executing the above SQL statement? A. It produces an error. B. It shows the names of all products in…
View the Exhibits and examine the structures of the products, sales, and customers tables. You need to generate a report that gives details of the customer’s last name, name of the product, and the quantity sold for a customers in…