SQL Test

Which SQL keyword is used to retrieve a subset of records from a table?

• SELECT

• WHERE

• FROM

• GROUP BY

Which SQL statement is used to add a new row to a table?

• INSERT INTO

• UPDATE

• ALTER TABLE

• CREATE TABLE

Which SQL statement is used to delete a table from the database?

• REMOVE TABLE

• DELETE FROM

• DROP TABLE

• TRUNCATE TABLE

Which SQL join type returns only the matching records between two tables?

• FULL OUTER JOIN

• RIGHT JOIN

• LEFT JOIN

• INNER JOIN

Which SQL statement is used to modify existing data in a table?

• UPDATE
• MODIFY

• ALTER TABLE

• INSERT INTO

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

• HAVING

• ORDER BY

• GROUP BY

• WHERE

Which SQL function is used to return the current date and time?

• GETDATE()

• NOW()

• SYSDATE()

• CURRENT_TIMESTAMP()

Which SQL statement is used to rename a column in a table?

• ALTER TABLE

• RENAME COLUMN

• MODIFY TABLE

• UPDATE COLUMN

Which SQL function is used to return the length of a string?

• SIZE()

• CHAR_LENGTH()

• LENGTH()

• LEN()

Which SQL function is used to convert a string to uppercase?

• UPPER()
• UCASE()

• CAPITALIZE()

• INITCAP()