Understanding SQL Basics

What does the SQL SELECT statement do?

• The SQL SELECT statement creates new tables in a database.

• The SQL SELECT statement retrieves data from a database.

• The SQL SELECT statement updates existing records in a database.

• The SQL SELECT statement deletes data from a database.

How do you specify the table to select data from in SQL?

• Use the TABLE clause in a SELECT statement.

• Use the FROM clause in a SELECT statement.

• Specify the table in the WHERE clause.

• Use the SELECT clause to specify the table.

What is the purpose of the WHERE clause in SQL?

• To create new database tables.

• To join multiple tables together.

• To filter records based on specified conditions.

• To sort records in ascending order.

How can you filter records using the WHERE clause?

• You cannot use the WHERE clause to filter records.

• Use the WHERE clause only for sorting records.

• Use the WHERE clause followed by a condition to filter records.

• The WHERE clause is used to group records together.

What is the function of the ORDER BY clause in SQL?

• The ORDER BY clause sorts the result set of a query.

• The ORDER BY clause limits the number of rows returned by a query.

• The ORDER BY clause groups the result set of a query.

• The ORDER BY clause filters the result set of a query.

How do you sort results in ascending order using ORDER BY?

• ORDER BY column_name DESC

• ORDER BY ASC column_name

• ORDER column_name BY ASC

• ORDER BY column_name ASC

What data type would you use for a person's name in SQL?

• VARCHAR or CHAR

• INTEGER

• DATE

• BOOLEAN

Which data type is suitable for storing true/false values?

• float

• integer

• string

• boolean

What is the difference between INTEGER and REAL data types?

• INTEGER can store decimal values; REAL cannot.

• INTEGER is a floating-point type; REAL is an integer type.

• INTEGER is used for text data; REAL is for numeric data.

• INTEGER is for whole numbers; REAL is for numbers with decimals.

How would you store a date of birth in SQL?

• Use the DATE data type to store date of birth.

• Use the TEXT data type to store date of birth.

• Store date of birth as an INTEGER.

• Use the VARCHAR data type to store date of birth.