Image

IT: Trivia questions with answers

11
Question: What is the purpose of an SQL CHECK constraint?Answer: To ensure that data in a table conforms to specific rules
12
Question: What is the purpose of an SQL FOREIGN KEY constraint?Answer: To establish relationships between tables
13
Question: What is the purpose of an SQL PRIMARY KEY constraint?Answer: To uniquely identify each row in a table
14
Question: What is the purpose of an SQL UNIQUE constraint?Answer: To ensure that a column contains unique values
15
Question: What is the purpose of an SQL JOIN clause?Answer: To combine two or more tables into one
16
Question: What is the purpose of an SQL HAVING clause?Answer: To filter groups based on a condition
17
Question: What is the purpose of an SQL GROUP BY clause?Answer: To group data based on one or more columns
18
Question: What is the purpose of an SQL LIMIT clause?Answer: To limit the number of rows returned by a query
19
Question: What is the purpose of an SQL ORDER BY clause?Answer: To sort data based on one or more columns
20
Question: What is the purpose of an SQL LIKE clause?Answer: To search for a pattern in a string