End of Year Exam Review

What are peripheral devices?

• Peripheral devices are only used for gaming.

• Peripheral devices are external hardware components that connect to a computer.

• Peripheral devices are internal components of a computer.

• Peripheral devices are software applications that run on a computer.

Name three types of input devices.

• Projector

• Keyboard, Mouse, Scanner

• Monitor

• Printer

What is the primary function of output devices?

• To connect the computer to the internet.

• To present data from a computer to the user.

• To store data for future use.

• To process data within the computer.

List two types of printers and their uses.

• Thermal Printer: Used for printing high-quality color documents.

• 1. Inkjet Printer: Used for high-quality color prints, especially photos. 2. Laser Printer: Used for high-volume text printing.

• Dot Matrix Printer: Used for high-resolution photo printing.

• 3D Printer: Used for creating prototypes.

Define primary key in a database.

• A primary key is a type of foreign key in a database.

• A primary key can contain duplicate values in a table.

• A primary key is a unique identifier for a record in a database table.

• A primary key is used to store large binary data in a database.

What is a foreign key?

• A foreign key is a type of primary key.

• A foreign key is a unique identifier for a single table.

• A foreign key is a field that links two tables by referencing the primary key of another table.

• A foreign key is a field that stores data from the same table.

Explain the difference between datasheet view and design view in databases.

• Datasheet view is for data entry and viewing, while design view is for defining the database structure.

• Datasheet view allows for database backups, while design view is for user permissions.

• Datasheet view is used for creating reports, while design view is for data entry.

• Datasheet view is for running queries, while design view is for generating charts.

What data type would you use for a person's name?

• float

• string

• boolean

• integer

How do you define a relationship type in a database?

• A relationship type is defined by the physical storage of data.

• A relationship type is defined by the entities involved and the nature of their association.

• A relationship type is solely based on the number of entities involved.

• A relationship type is irrelevant to the database structure.

What is the purpose of a query in a database?

• To delete all data in the database

• The purpose of a query in a database is to retrieve or manipulate data.

• To backup the database

• To create a new database