MR.Z SQL Flashcard 12/5/24

Front

Which of the following is a SQL keyword? SELECT, SHOW, Irina, PRINT

Back

SELECT

Front

What does SQL stand for?

Back

Structured Query Language

Front

Which SQL clause is used to filter records?

Back

WHERE

Front

Which SQL statement is used to update data in a database?

Back

UPDATE

Front

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

Back

COUNT

Front

Which SQL statement is used to delete data from a database?

Back

DELETE

Front

Which SQL clause is used to sort the result set?

Back

ORDER BY

Front

Which SQL statement is used to insert new data into a database?

Back

INSERT INTO

Front

Which SQL keyword is used to prevent duplicate records?

Back

DISTINCT

Front

Which SQL function is used to find the highest value?

Back

MAX