GIAC Python Coder (GPYC) — Question 7

What does the LIMIT function restrict in an SQL SELECT statement?

Answer options

• A. The number of queries that can be run against the table per second.
• B. The number of records a table is permitted to hold.
• C. The number of records that will be returned by a request.
• D. The number of subsequent SELECT statements that can be run against the table

Correct answer: C

Explanation

The LIMIT function specifically controls the maximum number of records returned by a query in SQL. Options A and D refer to query execution limits, which are not related to the LIMIT function. Option B discusses the capacity of the table itself, rather than the results of a query.