Chapter 5, Problem 7RQ

Does the DBMS or the user make the choice of which index to use to accomplish a given task?

Which of the following keywords allows the user to delete a record from a table, even if rows in another table reference the record through a FOREIGN KEY constraint? a. CASCADE b. CASCADE ON DELETE c. DELETE ON CASCADE d. DROP e. ON DELETE CASCADE

What are the benefits of sorting a table versus using a query to sort records? Which method is more productive? Why?

6. Delete all the records in "student" table. Enter your answer 7. Delete a record in "student" table where its id is 1. Enter your answer 8. Get only the "name" and "birthdate" of the "student" table where its "name" starts with "Jo" Enter your answer

CREATE TABLE keyvalue (  id SERIAL,  key VARCHAR(128) UNIQUE,  value VARCHAR(128) UNIQUE,  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),  updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),  PRIMARY KEY(id) ); Add a stored procedure so that every time a record is updated, the updated_at variable is automatically set to the current time