Search Header Logo

SQL Quiz-2

Authored by Data_Analyst_Harish undefined

Professional Development

Professional Development

Used 4+ times

SQL Quiz-2
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following SQL commands is used to create a new table?

INSERT

CREATE

ALTER

SELECT

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

2. What does the ALTER command do in SQL?

Modifies data in a table

Modifies the structure of a table

Deletes records

Adds new data rows

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following commands will delete a table and all its data permanently?

DROP

DELETE

TRUNCATE

REMOVE

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which DDL command can be used to remove all data from a table but keep its structure?

DELETE

DROP

TRUNCATE

CLEAR

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the UPDATE command do in SQL?

The UPDATE command modifies existing records in a table.
The UPDATE command deletes records from a table.
The UPDATE command creates new tables in a database.
The UPDATE command retrieves data from a table.

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL command removes specific rows from a table?

DELETE
INSERT
UPDATE
SELECT

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the WHERE clause do in a SELECT query?

Limits the number of columns

Changes column values

Filters rows based on conditions

Deletes rows

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Professional Development