ICT Database Essentials Lesson Flashcard 2

Front

In a database, Yes/No, Text and Date/Time are all examples of:

Back

data types

Front

Which database component is used to organize information by data type? Options: Row, Title, Field, Record

Back

Field

Front

What is another name for a table row in a database?

Back

Record

Front

What can you use to retrieve specific data from a table within a database? Options: Field, Query, Record, Column

Back

Query

Front

What can you use to summarize and print data for presentation or sharing?

Back

Report

Front

Which language is used to develop and manage databases? Options: SQL, Java, HTML, DBMS

Back

SQL

Front

What does a database use to provide a simplified interface for the user to enter, modify and view database records? Options: Form, Table, Query, Report

Back

Form

Front

In which of the following must the data be unique?

• The foreign key
• The primary key
• The junction table
• The common field

Back

The primary key

Front

In which table relationship does a record in Table A have multiple matching records in Table B, but a record in Table B has only one matching record in Table A?

Back

One-to-many

Front

Which database application would most likely be used in large organizations?

Excel

,

HTML

,

Oracle

,

Access

Back

Oracle