SQL Quiz

What is SQL used for?

• Playing music

• Editing videos

• Creating graphics

• Managing data in Relational DBMS

Which of the following databases use SQL as the standard query language?

• MySQL

• SQLite

• Redis

• MongoDB

What does DML stand for in SQL?

• Data Migration Language

• Database Management Language

• Data Modeling Language

• Data Manipulation Language

Which SQL command is used to delete records from a database?

• CREATE

• DELETE

• UPDATE

• ADD

What does the SQL command SELECT do?

• Create new databases

• Insert records in a database

• Set permissions on tables

• Retrieve data from a database

Which SQL command is used to create a new table in a database?

• CREATE INDEX

• DROP TABLE

• CREATE TABLE

• ALTER TABLE

What does the SQL constraint NOT NULL enforce?

• Not accept Null values

• Non-numeric values

• Unique values

• Accept Null values

Which SQL operator is used to sort the result-set by a specified column?

• ORDER BY

• WHERE

• GROUP BY

• HAVING

What does the SQL LIKE operator do?

• Insert new rows

• Update existing records

• Delete rows from a table

• Search for a specified pattern in a column

How can you give a table or column another name in SQL?

• Use a nickname

• Use a pseudonym

• Use an alias

• Use a label