Survey Maker Survey Templates Contact Privacy & Security

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

1 - What is returned by MOD(1000,30)?

A - 33

B - 30

C - 3

D - 10

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

{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsLearn while you playImprove your SQL skills","img":"https:/images/course5.png"}