Digital Solutions - SQL

What does SQL stand for?

• Structured Query Language
• Sequential Query Language
• Statistical Query Logic
• Systematic Question List

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

• GET
• SELECT
• FETCH
• ACQUIRE

Which SQL clause is used to filter records in a SELECT statement?

• WHERE
• HAVING
• FILTER
• BY

Which SQL command is used to add new records to a database?

• INSERT INTO
• ADD RECORD
• CREATE RECORD
• UPDATE

Which SQL command is used to change data in a database?

• ALTER
• MODIFY
• UPDATE
• CHANGE

Which SQL clause is used to sort the result-set in ascending order?

• SORT BY
• GROUP BY
• ORDER BY
• ARRANGE BY

Which SQL function is used to count the number of rows in a table?

• COUNT()
• SUM()
• AVG()
• TOTAL()

Which SQL command is used to delete records from a database?

• REMOVE
• CLEAR
• DELETE
• ERASE

Which SQL clause is used to combine rows from two or more tables based on a related column?

• MERGE
• JOIN
• COMBINE
• CONNECT

Which SQL statement is used to make changes in an existing table structure?

• MODIFY TABLE
• ALTER TABLE
• UPDATE TABLE
• CHANGE TABLE