cyber

What type of software helps you compose and send messages over the network?

Email client software

What is the relationship between queries and reports?

A query selects and retrieves the correct data, whereas a report formats and summarizes the output.

An attorney uses a standard form to capture information about new clients. Which type of database would best suit those needs?

A relational database

How much storage space is consumed by the Boolean data type?

A single bit

How is binary notation expressed?

A single digit in a range from 0 to 1 is used. This number represents an on or off state. Each column is worth two times the column to its right. This is also known as base 2.

During program execution, a value changes and returns a new value to be used. Which type of identifier is this?

A variable

What is an example of a digital product?

A video download

A web application is client/server software that uses a web server as its server and what type of software as its client?

A web browser

What is the most common character set used for coding to represent text in computers?

American Standard Code for Information Interchange (ASCII)

What three scripting options are commonly used in Windows 10 to perform administrative tasks?

Batch files, Windows PowerShell scripts, and VBScripts

What is the purpose of firmware in an embedded system?

Firmware provides all the functions for interacting with the device hardware.

Modern Central Processing Units (CPUs) and bus types plus fiber optic network equipment work at what signal speed?

Gigahertz (GHz) or 1000 million cycles per second

What operating system is considered to be stateless?

Chrome OS

What is the decimal number 75 in binary and hexadecimal?

0100 1011 in binary and 4B in hex

Which of these is NOT a positive trait of a digital product in regard to the value assigned to information and data?

Digital sales through peer-to-peer transactions make it easier to sell information without the oversight of an institutional set of rules.

What is it that defines the relationship between tables in an RDBMS?

Each table contains a primary key whose value is unique for each record in the table. A foreign table can use the value of a primary key as a relation, storing the value in a foreign key field.

What part of the process of data analytics is most closely supported by meaningful reporting?

Insights

After installing an application, you experience difficulty getting it to run. What should you do?

Inspect the properties of the executable file.

What is the primary purpose of a flow chart?

It visualizes the graphical sequence of a program.

What is the key difference between Java and JavaScript?

Java is a programming language, whereas JavaScript is a scripting language.

Small files are often measured in what unit?

Kilobyte (KB), or 1000 bytes

Which of the following application delivery models is considered the "traditional" way to install an application?

Locally installed without the use of a network

Which pseudocode populates the first row and first column?

Logons(0,0) = find LastLoggedOnUser and get Forename

What is the main difference between looping and branching?

Loops are used to perform a task until a condition is met

Which type of application architecture model is considered "standalone"?

One-tier

What type of software license grants users permission to modify the code of the program as they see fit?

Open source

What is the difference between freeware and open source software?

Open source means that the programming code used to design the software is publicly available.

You have just bought a new computer but want to use the older version of Windows that came with your previous computer. Windows was provided as an OEM license. Can you use this license key to install the software on your new PC?

Original Equipment Manufacturer (OEM) licenses can only be used on the brand and model it was initially installed on.

What is the function of an IF conditional statement in code?

Part of the code only executes when certain conditions are true.

In a database where each employee is assigned to one project, and each project can have multiple employees, which database design option would apply?

The Project table has a primary key of ProjectID. The Employee table has a primary key of EmployeelD and a foreign key of ProjectID.

Convert the decimal number 10 into binary notation.

1010

How many students would be represented in a "Student" table containing 150 rows, 17 columns, 1 primary key, and 1 foreign key?

150

Which of the following HTML code snippets includes properly nested tags?

<p><em>Hello world!</em></p>

Why is the process of generating backups such an important feature of an RDBMS?

A database can contain mission-critical data, which an organization may not be able to afford to lose.

Why is the level of data integrity greater in a database than in a flat file?

A database can enforce data types for each column in a table, and can validate data as it is entered into those columns.

Why would a flat file system not be the optimum choice for data storage for an online shopping cart application?

A flat file system doesn't support multiple concurrent users.

In a program, what does a loop do?

A loop performs one or more instructions until (or while) a condition is met.

What is the difference between a procedure and a function?

A procedure does something while a function does something and then returns a value to the main program.

You've been tasked with changing the primary key in the Customer table from the CustID field to the AcctNum field. Which Data Definition Language (DDL) command can do that?

ALTER TABLE

You submitted the following SQL command for a "Customer" table: DELETE FROM CUSTOMER

All of the records from the "Customer" table were deleted.

In the Windows operating system, where do you navigate to when you want to install new operating system features?

Control Panel

An INSERT statement is an example of what data language type?

Data Manipulation Language

Which is the BEST example of importing data to populate a database?

Data records that are already stored in a digital format can be loaded directly into a database.

How does Microsoft SQL Server differ from Microsoft Excel when used to store a dataset?

Excel is an example of a flat file system, whereas SQL Server is relational database software that is better suited for larger volumes of information and more users.

Why would Windows prompt you to enter a password if you try to install a software application?

Installing an application requires administrator privileges and is an action protected by User Account Control

What is an interpreted language?

Interpreted languages do not need to be compiled because the code gets converted to machine code at runtime.

Why is meaningful reporting an important factor of data-driven business decisions?

It allows a human to analyze and interpret the information.

Which software package is a Relational Database Management System (RDBMS)?

Microsoft SQL Server

Which type of server application architecture model can have a complex architecture in which the application may use separate access control or monitoring services?

N-tier

What type of software enables you to create sophisticated business briefs that can be projected

Presentation software

You need a development environment with a library of database functions. What type of interface are you using?

Programmatic access

What type of software manages tasks, dependencies, and timelines?

Project management software

What shows the structure of code without using the specific syntax of any one language?

Pseudocode

Microsoft SQL Server is an example of what?

RDBMS

Which of the following is NOT an example of unstructured data?

Relational databases

What type of software would you use to configure a server by connecting to it over the network?

Remote desktop

What does the Boot Camp feature of a Mac allow you to do?

Run a Windows operating system on a Mac

Which type of software would you use to ensure everyone can see the same display output during an online meeting?

Screen sharing software

What security-related action helps protect the wireless router in your home?

Setting up encryption and using a password

When writing pseudocode, what are subroutines?

Subroutines are blocks of code that represent duplicate tasks but have been defined separately.Programs can be divided into blocks of instructions that each perform some specific task. For example, where there are duplicate steps, you could write those as separate subroutines and then call them whenever needed. This in return reduces confusion from a development perspective.

Newer hard disks and other large storage networks can be measured in what unit?

Terabyte, or 1000 GB

What compatibility information should you confirm before installing a software application?

That it works with the version of the operating system that you have, and that your computer meets the system (hardware) requirements.

In Hypertext Markup Language (HTML), what does the <a> tag do?

The <a> tag indicates that the content links to another resource.

In Hypertext Markup Language (HTML), what does the <html> tag do?

The <html> tag is the top-level parent element that identifies the type of document.

Following installation of a program written for an older version of Windows, you receive an alert that it might not have installed correctly. What feature could you use to make the program run correctly?

Use the program's Compatibility tab to use settings for the older Windows version.

Why might one of your first tasks on receiving a new computer be to remove software applications?

The computer may be bundled with pre-installed software that you do not want.

Why is it important to understand the different data types that a computer program can use?

The data type determines what sort of operations can be performed.

Why is a client-server application considered a two-tier architecture?

The database runs on a database server, while the application is run on the client computer.

In the Device Manager window, you notice a yellow exclamation mark next to a specific device. What is most likely the problem?

The driver for that device is either missing or the wrong version.

What manages memory on a computer?

The operating system will do the best job it can with the resources available.

Which statement is NOT true regarding SQL permissions?

The owner of a table can assign only the permission to view (not update) data in the table to other users.

Why is it important to consider the number and size of columns included in a table schema?

The size of each row affects the amount of storage used, and how quickly it can be processed.

What is an advantage of developing software using a single-platform model?

The software can perform better, and it is easier to check the software for errors because it was tailor made for a specific platform.

Which of the following BEST describes the purpose of properties in object-oriented programming?

They allow external code to access a field of an object.

Which of the following accurately describes arrays?

They can be either single-dimensional or multidimensional.

How do compilers and interpreters respond to comments in your code?

They ignore comments.

Which data representation format can encode the widest range of characters?

Unicode

In which situation would you use a vector?

To include a container that can grow or shrink in size as elements are added or removed

Following installation of an application, another program on your computer has stopped working. What could you do to try to fix it?

Try using the Repair option in Programs and Features (if available) or re-installing the program.

Which type of server application architecture model separates the database engine from the business logic?

Two-tier application architecture model

In order to obtain support on a currently installed application, the software vendor wants to know the application's product ID. How would you locate this information?

Usually via the Help > About menu.

What should NOT be done before trying to install an application?

Verify that the software will run on your computer by pressing the executable command

Which type of software allows the user to write and edit a document?

Word processing software

You have created an identifier with a value that cannot be changed. What is this considered?

constant

Which data type provides for whole numbers only?

integer