All Coursera Quiz Answers

Module quiz: Create, Read, Update and Delete (CRUD) Operations Quiz Answers

In this article i am gone to share Coursera Course: Introduction to Databases for Back-End Development by Meta Week 2 | Module quiz: Create, Read, Update and Delete (CRUD) Operations Quiz Answers with you..

Also visit:ย  Module quiz: Introduction to Databases Quiz Answers

 

Module quiz: Create, Read, Update and Delete (CRUD) Operations

Question 1)
The following SQL clause creates a table named staff within a database:

CREATE staff TABLE;
  • False
  • True

Question 2)
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));
  • True
  • False

Question 3)
What is the SQL command to add a new record of data in the staff table?

  • ADD INTO staff;
  • INSERT staff INTO;
  • INSERT INTO staff;

Question 4)
Which is the right command syntax to update the staff table in SQL?

  • UPDATE staff;
  • UPDATE Table staff;

Question 5)
EDIT command is used to modify data in a database table.

  • False
  • True

Question 6)
Which one of the following SQL statements updates the staff email address for the individual named โ€œKarlโ€ in the staff table?

Question 7)
Select the right keyword to complete the missing part of the following statement:

INSERT INTO staff (ID, name) ___ (7, โ€œTomโ€);
  • VALUES
  • DATA

Question 8)
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.

  • SELECT name, email, age FROM staff;
  • SELECT * FROM staff;
  • SELECT name, email AND age FROM staff;

Question 9)
The following SQL statement returns all staff phone numbers from the staff table:

SELECT phoneNumber FROM staff;
  • True
  • False

Question 10)
Which of the following SQL statements deletes all records of data from the staff table without deleting the table itself? Select all correct answers.

  • DROP TABLE staff;
  • DELETE FROM staff;
  • TRUNCATE TABLE staff;