SQL Final Exam (LATEST 2025/2026) Complete
Questions & 100%Correct Answers
ASC keyword - ANSWER-Used to sort data in ascending
order.
Data type - ANSWER-Specifies the type of data that a
column can hold (e.g., text and numbers).
DESC keyword - ANSWER-Used to sort data in descending
order
ORDER BY clause - ANSWER-Retrieves the name of one or
more columns from the SELECT statement, and sorts
(ascending or descending) the output.
Client - ANSWER-A single-user computer that interfaces
with the multiple-user server.
Client/server database system - ANSWER-A system that
divides processing between client computers and a
database server.
, Database - ANSWER-A collection of electronically stored
organized files.
Server - ANSWER-A multiple-user computer that provides
shared database connection, interfacing, and processing
services.
Field - ANSWER-Column that runs vertically within a
table.
Foreign key - ANSWER-Link records of one type with
those of another type.
Keys - ANSWER-Uniquely identify a row or record in a
table.
Normalization - ANSWER-A three-step technique used to
organize data attributes in a more efficient, reliable,
flexible, and maintainable structure.
Primary key - ANSWER-A field whose value uniquely
identifies every row in a table.
Questions & 100%Correct Answers
ASC keyword - ANSWER-Used to sort data in ascending
order.
Data type - ANSWER-Specifies the type of data that a
column can hold (e.g., text and numbers).
DESC keyword - ANSWER-Used to sort data in descending
order
ORDER BY clause - ANSWER-Retrieves the name of one or
more columns from the SELECT statement, and sorts
(ascending or descending) the output.
Client - ANSWER-A single-user computer that interfaces
with the multiple-user server.
Client/server database system - ANSWER-A system that
divides processing between client computers and a
database server.
, Database - ANSWER-A collection of electronically stored
organized files.
Server - ANSWER-A multiple-user computer that provides
shared database connection, interfacing, and processing
services.
Field - ANSWER-Column that runs vertically within a
table.
Foreign key - ANSWER-Link records of one type with
those of another type.
Keys - ANSWER-Uniquely identify a row or record in a
table.
Normalization - ANSWER-A three-step technique used to
organize data attributes in a more efficient, reliable,
flexible, and maintainable structure.
Primary key - ANSWER-A field whose value uniquely
identifies every row in a table.
