Databases

Question 1

Database

Answer 1

a persistent structured collection of data that allows people to extract information in a way that meets their standards

Question 2

Single-table database

Answer 2

a database that contains one table

Question 3

Table

Answer 3

A collection of related records in a database

Question 4

Record

Answer 4

A collection of fields that describe one item

Question 5

field

Answer 5

a database table

Question 6

data type

Answer 6

a classification of how data is stored and displayed, and of which operations that can be performed on the stored value

Question 7

primary key

Answer 7

a field in a database that uniquely identifies a record

Question 8

SQL

Answer 8

the standard query language for writing scripts to obtain useful information from a relational database

Question 9

SQL Scripts

Answer 9

a list of SQL commands that perform a given task, often stored in a file so the script can be reused

Question 10

Select

Answer 10

an SQL command that fetches specified fields(columns) from a table

Question 11

From

Answer 11

an SQL command that identifies the table to use

Question 12

Where

Answer 12

an SQL command that include only those records(rows) in a query that match a given condition

Question 13

Order by

Answer 13

an SQL command that sorts the results from a query by a given column wither alphabetically or numerically

Question 14

Sum

Answer 14

an SQL command that returns the sum of all the values in a field(column) used with SELECT

Question 15

Count

Answer 15

an SQL command that counts the number of records(rows) in which the field(column) matches a specified condition; used with SELECT