SQL 1

What does SQL stand for?

• Standard Query Language
• Sequential Query Language
• Structured Query Language
• Simple Query Language

What is SQL primarily used for?

• Designing web pages
• Querying and updating tables in a relational database
• Creating graphics
• Managing operating systems

What type of language is SQL?

• Procedural
• Object-oriented
• Declarative
• Functional

All database software packages will generate their own SQL when using a GUI

• True

• False

Which command is used to list fields to be displayed?

• SELECT
• FROM
• WHERE
• ORDER BY

Which command is used to list the table or tables the data will come from?

• SELECT
• FROM
• WHERE
• ORDER BY

Which command is used to list search criteria?

• SELECT
• FROM
• WHERE
• ORDER BY

Which command is used to list fields the data should be sorted on?

• SELECT
• FROM
• WHERE
• ORDER BY

Which symbol is used as a wildcard in SQL for the SELECT command?

• %
• &
• *
• ?

Which symbols could be used as a wildcard in SQL for the LIKE command (depending on the software)?

• %
• &
• *
• ?