gs gs115 SQL Statements - SQL Delete Statement - Quiz No.1
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL Statements. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Which clause is used to delete existing records of a table?
Delete
Drop
Remove
Clear
Question 3: Which of the following is a correct syntax for delete statement?
Delete From table_name Where condition(s);
Delete table_name;
Delete Table table_name;
Delete From table table_name;
Question 6: By using DELETE statement, which of the following is/are not deleted permanently from a table?
Records, Attributes
Table structure, Records
Table structure, Attributes
Records, Indexes of table
Question 8: To delete records in one table based on values in another table, which clause is used?
Values
Exists
Value
Exist
Question 10: DELETE is a _________ command.
Data definition language
Data manipulation language
Data control language
Transaction control language
