SQL Basics and Database Fundamentals Quiz

What does SQL stand for?

• Structured Question Language

• Structured Query Language

• Standard Query Language

• Simple Query Language

Which of the following is NOT a key SQL operation?

• DML

• DCL

• DDL

• DOL

What is a primary key?

• A data type in SQL

• A unique identifier for each record

• A reference to a key in another table

• A type of SQL command

Which SQL command is used to delete data?

• ERASE

• REMOVE

• DELETE

• DROP

What type of data does the BOOLEAN data type represent?

• True/False values

• Date values

• Text values

• Numeric values

Which operator is used for comparison in SQL?

• AND

• LIKE

• !=

• OR

What does the SELECT clause do in an SQL query?

• Groups the data

• Sorts the results

• Filters the data

• Specifies which data to retrieve

Which SQL function returns the number of rows?

• SUM()

• COUNT()

• MAX()

• AVG()

What is the purpose of the GROUP BY clause?

• To combine rows from multiple tables

• To group rows that have the same values in specified columns

• To filter data

• To sort data

Which of the following is a valid SQL data type?

• TEXTUAL

• NUMERIC

• CHAR

• STRING