SQL

A colorful infographic illustrating SQL concepts like databases, tables, queries, and data management, with a modern and engaging design.

Master SQL Quiz

Test your SQL knowledge with our engaging quiz designed for beginners and seasoned database enthusiasts alike. Challenge yourself with questions covering a range of SQL topics, including basic syntax, functions, and best practices.

Multiple-choice questions
Learn while you play
Improve your SQL skills

11 Questions3 MinutesCreated by QueryMaster451

2. What does SQL stand for?

A) Structured Query Language

B) Strong Question Language

C) Structured Question Language

3 - Which of the following is not true about Natural Joins?

A - Natural join is based on all columns in two tables having same name

B - It selects rows from the two tables having different values in the matched columns.

C - If columns having same names have different data types, it returns error.

D - None of the above. Show Answer

4 - Which of the following is not true about the MAX and MIN functions?

A - Both can be used for any data type.

B - MAX returns the maximum value.

C - MIN returns the minimum value.

D - All are true.

5 - Which of the following is not true about inserting news rows to a table?

A - The INSERT INTO statement is used for inserting new rows to a table

B - You cannot insert rows with NULL values to a table.

C - You may insert a new row containing values for each column.

D - All of the above

6 - Which of the following is true about the CREATE TABLE statement?

A - This is a DML statement.

B - This statement also record information in the data dictionary.

C - You don’t need any privilege to use this statement.

D - All of the above.

7 - Which of the following minimal code would create a sequence named loc_seq as a primary key of the LOCATIONS table?

A - create sequence loc_seq;

B - create sequence loc_seq on locations;

C - create loc_seq;

D - None of the above.

8- Which of the following code would create a role named student_admin?

A - CREATE student_admin;

B - GRANT student_admin;

C - CREATE ROLE student_admin;

D - ROLE student_admin;

9. Which SQL statement is used to extract data from a database?

A- SELECT

B- OPEN

C- GET

D- EXTRACT

10 - Which SQL statement is used to update data in a database?

A- MODIFY

B- UPDATE

C- SAVE AS

D- SAVE

Master SQL Quiz

More Quizzes