Chapter 1, Problem 2.14CP

Write the following constraint in correct form with a number for the RHS. Supervisory labor hours (SL) can be no more the one-fourth the amount of Factory Labor (FL) hours.

a) Start a transaction. b) Delete the production company named Searchlight from the production table. c) List all the data in your table production. d) Rollback the transaction. e) List all the data in your table production.

[ [ Commit The schedule above is for the transactions T1, T2, and T3 1- explain whether it is a serializable or not 2- explain whether that cause cascading aborts If any of the transactions aborts 3- Propose a modification to the given schedule draw it and explain how it produces a deadlock (you may include new R and W operations for any of the transactions), in your new schedule a deadlock must be produced when the strict two-phase locking protocol is used.

What are the necessary conditions for a deadlock to occur? Provide a brief explanation of each condition.

Products_UPDATE should check DiscountPercent. This trigger should error if discount % is 100 or less. This trigger doubles the new discount % from 0–1. A.20% discount. Check this trigger.

Given the following function Oracle user account: Jsmith Profile: Manager_prof Password verify function: Good_Pwd_Fun As a DBA, you will write SQL commands to accomplish the following tasks: a. Change Jsmith password to CatChasedog! b. Add the password verification function to the profile  c. Add the profile to Jsmith d. Set smith password expire

When a new transaction should be entered using a recurring transaction, an alert is generated.

a. Display the employees where the salary is 2200-Upload Screen shot b. Display the employees where the salary is above 2000- Upload Screen shot c. Display the employees where the salary is greater than 2000 and the age is less than 25- Upload Screen shot d. Display only the Top 3 records from the employee table - Upload Screen shot e. Delete the employee whose ID is 2 - Upload Screen shot f. Display again only the Top 3 records from the employee table - Upload Screen shot

44. In SCAN – EDF, requests with the same deadlines are ordered according to : a. SCAN policy b. EDF policy c. FCFS policy d. FIFO policy