Write SQL update statements to do the following on the database schema shown in Figure 1.2.
(a) Insert a new student <'Johnson', 25, 1, 'MATH'> in the database.
(b) Change the class of student 'Smith' to 2.
(c) Insert a new course <'Knowledge Engineering','COSC4390', 3,'COSC'>.
(d) Delete the record for the student whose name is 'Smith' and student number is 17.
(a) INSERT INTO STUDENT
VALUES ('Johnson', 25, 1, 'MATH')
(b) UPDATE STUDENT
SET CLASS = 2
WHERE Name='Smith'
(c) INSERT INTO COURSE
VALUES ('Knowledge Engineering','COSC4390', 3,'COSC')
(d) DELETE FROM STUDENT
WHERE Name='Smith' AND StudentNumber=17
You might also like to view...
Java limits the number of dimensions an array can have to four.
Answer the following statement true (T) or false (F)
What is the value of x after execution of the following code?
int x, y, z; y = 3; z = 4; x = pow (z, y); a) 7 b) 12 c) 64 d) 81
A(n) _______ allows one set of input devices to control multiple computers
Fill in the blank(s) with correct word
Your manager has given you a bash script that retrieves data for ESXi 6.x host configurations. This data needs to be collected right after the installation of a host and must be run directly on the host. Which two actions can be used to run this script on an ESXi host? (Choose two.)
A. Connect to the host with Ruby vSphere Console and run the script from there. B. Enable SSH access from the Direct Console User Interface. C. Enable the ESXi Shell from the Direct Console User Interface. D. Run the script directly from the vSphere Web Client.