Practice More Questions From: Module quiz: Create, Read, Update and Delete (CRUD) Operations
Q:
The following SQL clause creates a table named staff within a database: CREATE staff TABLE;
Q:
The following SQL statement creates a table named staff, with two columns called name and address: CREATE TABLE staff (name VARCHAR(100), address VARCHAR(100));
Q:
What is the SQL command to add a new record of data in the staff table?
Q:
Which is the right command syntax to update the staff table in SQL?
Q:
EDIT command is used to modify data in a database table.
Q:
Which one of the following SQL statements updates the staff email address for the individual named “Karl” in the staff table?
Q:
Select the right keyword to complete the missing part of the following statement: INSERT INTO staff (ID, name) ___ (7, “Tom”);
Q:
A staff table consists of three columns called name, email and age. Which of the following SQL statements selects all available data in all three columns in the staff table? Select all correct answers.
Q:
The following SQL statement returns all staff phone numbers from the staff table: SELECT phoneNumber FROM staff;
Q:
Which of the following SQL statements deletes all records of data from the staff table without deleting the table itself? Select all correct answers.
Subscribe
0 Comments
