gs gs115 SQL Database - SQL Drop Table - 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 7 multiple choice questions (MCQs) to prepare and belongs to topic SQL Database. 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 of the following command is used to delete the structure of a table in SQL?
DELETE
DROP
ERASE
TRUNCATE
Question 2: In SQL, the DROP command can be put under which of the following category?
DDL (Data Definition Language)
DML (Data Manipulation Language)
DCL (Data Control Language)
TCL (Transaction Control Language)
Question 3: Which of the following statement is used to delete a table in SQL?
DROP TABLE
DROP table_name
DROP TABLEtable_name
DROP TABLE (table_name)
Question 4: Which of the following statement is used to drop multiple tables at once in SQL?
DROP TABLE table_name1&table_name2&…table_namen;
DROP TABLE table_name1, table_name2,…table_namen;
DROP table_name1, table_name2,…table_namen;
DROP TABLE table_name1 table_name2 …. table_namen;
Question 5: In SQL, which of the following statement is used to conditionally drop a table that already exists?
DROP TABLE IF EXISTS table_name
DROP TABLE IF NOT EXISTS table_name
DROP TABLE EXISTS table_name
DROP TABLE NOT EXISTS table_name
Question 7: Which of the following statement is used to drop a table present in another database?
DROP TABLE table_name.dbo.database_name
DROP TABLE database_name.table_name
DROP TABLE table_name.database_name
DROP TABLE database_name.dbo.table_name
