Question
What is it called when you restart a computer by turning
off the power and turning it back on?Solution
Restarting a system by cutting off power and turning it back on is called a hard or cold boot.
Which command removes all rows but keeps table structure?
Which index type is most beneficial for queries that use range predicates (e.g., WHERE age BETWEEN 20 AND 30)?
Which of the following SQL constructs avoids returning duplicate rows?
Which SQL clause is used for filtering rows?
Which SQL keyword removes duplicate rows automatically from results?
Which operator is used to combine results of two SELECT queries and remove duplicates?
ROW_NUMBER() OVER (PARTITION BY dept ORDER BY salary DESC) assigns:
Which operator is used for pattern matching in SQL?
Which SQL clause is used to filter records based on aggregate functions?
Which SQL clause is used to group rows?