SQL Database - Basic

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

• RETRIEVE

• SELECT

• QUERY

• SEARCH

Which SQL statement is used to insert data into a table?

• INSERT INTO

• ADD VALUES

• UPDATE TABLE

• SET DATA

Which SQL function is used to find the average value of a column?

• COUNT()

• SUM()

• AVG()

• MAX()

Which SQL command is used to create a new database?

• CREATE DATABASE

• NEW DATABASE

• ADD DATABASE

• MAKE DATABASE

Which SQL statement is used to retrieve distinct values from a column?

• UNIQUE

• DISTINCT

• DIFFERENT

• UNIQUE VALUES

Which keyword is used to specify a condition for multiple values in a SQL WHERE clause?

• LIKE

• BETWEEN

• IN

• EXISTS

Which SQL command is used to remove duplicate rows from a table?

• DELETE

• CLEAR

• DROP

• DELETE DUPLICATES

Which SQL function is used to return the current date?

• GETDATE()

• CURRENT_DATE()

• NOW()

• TODAY()

Which SQL statement is used to order the result set in ascending order?

• SORT BY

• ARRANGE BY

• ORDER BY

• ASCENDING

Which SQL command is used to add a new record to a table?

• ADD ROW

• INSERT INTO

• CREATE RECORD

• MAKE ENTRY