SQL Quiz-2

SQL Quiz-2

Professional Development

10 Qs

quiz-placeholder

Similar activities

Post Test Payfazz 12 Oktober

Post Test Payfazz 12 Oktober

Professional Development

10 Qs

Q1 Introduction to Python

Q1 Introduction to Python

Professional Development

15 Qs

TalentNext Test Day-13-Core Java Topics

TalentNext Test Day-13-Core Java Topics

Professional Development

10 Qs

"Vacina não é fake news"

"Vacina não é fake news"

Professional Development

11 Qs

IPPS CPEA Pre-Test Quiz 2020

IPPS CPEA Pre-Test Quiz 2020

Professional Development

10 Qs

Rewarding CDB

Rewarding CDB

Professional Development

11 Qs

IBEX A-ISB

IBEX A-ISB

Professional Development

10 Qs

MS402 - Platoon Leadership

MS402 - Platoon Leadership

Professional Development

11 Qs

SQL Quiz-2

SQL Quiz-2

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Medium

Created by

Data_Analyst_Harish undefined

Used 4+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

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

Create a free account and access millions of resources

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