Search Header Logo

QUIZ ON SQL

Authored by Afreen Khan

Other

University

Used 6+ times

QUIZ ON SQL
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

25 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

  Primary key can be?

NULL

NOT NULL

Both NULL and NOT NULL

Depends on situation

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following commands is used to delete all rows and free up space from a table?

TRUNCATE

DROP

DELETE

ALTER

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following commands are a part of Data Control Language?

Revoke

Grant

Both A and B

None of the above

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?

UNIQUE

NOT NULL

DEFAULT

CHECK

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

  During transaction before commit which of the following statements is done  automatically in case of shutdown?

Rollback

Commit

View

Flashback

6.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

   Which of the following is not a SQL command?

DELETE

ORDER BY

SELECT

WHERE

7.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which of the following matches the definition given below:

It is an artificial key that aims to uniquely identify each record.

Primary Key

Foreign Key

Surrogate Key

Composite Key

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?