Chapter 5, Problem 10MC

Name      Null? Type          --------- ----- ------------  GIFT            VARCHAR2(15)  MINRETAIL       NUMBER(5,2)   MAXRETAIL       NUMBER(5,2)     Based on the structure of the PROMOTION table, which of the following commands will add a PRIMARY KEY constraint to the GIFT column? ​   1. CREATE constraint promo_pk (gift VARCHAR2(15) PRIMARY KEY; 2.   ALTER TABLE promotion MODIFY constraint promo_pk (gift PRIMARY KEY);   3.   ALTER TABLE promotion SET constraint promo_pk PRIMARY KEY gift;   4.   ALTER TABLE promotion ADD constraint promo_pk PRIMARY KEY(gift);

Write a script that creates and calls a stored procedure named spInsertDepartment. First, code a statement that creates a procedure that adds a new row to the Departments table. To do that, this procedure should have one parameter for the department name. Code at least two EXEC statements that test this procedure. (Note that this table does not allow duplicate department names.)

Which of the following statements places a shared lock on at least a portion of a table named HOMEWORK10?a. SELECT * FROM homework10 WHERE col2 IS NULL FOR UPDATE;b. INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, ‘B’, ‘C’);c. UPDATE homework10 SET col3 = NULL WHERE col1 = ‘A’;d. UPDATE homework10 SET col3 = LOWER (col3) WHERE col1 = ‘A’;e. all of the above