Question 26
Which of the following SQL commands is used to save transaction changes permanently to the database?
COMMIT is a TCL command that permanently saves all changes made during the current transaction to the database.
Which of the following SQL commands is used to save transaction changes permanently to the database?
COMMIT is a TCL command that permanently saves all changes made during the current transaction to the database.
Which SQL clause is used to filter records resulting from a GROUP BY clause?
The HAVING clause filters aggregated group results generated by GROUP BY, whereas the WHERE clause filters individual rows before aggregation.
Which wild-card character in SQL represents zero, one, or multiple characters in pattern matching with LIKE?
In SQL LIKE clause pattern matching, '%' represents zero or more characters, while '_' represents exactly one single character.
Which SQL aggregate expression counts non-NULL values in a specified column?
COUNT(column_name) counts rows where that column is not NULL. COUNT(*) counts all rows, regardless of NULL values in individual columns.
Which keyword is used in SQL to eliminate duplicate rows from a SELECT query result?
The SELECT DISTINCT statement is used to return only unique (distinct) values by removing duplicate rows from the query output.