InfyTQ DDL Statements Quiz 1

Question 1

Time: 00:00:00
Which of the SQL commands that are used to modify Database structures ?

Data Definition Language(DDL)

Data Definition Language(DDL)

Data Manipulation Language(DML)

Data Manipulation Language(DML)

DML and DDL

DML and DDL

None of the Mentioned

None of the Mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
Which among the following are DDL statements?

Create

Create

Drop

Drop

Alter

Alter

All of the Mentioned.

All of the Mentioned.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which of the following is a DML Command ?

RENAME

RENAME

REVOKE

REVOKE

GRANT

GRANT

UPDATE

UPDATE

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which command is used for completely deleting a table and all its data from the database ?

Create command

Create command

Drop table command

Drop table command

Alter table command

Alter table command

All of the Mentioned

All of the Mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
Which among the following commands allows the removal of all the rows from a table ?

TRUNCATE command

TRUNCATE command

CREATE command

CREATE command

DROP table command

DROP table command

ALTER table command

ALTER table command

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which among the following clauses applies additional filters to the result ?

Select

Select

Group-by

Group-by

Having

Having

Order by

Order by

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Which defines the rules regarding the values allowed in columns and is the common rule for enforcing database integrity ?

Column

Column

Constraints

Constraints

Index

Index

Trigger

Trigger

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
Which of the following commands is used to make a new database, table, index ?

CREATE

CREATE

ALTER

ALTER

UPDATE

UPDATE

ADD

ADD

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
Which of the following is true about ALTER TABLE Command ?

All of the mentioned

All of the mentioned

It's used when we want to change the table structure

It's used when we want to change the table structure

We add a column using this command

We add a column using this command

We drop a column using this command

We drop a column using this command

It is used for dropping constraints.

It is used for dropping constraints.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Which among the following Statements are correct to change the datatype of a column ?

ALTER TABLE table_name MODIFY column_name column_type;

ALTER TABLE table_name MODIFY column_name column_type;

ALTER TABLE table_name rename column_name column_type;

ALTER TABLE table_name rename column_name column_type;

ALTER TABLE table_name UPDATE column_name column_type;

ALTER TABLE table_name UPDATE column_name column_type;

ALTER TABLE table_name0 rechange column_name column_type;

ALTER TABLE table_name0 rechange column_name column_type;

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%