CSEC IT Knowledge Assessment

What is a primary key in a database?

• A primary key can be duplicated across records.

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

• A primary key is a type of foreign key.

• A primary key is used to store large amounts of data.

Explain the difference between SQL and NoSQL databases.

• SQL databases are relational and structured, while NoSQL databases are non-relational and flexible.

• SQL databases are designed for unstructured data, while NoSQL databases are for structured data.

• SQL databases use JSON format, while NoSQL databases use XML format.

• SQL databases are non-relational and flexible, while NoSQL databases are relational and structured.

What is the purpose of a firewall in networking?

• To enhance wireless connectivity for devices.

• The purpose of a firewall in networking is to protect networks by controlling traffic and preventing unauthorized access.

• To provide a backup for network data storage.

• To increase network speed by optimizing traffic flow.

Define the term 'IP address'.

• A method for encrypting data on a network

• A type of software used for network management

• A protocol for transferring files over the internet

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

What is the function of a router in a network?

• To store data packets for later use.

• The function of a router in a network is to direct data packets between different networks.

• To provide wireless connectivity to devices.

• To amplify signals in a network.

How do you create a formula in a spreadsheet?

• Type '=' followed by your formula in the desired cell.

• Use the 'Insert' menu to create a formula.

• Type '!' followed by your formula in the desired cell.

• Enter the formula in the header row of the spreadsheet.

What is the difference between relative and absolute cell references?

• Relative references adjust based on the position of the cell, while absolute references do not change.

• Absolute references adjust based on the position of the cell.

• Both relative and absolute references are the same in functionality.

• Relative references are fixed and do not change at all.

What is a mail merge in word processing?

• A mail merge is a tool for creating spreadsheets in word processing.

• A mail merge is a feature that only allows printing labels without any data integration.

• A mail merge is a method for sending bulk emails without personalization.

• A mail merge is a feature that combines a document template with a data source to create personalized documents.

How can you track changes in a Word document?

• Enable 'Track Changes' in the Review tab.

• Print the document to track changes manually.

• Change the font color to indicate edits.

• Use the 'Save As' feature to create a new document.

What is Pascal primarily used for?

• Web development

• Teaching programming and developing desktop applications.

• Creating video games

• Data analysis