Have an account?
Skip to Content
Build your own quiz
Suggestions for you
SUPER
Computers
9th -
12thgrade
Chapter 9 - Databases (IGCSE Computer Science)
15 questions
Show Answers
See Preview
- 1. Drop Down
An SQL command that counts the number of records (rows) in which the field (column) matches a specified condition; used with SELECT (a)
ORDER BYCOUNTSUMWHERE - 2. Multiple Choice
A classification of how data is stored and displayed, and of which operations that can be performed on the stored value
data type
data value
data
data packet
- 3. Multiple Choice
A persistent structured collection of data that allows people to extract information in a way that meets their needs
record
table
database
basedata
- 4. Multiple Choice
The values associated with each record in a database table
table
record
primary key
field
- 5. Multiple Choice
An SQL command that identifies the table to use
SELECT
FROM
WHERE
ORDER BY
- 6. Multiple Choice
An SQL command that sorts the results from a query by a given column either alphabetically or numerically
SUM
WHERE
COUNT
ORDER BY
- 7. Multiple Choice
A field in a database that uniquely identifies a record
public key
private key
primary key
secondary key
- 8. Multiple Choice
A collection of fields that describe one item
table
record
field
database
- 9. Multiple Choice
An SQL command that fetches specified fields (columns) from a table
SELECT
FROM
WHERE
ORDER BY
- 10. Multiple Choice
A database that contains only one table
object database
graph database
relational database
single-table database
- 11. Multiple Choice
A list of SQL commands that perform a given task, often stored in a file so it can be reused
original scripts
SQL Scripts
storyboard scripts
screenplay scripts
- 12. Multiple Choice
The standard query language for writing scripts to obtain useful information from a relational database
Hypertext Markup Language (HTML)
Data Manipulation Language (DML)
Data Definition Language (DDL)
Standard Query Language (SQL)
- 13. Multiple Choice
An SQL command that returns the sum of all the values in a field (column); used with SELECT
SELECT
SUM
FROM
WHERE
- 14. Multiple Choice
A collection of related records in a database
field
row
table
column
- 15. Multiple Choice
An SQL command to include only those records (rows) in a query that match a given condition
SELECT
FROM
WHERE
ORDER BY
- Answer choicesTagsAnswer choicesTags