ICT Database Essentials Lesson Quiz 2

In a database, Yes/No, Text and Date

/Time are all examples of:

• data types

• data queries

• tabs you can select

• records in the data table

Which database component is used to organize information by data type?

• Row

• Title

• Field

• Record

What is another name for a table row in a database

• Field

• Record

• Column

• Heading

What can you use to retrieve specific data from a table within a database?

• Field

• Query

• Record

• Column

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

• Query

• Report

• Column

• Heading

Which language is used to develop and manage databases?

• SQL

• Java

• HTML

• DBMS

What does a database use to provide a simplified interface for the user to enter, modify and view database records?

• Form

• Table

• Query

• Report

In which of the following must the data be unique?

• The foreign key

• The primary key

• The junction table

• The common field

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?

• One-to-one

• One-to-many

• Many-to-many

• Primary-to-foreign

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

• Excel

• HTML

• Oracle

• Access