gs gs115 SQL Database - SQL Create 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 create a table in SQL?
CREATE
MAKE
DEVELOP
INSERT
Question 2: In SQL, the CREATE 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 5: Which of the following constraint are not present in SQL?
UNIQUE
NOT NULL
PRIMARY KEY
CANDIDATE KEY
Question 6: Which of the following is not a valid datatype in SQL?
INT
NUMBER
VARCHAR
DATE
Question 10: Which of the following SQL statement is used to create a table by copying only the selected columns from another table?
CREATE TABLE new_tablename AS ( SELECT * from old_tablename where condition);CREATE TABLE new_tablename AS ( SELECT Column1, Column2...Columnn from old_tablename);CREATE TABLE new_tablename AS ( SELECT Column1, Column2...ColumnN from old_tablename1, old_tablename2...old_tablenamen);CREATE TABLE table_name (column1 datatype constraint column2 datatype constraint column3 datatype constraint ... columnn datatype constraint);
