QUIZ ON SQL

QUIZ ON SQL

University

25 Qs

quiz-placeholder

Similar activities

Principles of Management-CIA-1

Principles of Management-CIA-1

University

20 Qs

Total quality management 2022

Total quality management 2022

University

20 Qs

Draw toolbar & Shortcuts

Draw toolbar & Shortcuts

7th Grade - Professional Development

20 Qs

Online quiz - GHOT2033

Online quiz - GHOT2033

University

20 Qs

MMS Fin CVMA

MMS Fin CVMA

University

20 Qs

4. Special Laws on Banking and Finance

4. Special Laws on Banking and Finance

University

20 Qs

GSheet Quiz

GSheet Quiz

10th Grade - Professional Development

20 Qs

MIS Chapter 4

MIS Chapter 4

University

20 Qs

QUIZ ON SQL

QUIZ ON SQL

Assessment

Quiz

Other

University

Practice Problem

Medium

Created by

Afreen Khan

Used 6+ times

FREE Resource

AI

Enhance your content in a minute

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

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

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?