071¿¼ÊÔÌâ¿â-µÚ21Ìâ¡¢choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year....

071¿¼ÊÔÌâ¿â-µÚ22Ìâ¡¢choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. CUSTOMER_VU is a view based on CUSTOMERS_BR1 table which has the same structure as CUSTOMERS table. CUSTOMERS needs to be updated to reflect the latest information a...

071¿¼ÊÔÌâ¿â-µÚ23Ìâ¡¢choose the best answer: You need to display the first names of all customers from the CUSTOMERS table that contain the character 'e' and have the character 'a' in the second last position. Which query would give the required output? A) SELECT cust_first_na...

071¿¼ÊÔÌâ¿â-µÚ24Ìâ¡¢choose the best answer: The user SCOTT who is the owner of ORDERS and ORDER_ITEMS tables issues this GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What must be done to fix the statement? A) ALL should be replaced with a list of specific pri...

071¿¼ÊÔÌâ¿â-µÚ25Ìâ¡¢choose two: View the Exhibit and examine the data in the PRODUCT_INFORMATION table. Which two tasks would require subqueries? (Choose two.) A) displaying all supplier IDs whose average list price is more than 500 B) displaying the total number of produc...

071¿¼ÊÔÌâ¿â-µÚ26Ìâ¡¢choose two: You executed the following CREATE TABLE statement that resulted in an error: SQL CREATE TABLE employees( emp_id NUMBER(10) PRIMARY KEY, ename VARCHAR2(20), email NUMBER(3) UNIQUE, address VARCHAR2(500), phone VARCHAR2 (20), resume LONG, h...

071¿¼ÊÔÌâ¿â-µÚ27Ìâ¡¢choose the best answer: View the Exhibit and examine the structure of the CUSTOMERS table. Evaluate the following SQL statement: SQL SELECT cust_city, COUNT(cust_last_name) FROM customers WHERE cust_credit_limit 1000 GROUP BY cust_city HAVING AVG(cust...

071¿¼ÊÔÌâ¿â-µÚ28Ìâ¡¢choose two: View the Exhibit and examine the structure of the PRODUCTS table. Which two tasks would require subqueries? A) Display the minimum list price for each product status. B) Display the total number of products supplied by supplier 102 and have ...

071¿¼ÊÔÌâ¿â-µÚ29Ìâ¡¢choose the best answer: You need to produce a report where each customer's credit limit has been incremented by $1000. In the output, the customer's last name should have the heading Name and the incremented credit limit should be labeled New Credit Limit. ...

071¿¼ÊÔÌâ¿â-µÚ30Ìâ¡¢choose the best answer View the Exhibit and examine the structure of the SALES and STORES tables. You want to display the store name and the total quantity sold for each item in the store. Which SQL statement will give the required output? A) SELECT str.n...

21.choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year. Only a few empl...

071¿¼ÊÔÌâ¿â-µÚ20Ìâ¡¢choose the best answer View the Exhibit and examine the data in the PROMOTIONS table. Which SQL statement would you use? A) SELECT promo_name, promo_cost, promo_begin_date FROM promotions WHERE promo_category LIKE '%post%' AND promo_begin_date '1-JAN-00...

071¿¼ÊÔÌâ¿â-µÚ19Ìâ¡¢choose the best answer Which statement is true regarding the outcome of the above query? A) It shows COST_REMARK for all the promos in the promo category 'TV' . B) It produces an error because subqueries cannot be used with the CASE expression. C) It show...

071¿¼ÊÔÌâ¿â-µÚ18Ìâ¡¢choose the best answer Which statement is true regarding the outcome of this query? A) It executes successfully. B) It produces an error because a column used in the NATURAL join cannot have a qualifier. C) It produces an error because all columns used in...

071¿¼ÊÔÌâ¿â-µÚ17Ìâ¡¢choose the best answer View the Exhibit and examine the description of the EMPLOYEES table. Which statement is true regarding this query? A) The query would not execute because the NEXT_DAY function accepts a string as argument. B) The query would execute...

071¿¼ÊÔÌâ¿â-µÚ16Ìâ¡¢choose two View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables. You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products where...

071¿¼ÊÔÌâ¿â-µÚ15Ìâ¡¢choose the best answer What correction should be made in the above SQL statement to achieve this? A) Replace = with the ALL operator. B) Replace = with the ANY operator. C) Remove the GROUP BY clause from the subquery and place it in the main query. D) R...

071¿¼ÊÔÌâ¿â-µÚ14Ìâ¡¢choose the best answer A) Both the INSERT statements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back. B) Only the second INSERT statement would succeed because all the constraints except ...

071¿¼ÊÔÌâ¿â-µÚ13Ìâ¡¢choose the best answer Which statement is true regarding the USING clause in table joins? A) It can be used to access data from tables through equijoins as well as nonequijoins. B) It can be used to join tables that have columns with the same name and comp...

071¿¼ÊÔÌâ¿â-µÚ12Ìâ¡¢choose the best answer Evaluate the following query: SQL SELECT promo_name || q'{'s start date was \}' || promo_begin_date AS "Promotion Launches" FROM promotions; What would be the outcome of the above query? A) It produces an error because the data ty...

071¿¼ÊÔÌâ¿â-µÚ11Ìâ¡¢choose the best answer Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS: SQL CREATE TABLE DEPARTMENT_DETAILS (DEPARTMENT_ID NUMBER PRIMARY KEY, DEPARTMENT_NAME VARCHAR2(50) , HOD VARCHAR2(50)); SQL CREATE TABLE COURSE_DETAILS (...

071¿¼ÊÔÌâ¿â-µÚ10Ìâ¡¢choose the best answer Which statement is true regarding the outcome of the above query? A) It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement. B) It executes successfu...

071¿¼ÊÔÌâ¿â-µÚ9Ìâ¡¢choose two Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? A) Only the second DELETE statement is rolled back. B) No SQL statements are rolled back. C) Both the DELETE statements and the UPDATE ...

071¿¼ÊÔÌâ¿â-µÚ8Ìâ¡¢choose two Examine the structure of the PRODUCTS table. Which two statements are true? A) EXPIRY_DATE always stores date and time in character format B) PRICE can store a maximum of eight digits and two decimals. C) PRODUCT_PIC can store only videos. D...

071¿¼ÊÔÌâ¿â-µÚ7Ìâ¡¢choose the best answer Evaluate the following SQL statement: ALTER TABLE hr.emp SET UNUSED (mgr_id); Which statement is true regarding the effect of the above SQL statement? A) Any views created on the EMP table that include the MGR_ID column would be aut...

071¿¼ÊÔÌâ¿â-µÚ6Ìâ¡¢choose the best answer In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years. Evaluate the following SQL statement: SQL UPDATE employees SET salary = NVL(salary,0) + NVL(comm,0),comm = NVL(comm,0) WHERE...

071¿¼ÊÔÌâ¿â-µÚ5Ìâ¡¢choose the best answer Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQ...

071¿¼ÊÔÌâ¿â-µÚ4Ìâ¡¢choose the best answer View the Exhibits and examine PRODUCTS and SALES tables. You issue the following query to display product name and the number of times the product has been sold: SQLSELECT p.prod_name, i.item_cnt FROM (SELECT prod id, COUNT(*) item_...

071¿¼ÊÔÌâ¿â-µÚ3Ìâ¡¢choose three View the Exhibit and examine the description of SALES and PROMOTIONS tables. You want to delete rows from the SALES table, where the PROMO_NAME column in the PROMOTIONS table has either blowout sale or everyday low price as values. Which thre...

071¿¼ÊÔÌâ¿â2¡¢choose two Examine the description of the EMP_DETAILS table given below: Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table? A) You cannot add a new column to the table with LONG as the data type. B) An EMP_I...