Question : Which SQL statement is used to insert new data?
Solution :
Correct Answer : INSERT INTO
Description -
Question : Which SQL statement is used to extract data from a database?
Solution :
Correct Answer : SELECT
Description -
Question : Which clause is used to filter records?
Solution :
Correct Answer : WHERE
Description -
Question : Which SQL keyword is used to sort the result-set?
Solution :
Correct Answer : ORDER BY
Description -
Question : Which SQL command is used to remove all records from a table without deleting the table?
Solution :
Correct Answer : TRUNCATE
Description -
Question : Which data type stores variable-length character strings?
Solution :
Correct Answer : VARCHAR
Description -
Question : Which SQL data type is best for storing whole numbers?
Solution :
Correct Answer : INT
Description -
Question : Which operator is used for pattern matching?
Solution :
Correct Answer : LIKE
Description -
Question : What does % represent in the LIKE operator?
Solution :
Correct Answer : Any number of characters
Description -
Question : Which operator checks for values within a range?
Solution :
Correct Answer : BETWEEN
Description -
Question : Which SQL statement is used to insert new data?
Solution :
Correct Answer : INSERT INTO
Description -
Question : Which operator is used to combine conditions where both must be true?
Solution :
Correct Answer : AND
Description -
Question : Which SQL function returns the number of rows?
Solution :
Correct Answer : COUNT()
Description -
Question : Which SQL data type stores date values?
Solution :
Correct Answer : DATE
Description -
Question : Which command changes existing data?
Solution :
Correct Answer : UPDATE
Description -
Question : Which operator checks whether a value exists in a list?
Solution :
Correct Answer : IN
Description -
Question : Which keyword removes duplicate records?
Solution :
Correct Answer : DISTINCT
Description -
Question : Which SQL clause groups rows with the same values?
Solution :
Correct Answer : GROUP BY
Description -
Question : Which operator returns TRUE if the condition is false?
Solution :
Correct Answer : NOT
Description -
Question : Which SQL data type stores decimal numbers?
Solution :
Correct Answer : FLOAT
Description -
Question : Which statement deletes a table completely?
Solution :
Correct Answer : DROP TABLE
Description -
Question : Which wildcard represents a single character in LIKE?
Solution :
Correct Answer : _
Description -
Question : Which clause is used after GROUP BY to filter groups?
Solution :
Correct Answer : HAVING
Description -
Question : What is the default sorting order of ORDER BY?
Solution :
Correct Answer : ASC
Description -
Question : Which operator is used to combine result sets?
Solution :
Correct Answer : UNION
Description -
Question : Which SQL command adds a new column to an existing table?
Solution :
Correct Answer : ALTER TABLE
Description -
Question : Which data type is fixed-length character data?
Solution :
Correct Answer : CHAR
Description -
Question : Which operator is used to test NULL values?
Solution :
Correct Answer : IS NULL
Description -
Question : Which SQL keyword is used to rename a column or table in output?
Solution :
Correct Answer : AS
Description -
Question : Which SQL operator checks whether a subquery returns any rows?
Solution :
Correct Answer : EXISTS
Description -