Explore topic-wise MCQs in Mysql.

This section includes 15 Mcqs, each offering curated multiple-choice questions to sharpen your Mysql knowledge and support exam preparation. Choose a topic below to get started.

1.

Will this query produce any error?INSERT INTO Employee(Emp_id, fname,lname)VALUES (101, Sujit ,'Gupta'),VALUES (102, Ajit , Gupta );/* where person_id is a primary key */

A. No Error
B. Error
C. Depends
D. All of above
E. None of these
Answer» B. Error
Discussion
2.

In the following query, what does person_id stands for? CREATE TABLE Student (id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_Student PRIMARY KEY (Student_id));

A. Primary key
B. Composite key
C. Normal attribute of the table
D. Super key
E. None of these
Answer» E. None of these
Discussion
3.

In the following query, what does person stands for:INSERT INTO Student (id, fname, lname) VALUES (1, Ajit , Gupta );

A. Multivalued attributes
B. Table name
C. Composite attributes
D. All of above
E. None of these
Answer» C. Composite attributes
Discussion
4.

Find out the logical error in the following query?CREATE TABLE Employee ( Emp_id VARCHAR(50), Emp_Name VARCHAR (50), Emp_Address VARCHAR (50), Emp_Mobile_no SMALLINT );

A. Primary key is missing
B. Lesser number of columns
C. Incorrect definition
D. All of above
E. None of these
Answer» B. Lesser number of columns
Discussion
5.

Will this query produce any error?INSERT INTO Employee (Emp_id, fname,lname) VALUES (101, Sujit , Gupta ), VALUES (101, Ajit , Gupta ); /* where person_id is a primary key */

A. Depends
B. Error
C. No Error
D. All of above
E. None of these
Answer» C. No Error
Discussion
6.

Which among the following are the correct definitions for NULL in Mysql?

A. Empty set
B. Absence of value
C. Unknown
D. All of above
E. None of these
Answer» E. None of these
Discussion
7.

In the following query, what does person stands for:

A. Multivalued attributes
B. Table name
C. Composite attributes
D. All of above
E. None of these
Answer» C. Composite attributes
Discussion
8.

What is meaning of REFERENCES in table definition?

A. A foreign Key belong to this particular table
B. Foreign Key
C. NULL
D. Primary key
E. None of these
Answer» B. Foreign Key
Discussion
9.

Find out the logical error in the following query?

A. Primary key is missing
B. Lesser number of columns
C. Incorrect definition
D. All of above
E. None of these
Answer» B. Lesser number of columns
Discussion
10.

Which among the following is the correct syntax for defining ENUM in Mysql?

A. gender ENUM,
B. gender ENUM ( ),
C. gender ENUM ( M , F ),
D. All of above
E. None of these
Answer» D. All of above
Discussion
11.

In the following query, what does person_id stands for?

A. Primary key
B. Composite key
C. Normal attribute of the table
D. Super key
E. None of these
Answer» E. None of these
Discussion
12.

Which data type character merge the Check Constraint into a data type definition?

A. ENUM1
B. ENUM2
C. ENUM
D. All of above
E. None of these
Answer» D. All of above
Discussion
13.

Will this query produce any error?

A. Depends
B. Error
C. No Error
D. All of above
E. None of these
Answer» C. No Error
Discussion
14.

Which among the following is the correct syntax for defining Constraint Check in Mysql?

A. gender char (1) check,
B. gender char (1) check ( gender ),
C. gender char(1) check( gender IN ( M , F )),
D. All of above
E. None of these
Answer» D. All of above
Discussion
15.

What is the role of CONSTRAINS in defining a table in Mysql?

A. Declaring Foreign Key
B. Restrictions on columns
C. Declaring primary key
D. All of above
E. None of these
Answer» E. None of these
Discussion