gs gs113 Using SQL to Manage Data - Table Creation - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Using SQL to Manage Data. 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 among the following is the correct syntax for creating table?
CREATE TABLE name;
CREATE name;
CREATE TABLE
All of the mentioned
Question 2: What is the role of “CONSTRAINS” in defining a table in Mysql?
Declaring primary key
Declaring Foreign Key
Restrictions on columns
All of the mentioned
Question 3: Which command is used for the table definition in Mysql?
DESC table_name;
DESC table_name
DESC
None of the mentioned
Question 4: Which among the following is the correct syntax for defining “Constraint Check” in Mysql?
gender char(1) check( gender IN (‘M’, ‘F’)),
gender char (1) check,
gender char (1) check ( gender ),
none of the mentioned
Question 5: Which data type character merges the “Check Constraint” into a data type definition?
ENUM
ENUM1
ENUM2
None of the mentioned
Question 6: Which among the following is the correct syntax for defining “ENUM” in Mysql?
gender ENUM (‘M’, ‘F’),
gender ENUM,
gender ENUM ( ),
none of the mentioned
Question 7: Which among the following are the correct definitions for “NULL” in Mysql?
Absence of value
Unknown
Empty set
All of the mentioned
Question 8: Find out the logical error in the following MySQL code snippet?
CREATE TABLE person ( person_id varchar(20), Name varchar (20), Address Varchar (20), Mobile_no Smallint );
Lesser number of columns
Incorrect definition
Primary key is missing
None of the mentioned
Question 9: What is the meaning of “REFERENCES” in table definition?
Primary key
NULL
Foreign Key
A ”foreign Key” belong to this particular table
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
