Topic

Introduction to SQL Part $2$

Questions

Part A:

MCQ

i$.$ What command is used to add or delete attribute or column in SQL$?$

GENERATE

BUILD

CREATE

INSERT

Alter

ii$.$ What does the following code snippet do$?$

SELECT $*$ FROM Student WHERE income $>100$;

Displays all students

Displays all columns with income $>100$

Displays only age column with income

IN

iii. In what scenario a DML statement will not be executed?

When existing rows are modified.

When a table is deleted.

When some rows are deleted.

All of the above

Which of the following is the full form of DML$?$

Data manipulation Language

Data Derivation Language

Data Detail Language

Dynamic Data Language

Deleting Data from tables is known as DDL$.$ True$/$False

Modifying the constraints in SQL is known as DDL$.$ True$/$False

Part B: