Search Header Logo

SQL Quiz

Authored by Hữu Trần

English

12th Grade

Used 1+ times

SQL Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

65 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following keyword is used to raise an error in stored procedure?

ERROR

RAISERROR

THROWERROR

DISPLAY

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of the SQL keyword "GROUP BY"?

To filter rows in a table

To join multiple tables

To sort data in ascending order

To group rows with the same values

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL is used in SQL Server?

PL/SQL

SQL

T-SQL

Not all of them

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which virtual table is created when the trigger statement is executed?

updated and deleted

deleted and inserted

inserted and updated

selected and inserted

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which the isolation level below is the default of transaction?

Serializable

Repeatable read

Read Committed

Read Uncommitted

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Fill right answer: ALTER TABLE users ____CONSTRAINT PK_Users_ID PRIMARY KEY (id);

INSERT

ADD

REFERENCE

ON

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which statement is used to remove rows from a table?

DELETE

DROP

REMOVE

ERASE

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?