Search Header Logo

My Sql

Authored by Priyanka Grover

Computers

12th Grade

Used 173+ times

My Sql
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command is used to display list of all databases.

Display

Display List

Show Databases

Show Database

2.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Delete command is DDL command.

True

False

3.

FILL IN THE BLANKS QUESTION

10 sec • 1 pt

Which aggregate function is used to find sum of column in a table?

(a)  

4.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which is the correct statement from the following :

Delete table book;

Delete book;

Delete table book;

Drop table book;

Drop book;

5.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Duplication of record is called___________

Deficiency

Redundancy

Lack

Addition

6.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which of the following is not the aggregate function?

avg()

max()

round()

sum()

7.

MULTIPLE CHOICE QUESTION

10 sec • 1 pt

Which command will delete all the records of table with its structure?

Delete Table <Table Name>;

Drop Table;

Drop Table <Table Name>;

Drop <Table Name>;

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

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?