Information Management - QUIZ

What does SQL stand for?

• Structured Language Query

• Simple Query Language

• Structured Query Language

• Sequential Query Language

Which SQL keyword is used to retrieve data from a database?

• GET

• FETCH

• EXTRACT

• SELECT

Which SQL command is used to insert data into a database?

• INSERT

• ADD

• UPDATE

• PUT

What does the SQL acronym DDL stand for?

• Database Design Language

• Data Description Language

• Data Declaration Language

• Data Definition Language

Which SQL clause is used to filter the result set?

• HAVING

• FROM

• WHERE

• FILTER

Which SQL statement is used to delete records from a database

• DELETE

• REMOVE

• ERASE

• DROP

What does SQL JOIN do?

• Updates existing rows in a table

• Deletes rows from a table

• Combines rows from two or more tables

• Sorts the result set

Which SQL function is used to count the number of rows in a result set?

• SUM()

• MAX()

• AVG()

• COUNT()

What does SQL DML stand for?

• Data Manipulation Language

• Data Modification Language

• Data Modeling Language

• Data Mapping Language

Which SQL keyword is used to change data in a database?

• ALTER

• UPDATE

• CHANGE

• MODIFY