SQL and Database Concepts Worksheet

Which of the following is true about a table

• The table must have at least one column

• All of the other answers are true

• A table can have zero or more rows

• The table can have more than one column

Which of the following are considered flat files

• JSON

• All of the Answers are correct!

• Excel

• XML

• CSV

Values in SQL are called

• return formulas

• SELECTS

• Literals

• Predicates

DML stands for:

• Data Manipulation Language

• Data Management Logic

• Database Markup Language

• Dynamic Module Loader

Which of the following keywords are used to choose the columns to display in our data set?

• SELECT

• ORDER BY

• FROM

• WHERE

Our SQL contains a literal string comparison, this means

• The correct case must be used

• The WHERE clause is being used in the query

• All of the Answers are true

• Single quotes must be placed around the literal string(s)

What does SQL stand for?

• Simple Query Language

• Structured Query Language

• Structured Query Literature

SQL was standardised in 1986 by who?

• ANSI

• ENSI

• MENSA

• IEEE

Which of these examples of syntax is correct?

• SELECT * FROM tbl_table;

• select * from tbl_table;

• SELECT FROM tbl_table;

• SELECT * FROM tbl_table

To query a database using SQL, which command would you use?

• UPDATE

• CREATE

• SELECT

• DROP