Introduction to SQL Quiz-5

Welcome to your Introduction to SQL Quiz-5

Q41. Which command will help to set Foreign key in MySQL?

Update

Select

Create

Alter

Q42. ________________ key involved two tables.

Primary

Foreign

Alternate

Candidate

Q43. Candidate key - Primary key = ________________________

Alternate Key

Foreign Key

Candidate Key

Primary Key

Q44. UNIQUE constraint means no two values in that column should be same. (T/F)

True

False

Q45. Which command is used to add an attribute to an existing table.

Create

Alter

Update

Select

Q46. Write a command to add a new column "contactno" of data type char(10) in an already existing table "school".

Alter table school add contactno char(10);

Alter school add contactno char(10);

Alter table school new contactno char(10);

Alter table school add contactno datatype char(10);

Q47. Suppose the principal of the school has decided to award scholarship to some needy students for which income of the guardian must be known. But school has not maintained income attribute with table GUARDIAN so far. Therefore, the database designer now needs to add a new attribute income of data type INT in the table GUARDIAN.

Alter table GUARDIAN add attribute income INT;

Update table GUARDIAN add income INT;

Alter table GUARDIAN add income INT;

Modify table GUARDIAN add income INT;

Q48. Alter statement in MySQL is used to ______________________

Add a new column in a table

Delete a column from the table

Modify the data type of a column

All of the above

Q49. Suppose we need to change the size of attribute NAME from VARCHAR(30) to VARCHAR(40) of the SCHOOL table. The MySQL statement will be

Alter table STUDENT MODIFY NAME VARCHAR(40);

Alter STUDENT MODIFY NAME VARCHAR(40);

Alter table STUDENT MODIFY column NAME VARCHAR(40);

Alter table STUDENT MODIFY NAME data type VARCHAR(40);

Q50. We can change an attribute’s constraint from NULL to NOT NULL using _____________________

Create Statement

Modify Statement

Update Statement

Alter Statement

Related

Leave a ReplyCancel reply