7. What is the result of executing the following SQL statement? UPDATE employee SET salary = 50000 WHERE salary < 50000; The statement sets the salary for each employee to a value below 50,000. The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000. The statement sets the salary to 50,000 for each employee whose salary is below 50,000. The statement always sets the salary of each and every employee to 50,000 None of the above QUESTION 8 What is the proper SQL Statement to add a column called DEPTCODE that accepts 4 alphanumeric characters to a table called ΕMPLOYE? INSERT INTO TABLE EMPLOYEE (DEPTCODE CHAR(4)); UPDATE EMPLOYEE SET DEPTCODE TO CHAR(4); ALTER TABLE EMPLOYEE ADD (DEPTCODE CHAR(4)); ADD COLUM DEPTCODE CHAR(4) TO EMPLOYEE;

7. What is the result of executing the following SQL statement? UPDATE employee SET salary = 50000 WHERE salary < 50000; The statement sets the salary for each employee to a value below 50,000. The statement sets the salary of each employee to 50,000 and ensures that the salary cannot drop below 50,000. The statement sets the salary to 50,000 for each employee whose salary is below 50,000. The statement always sets the salary of each and every employee to 50,000 None of the above QUESTION 8 What is the proper SQL Statement to add a column called DEPTCODE that accepts 4 alphanumeric characters to a table called ΕMPLOYE? INSERT INTO TABLE EMPLOYEE (DEPTCODE CHAR(4)); UPDATE EMPLOYEE SET DEPTCODE TO CHAR(4); ALTER TABLE EMPLOYEE ADD (DEPTCODE CHAR(4)); ADD COLUM DEPTCODE CHAR(4) TO EMPLOYEE;

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
Given the following SQL statement, which statement is most accurate?SELECT customer# FROM customersJOIN orders USING(customer#)WHERE shipdate-orderdate IN(SELECT MAX(shipdate-orderdate) FROM ordersWHERE shipdate IS NULL);a. The SELECT statement fails and returns an Oracle error message.b. The outer query displays no rows in its results because the subquery passes a NULLvalue to the outer query.c. The customer number is displayed for customers whose orders haven’t yet shipped.d. The customer numbers of all customers who haven’t placed an order are displayed
Database: CUSTOMER (CustomerID, LastName, FIrstName, Phone, EmailAddress) PURCHASE (InvoiceNumber, InvoiceDate, PreTaxAmount, CustomerID) PURCHASE_ITEM (InvoiceNumber, InvoiceLineNumber, Item Number, RetailPrice) ITEM (ItemNumber, ItemDesciption, Cost, ArtistLastName, ArtistFirstName) Write an SQL statement to show which cutomers bought which items, and include any items that have not been sold. Include CUSTOMER.LastName, CUSTOMER.FirstName, IvoiceNumber, InvoiceDate, ItemNumber, ItemDescription, ArtistLastName, and ArtistFirstName,. Use a join using JOIN ON syntax, and sort the results by ArtistLastName and ArtistFirstName in ascending order. Note that in Microsoft Access this require multiple queries. From Database Concepts 9th Ed. (Kroenke)
The following two SQL statements will produce the same results. SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE P_QOH >(SELECT P_QOH FROM PRODUCT WHERE P_CODE='11QER/31') AND P_PRICE>(SELECT P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); SELECT P_DESCRIPT, P_QOH,P_PRICE FROM PRODUCT WHERE (P_QOH,P_PRICE) > (SELECT P_QOH,P_PRICE FROM PRODUCT WHERE P_CODE='11QER/31'); A) True B) False
QUESTION 18 The following SQL Query: SELECT partnameFROM quoteWHERE UPPER(suppliername) = 'TOOL TIME, INC.'; is MORE efficient than: suppliername = UPPER(suppliername);SELECT partnameFROM quoteWHERE suppliername = 'TOOL TIME, INC.'; because the second set of SQL commands uses two statements to turn the text into uppercase and then test it. a. True b. False
SELECT customer.LastName, COUNT(Orders.OrderID) As NumberOfOrdersFROM orders, customersWHERE customer.customerID = Orders.CustomerIDGROUP BY LastNameHAVING COUNT(Orders.OrderID) > 18;a) What is the purpose of the COUNT function in this SQL statement? 2b) What is the purpose of the GROUP BY command in this SQL statement? 3c) What is the purpose of the HAVING command in this SQL statement? 3d) How would you modify this SQL query so that it shows the orders for customers 2called ‘Smith’ regardless of how many orders have been made?
SELECT P.BRAND_ID, B.BRAND_NAME, B.BRAND_TYPE,MAX(AVGPRICE) FROM LGPRODUCT P INNER JOIN LGBRAND B ON P.BRAND_ID = B.BRAND_ID (SELECT P.BRAND_ID, AVG (P.PROD_PRICE) AS AVGPRICE FROM LGPRODUCT P GROUP BY P.BRAND_ID)AS AVG_PRICE GROUP BY P.BRAND_ID, B.BRAND_NAME, B.BRAND_TYPE ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT P.BRAND_ID, AVG (P.PROD_PRICE) AS AVGPRICE FROM LGPRODUCT P GROUP BY P.' at line 3
Which one of the following is not a property of Transactions? a) Atomic b) Consistency c) Backup d) Isolation e) Durability Which one of the following should be specified in the statement if an SQL SELECT statement contains a HAVING clause? a) ORDER BY b) LIKE c) ORDER BY ASC d) GROUP BY e) WHERE The “IN” operator is used to compare a single value with a set in an SQL WHERE Clause. It is equivalent to which one of the following operators? a) = b) EXISTS c) > ANY d) = ANY e) none of the above. In order for the LIKE operator to match exactly one character, which one of the following symbols should be used? a) * b) _ c) % d) & e) |
The relationship between CUSTOMER and ORDER is one-to-many. CUSTOMER table has 5 records and ORDER has 15. How many records you will get in the output if you run the following SQL statement? SELECT Customers.CustomerID, Orders.OrderIDFROM Customers, Orders; 5 15 20 75
Im trying to run the following SQL in Oracle: SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee Description')WHERE ServiceName NOT IN (SELECT FEETYPE FROM REPORT_FILTER_KR)GROUP BY GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeChargedORDER BY SUM(FeeCharged) DESC; And I'm recieving this error: Error starting at line : 1 in command -SELECT GUEST_KR.FIRSTNAME, GUEST_KR.LASTNAME,FEE_KR.DateCharged,FEE_KR.FeeDescription,FEE_KR.FeeCharged,SUM(FeeCharged) AS TotalFeeChargedFROM FEE_KRJOIN SERVICE_KR ON FEE_KR.ServiceID = SERVICE_KR.ServiceIDJOIN GUEST_KR ON SERVICE_KR.ServiceID = GUEST_KR.GuestIDWHERE ServiceName IN ('First Name', 'Last Name', 'Date Charged', 'Fee…
SQL Commands. Modify the following select statement to remove the hard-coded values $1.00 and $2.00 from the code and place them in a table of constants. The table sec0306_price_constants is already set up for you. The min_price field = 1.00 and the max_price field = 2.00.When I make a change like this, in addition to replacing the hard-coded values, I often put those values in the select clause so I can see exactly what the values are whenever I run the SQL code. select descriptionfrom l_foodswhere price between 1.00 and 2.00order by description;
The following statements are executed:create sequence my_seg; select my_seg.nextval from dual;select my_seg.nextval from dual;rollback; select my_seg.nextval from dual; What value will return when the last SQL statement is executed? Select one: a. 2b. 1c. 3d. 0e. NULL