SQL Query: Retrieve Film IDs and Titles After Skipping First 5 Records

A. select filmid, title from film limit 5,10;

This query will retrieve the ID and title of 10 films after skipping the first 5 records in the film table. The 'LIMIT' clause with two arguments works as follows: LIMIT offset, count. In this case, offset = 5 skips the first 5 records, and count = 10 retrieves the next 10 records.

Correct Answer: A