Search Header Logo

SQL contest

Authored by Hardik Sharma

Professional Development

Professional Development

Used 2+ times

SQL contest
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

20 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which MySQL data type is used to store a fixed-length string, padded with spaces if necessary?


Char

Varchar

Blob

int

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

In MySQL, which keyword is used to create a new table? 

Alter

Create

Insert

modify

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is the purpose of the MySQL 'SHOW' command?


To display the structure of a table

To display the contents of a table

To display a list of databases  

To display the version of MySQL

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which MySQL clause is used to specify the sorting order of the result set?


ORDER BY

SORT BY

GROUP BY

HAVING

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What does the MySQL function 'NOW()' return?

The current date 

The current Time

The current date and time  


The elapsed time since midnight 

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

In MySQL, what is the purpose of the "LIMIT" clause in a SELECT statement? 

DROP DATABASE

DELETE DATABASE

REMOVE DATABASE

ERASE DATABASE

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which MySQL command is used to delete a database?  

DELETE DATABASE

DROP DATABASE

REMOVE DATABASE

ERASE DATABASE

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?

Discover more resources for Professional Development