Scribd
Upload
407 views3 pages

Mysql Quiz

This document contains a quiz about MySQL with 5 multiple choice questions. The questions cover topics like primary keys, altering tables, dropping columns, data types, constraints.

Uploaded by

gauravsoninagod
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
407 views3 pages

Mysql Quiz

This document contains a quiz about MySQL with 5 multiple choice questions. The questions cover topics like primary keys, altering tables, dropping columns, data types, constraints.

Uploaded by

gauravsoninagod
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

Mysql Quiz

Question 1
Correct
Mark 1.00 out of 1.00
Not flaggedFlag question
Question text
A table consists of ______ primary keys.
Select one:

Any number

4
Feedback
The correct answer is: 1
Question 2
Correct
Mark 1.00 out of 1.00
Not flaggedFlag question
Question text
Which of the following options is not correct?
Select one:

alter table emp modify name varchar(30);

alter table emp add column_name varchar(25);

alter table emp drop column column_name;

alter emp drop column_name;


Feedback
The correct answer is: alter emp drop column_name;
Question 3
Correct
Mark 1.00 out of 1.00
Not flaggedFlag question
Question text
An emp table contains fields employ name, desig and salary. How do you drop column
salary?
Select one:

alter table emp delete column salary;

alter table emp delete salary;

alter table emp drop column salary;

delete from emp where column = salary;


Feedback
The correct answer is: alter table emp drop column salary;
Question 4
Correct
Mark 1.00 out of 1.00
Not flaggedFlag question
Question text
Choose the correct option

cardholdername

Answer 1
not null

creditcardno

Answer 2
primary key

cardholderphoneno

Answer 3
unique

validitydate

Answer 4
not null

creditcardtype should be sliver or platinum only

Answer 5
check

Feedback
Your answer is correct.
The correct answer is: cardholdername → not null, creditcardno → primary key,
cardholderphoneno → unique, validitydate → not null, creditcardtype should be
sliver or platinum only → check
Question 5
Incorrect
Mark 0.00 out of 1.00
Not flaggedFlag question
Question text
We need to ensure that the amount withdrawn should be less then the credit card
limit amount, to ensure this integrity what type constraint will be used?

Select one:

table level check constraint

table level foreign key constraint

column level check constraint

column level foreign key constraint

Feedback
Your answer is incorrect.
The correct answer is: table level check constraint

You might also like