en-US
Play
Image

IT: Trivia questions with answers

Trivio.net #1 Quiz
Get Quiz AppIcon
IT
IT
21
Question: What is the purpose of an SQL IN clause?Answer: To specify multiple values for a column or expression
22
Question: What is the purpose of an SQL EXISTS clause?Answer: To check if a subquery returns any rows
23
Question: What is the purpose of an SQL aggregate function?Answer: To summarize data
24
Question: What is the purpose of a correlated subquery in SQL?Answer: To execute a query within another query, where the inner query depends on the outer query's results
25
Question: What is the purpose of an outer join in SQL?Answer: To combine two tables into one, even if there are no matches
26
Question: What is the purpose of a subquery in SQL?Answer: To execute a query within another query
27
Question: What is the purpose of a join in a database?Answer: To combine two tables into one
28
Question: What is the purpose of a foreign key in a database?Answer: To link two tables together
29
Question: What is the purpose of a primary key in a database?Answer: To uniquely identify each row
30
Question: What is the purpose of a trigger in a database?Answer: To execute a query on insert, update or delete