SQL
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.
Pprimary key - ANSWER A field whose value uniquely identifies every row in a
table.
Row - ANSWER A record that represents a collection of information relating to an
item in a table.
Table - ANSWER Structured file containing rows and columns.
SQL Defined - ANSWER SQL is a nonprocedural language that is used to
manipulate and retrieve data from relational DBMSs such as Microsoft Access, DB2,
Sybase, and Microsoft SQL Server. It is considered nonprocedural because of the
way operations are carried out. Unlike procedural computer languages like Basic and
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.
Pprimary key - ANSWER A field whose value uniquely identifies every row in a
table.
Row - ANSWER A record that represents a collection of information relating to an
item in a table.
Table - ANSWER Structured file containing rows and columns.
SQL Defined - ANSWER SQL is a nonprocedural language that is used to
manipulate and retrieve data from relational DBMSs such as Microsoft Access, DB2,
Sybase, and Microsoft SQL Server. It is considered nonprocedural because of the
way operations are carried out. Unlike procedural computer languages like Basic and
