CSEC IT Knowledge Assessment 1

What is a primary key in a database?

• A primary key can be duplicated across records in a database.

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

• A primary key is an optional field in a database record.

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

Explain the difference between a LAN and a WAN.

• A LAN is a network for a small area, while a WAN covers a large area.

• A LAN is a network that connects multiple cities, while a WAN is limited to a single building.

• A LAN is used for global communication, while a WAN is for local connections.

• A LAN is slower than a WAN because it covers a larger area.

What does HTML stand for?

• HyperText Markup Tool

• HyperText Markup List

• HyperText Markup Language

• HighText Markup Language

List the phases of the Software Development Life Cycle.

• Analysis, Design, Testing, Release

• Planning, Requirements Analysis, Design, Implementation, Testing, Deployment, Maintenance

• Concept, Development, Evaluation, Support

• Planning, Design, Implementation, Review

What is the purpose of a firewall in cybersecurity?

• To enhance internet speed and performance.

• To store sensitive data securely.

• To control network traffic and protect against unauthorized access.

• To provide a backup for network devices.

What is the function of a word processor?

• To create and edit spreadsheets.

• To design graphics and images.

• To manage databases and records.

• The function of a word processor is to create and edit text documents.

How do you create a formula in a spreadsheet?

• Select a cell, type '=' followed by the formula, and press Enter.

• Use the 'Calculate' button to create a formula.

• Type the formula directly into the header row.

• Click on the toolbar and select 'Insert Formula'.

What is normalization in database design?

• Normalization is a method for encrypting sensitive data in databases.

• Normalization refers to the physical storage of data on disk drives.

• Normalization is the process of increasing redundancy in a database.

• Normalization in database design is the process of structuring a database to minimize redundancy and dependency by organizing fields and tables.

Define the term 'IP address'.

• An IP address is a unique numerical label assigned to each device on a network, used for identifying and locating the device.

• A method for encrypting data on a network.

• A type of software used for managing network traffic.

• A physical device that connects multiple networks.

What is the role of CSS in web development?

• CSS handles database management.

• CSS is used for server-side scripting.

• CSS is responsible for styling and layout in web development.

• CSS is responsible for web security.