gs gs115 SQL Database - SQL Alter 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 10 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 modify the structure of a table in SQL?
CREATE
DROP
ALTER
INSERT
Question 2: In SQL, the ALTER 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: In SQL, the ALTER command cannot be used to perform which of the following task?
Add Column
Drop Column
Modify Column
Restore Column
Question 4: In SQL, which of the following statement can be used to add a column to an existing table using the ALTER command?
ALTER TABLE table_name ADD column_name datatype;ALTER table_name ADD column_name datatype;ALTER TABLE table_name column_name datatype;ALTER TABLE ADD column_name datatype;
Question 5: In SQL, which of the following statement can be used to drop a column from an existing table using the ALTER command?
ALTER table_name DROP COLUMN column_name;ALTER TABLE table_name DROP column_name;ALTER TABLE table_name DROP COLUMN column_name;ALTER TABLE DROP COLUMN column_name;
Question 6: In SQL, which of the following statement can be used to modify a column in an existing table using the ALTER command?
ALTER TABLE table_name MODIFY COLUMN column_name datatype;ALTER table_name MODIFY COLUMN column_name datatype;ALTER TABLE table_name MODIFY COLUMN datatype;ALTER TABLE table_name COLUMN column_name datatype;
Question 8: In SQL, which of the following statement can be used to add a constraint in an existing table using the ALTER command?
ALTER TABLE table_name ADD CONSTRAINT constraint_name (condition/column_name);ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint_type (condition/column_name);ALTER TABLE table_name ADD CONSTRAINT constraint_type (condition/column_name);ALTER TABLE table_name ADD constraint_name constraint_type (condition/column_name);
Question 9: In SQL, which of the following statement can be used to drop a constraint from an existing table using the ALTER command?
ALTER TABLE table_name DROP CONSTRAINT/INDEX constraint_name;ALTER TABLE table_name CONSTRAINT/INDEX constraint_name;ALTER TABLE table_name DROP CONSTRAINT/INDEX;ALTER TABLE table_name DROP CONSTRAINT/INDEX constraint_type;
Question 10: In SQL, which of the following statement can be used to rename an existing table using the ALTER command?
ALTER TABLE RENAME TO new_table_name;ALTER table_name RENAME TO new_table_name;ALTER TABLE table_name RENAME new_table_name;ALTER TABLE table_name RENAME TO new_table_name;
