6 of 6
Paper No: 1
Picture 7.1
Question 8:
[1] Write a query to insert a new event into the Events table with data:name =Tech Expo, start time =2024-03-20 09:00:00, end time= 2025-03-20 17:00:00, and location id = LOC001
Question 9:
[1] Write a query to update the StartTime of events where a specific staff member (e.g.,staffID = 2) is involved, by delaying the start time by 2 hours.
Question 10:
[1] Create a stored procedure named proc_Staffs with the following parameters: @StaffIDINT, @NewPhone VARCHAR(15) to update the employee phone number by given parameters
Zoom
+ 100%
Close
