ITF+ Final Exam Part 1

What is the decimal number 75 in binary and hexadecimal? 5C in binary and 0101 1100 in hex 4B in binary and 0100 1011 in hex 0100 1011 in binary and 4B in hex 0101 1100 in binary and 5C in hex

0100 1011 in binary and 4B in hex

What type of computer is best suited for using in a job where you have to make notes and be able to move around easily? Desktop computer with an electronic stylus. A server that is mounted on a cart for easier mobility. A tablet or smartphone or possibly a hybrid laptop/tablet. Gaming console with voice activated commands.

A tablet or smartphone or possibly a hybrid laptop/tablet.

What type of programming concept allows for a variable size container? A procedure An array A vector A function

A vector

What three scripting options are commonly used in Windows 10 to perform administrative tasks? PowerCLI, Perl, and Python Mocha, LiveScript, and JavaScript Batch files, Windows PowerShell scripts, and VBScripts AppleScript Editor, Xcode, and Smile

Batch files, Windows PowerShell scripts, and VBScripts

Mice and keyboards CANNOT connect to which types of ports? Bluetooth interfaces PS/2 ports Ethernet ports USB ports

Ethernet ports

Which data type provides for whole numbers only? Integer Boolean Hexadecimal Secondary

Integer

What function of an operating system is performed by the "shell"? Interface between a host computer and a guest operating system. Interface between the applications and the hardware. Interface between the hardware and the firmware. Interface between the user and the computer.

Interface between the user and the computer.

What type of printer uses a fuser? Laser printer Color bubblejet printer A 3D printer Impact printer

Laser printer

What is the difference between freeware and open source software? Open source applications are those that may be downloaded from the Internet and used without restriction. Open source means that the software is intended for purchase to meet commercial needs. Open source is provided on a trial basis and users commonly have to purchase the full version after the trial period has passed. Open source means that the programming code used to design the software is publicly available.

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

What are constants and variables examples of? Simple arrays Programming identifiers Conditional branches Continuous loops

Programming identifiers

Which of the following methods can be used to open the Computer Management console? (Select all that apply.) Right-click the This PC object in File Explorer. Right-click the Start button. Right-click the Taskbar. Via the Settings app.

Right-click the This PC object in File Explorer. Right-click the Start button.

What language is usually used to request data from an RDBMS such as Oracle? eXtensible Markup Language (XML) is used to query RDMBS-based database platforms. Structured Query Language (SQL) is used to query RDBMS-based database platforms. Hypertext Markup Language (HTML) is used to query RDBMS-based database platforms. Java is used to query RDBMS-based database platforms.

Structured Query Language (SQL) is used to query RDBMS-based database platforms.

What type of component provides persistent storage? The Random Access Memory (RAM) The Central Processing Unit (CPU) The Hard Disk Drive (HDD) and Solid State Drive (SSD) The Graphics Processing Unit (GPU)

The Hard Disk Drive (HDD) and Solid State Drive (SSD)

What is the technical term for a web address? Hyperlink (HL) Uniform Resource Locator (URL) Address bar Website name

Uniform Resource Locator (URL)

What protection feature in Windows is designed to prevent a script or software from making unauthorized changes to the OS configuration? Graphical User Interface (GUI) User Account Control (UAC) Default account types Password options

User Account Control (UAC)

What type of computing device(s) is macOS designed for installation on? Servers and network storage Smartphones and tablets Feature phones Workstations and laptops

Workstations and laptops

You want to find something on a particular website, but the site does not have a search tool. Could you use a general search engine (and if so, how)? Yes—just type the website name first in the search engine, and then type the keywords. No—you just need to keep searching the website until you find what you're looking for. No—it is not necessary to use a general search engine. Just type CTRL-F and type the word you are looking for. Yes—you use an advanced search form and provide a URL such as comptia.org.

Yes—you use an advanced search form and provide a URL such as comptia.org.

What is the best way to install a web application on your computer? You do not install a web application on your computer. You access it through your browser. Go to the vendor's website and have them mail it to you and install it when the disk arrives. Download it from the browser and install it on the computer. Call in an IT specialist to come install it for you.

You do not install a web application on your computer. You access it through your browser.

You want to check whether a condition has been met, and if it has, perform one action. Otherwise, you want your program to perform a second action. What sort of programming operation would help achieve this? A programming identifier A conditional branch A simple array A continuous loop

a conditional branch

What systems use a Central Processing Unit (CPU) and memory? Desktops only Servers only All types of computers Laptops only

All types of computers

What is a typical speed for a mid-range CPU to run at? -Around 2 GHz; budget models might run as low as 1 GHz, while faster ones run at 3 or 4 GHz. -Around 2 MHz, if you overclock it. Most still run at 1 MHz. -Around 4 GHz for each core processor. -1.21 Gigawatts.

Around 2 GHz; budget models might run as low as 1 GHz, while faster ones run at 3 or 4 GHz.

Which is a true statement regarding whether or not laptops make good servers? A. Their size and weight make them perfect for a server rack, and this allows for better cooling. B. There are limited options for expansion, and its components are not practical for network-wide use cases. C. Their redundancy makes them reliable, particularly during power outages. D.Their mobility allows for more flexibility in where you store the server.

B. There are limited options for expansion, and its components are not practical for network-wide use cases.

A user has two USB drives connected to her PC. She complains that when she copies large files to both drives at the same time, it seems to take much longer. Why might this be? -Writing to USB drives can only occur one at a time. -The flash drive partitions haven't been formatted. -Bandwidth on the USB bus is shared between all devices. -She has the cables swapped backwards.

Bandwidth on the USB bus is shared between all devices

In general, what is the difference between the char and string data types? There is a limit on the amount of storage that can be used by a string. There is no limit for a character. Char is variable length field for storing a sequence of characters. A string stores a single textual character or string in a fixed length field (typically 1 byte). A number entered as a string cannot be used for mathematical operations. When a number is entered as a character data type, you can perform mathematical operations on it. Char stores a single textual character in a fixed length field (typically 1 byte). A string is a variable length field for storing a sequence of characters.

Char stores a single textual character in a fixed length field (typically 1 byte). A string is a variable length field for storing a sequence of characters.

You need to plug a microphone into a computer to make a recording. How would you identify which jack to use? The jack is typically color-coded green. The jack is typically color-coded pink. Plug into the RJ45 Jack. Use the HDMI connection.

The jack is typically color-coded pink.

You have to sign in to Windows - does it matter if the CAPS LOCK light on the keyboard is activated? Windows usernames and passwords are converted to upper case, so the CAPS LOCK does not affect login. Windows usernames are not case sensitive, so the CAPS LOCK does not affect login. Windows passwords are case sensitive, so the CAPS LOCK may prevent successful login. Windows passwords are not case sensitive, so the CAPS LOCK key is ignored during login.

Windows passwords are case sensitive, so the CAPS LOCK may prevent successful login.

Your computer locks up (freezes) periodically and feels hot to the touch. Could these things be related? No, two different problems likely exist that need troubleshooting. Yes, overheating often occurs when the computer is locked up. No, temperature of your computer does not affect computer operation. Yes, many lockup problems are caused by overheating.

Yes, many lockup problems are caused by overheating.

Which system object provides the functionality for a hardware component? A directory A device driver A program A document

A device driver

What type of component provides a passive cooling solution? An insulation blanket A cooling fan A liquid cooling system A heatsink

A heatsink

You have asked a senior manager to authorize your plan of action for resolving a fault in a software application. What name is given to the process you are following? Verifying full system functionality Testing the theory Considering multiple approaches Escalating the problem

Escalating the problem

What type of software manages tasks, dependencies, and timelines? Accounting software Project management software Database software Business-specific applications

Project management software

What three things define an object? Properties, attributes, and methods Branches, loops, and operators. Data, information, and insights Stored value, class, and interface

Properties, attributes, and methods

How can a client-server application architecture be described if it could be re-developed to split the application and presentation layers? This could be described as a two-tier application capable of becoming a three-tier application. This could be described as a one-tier application capable of becoming a two-tier application. This could be described as a three-tier application capable of becoming a n-tier application. This could be described as a n-tier application that cannot be further re-developed.

This could be described as a two-tier application capable of becoming a three-tier application.

What term is used to describe terminating a process that is not responding to user input? This is often called "killing" the process. This is often called "exterminate" the process. This is called "choking" the process. This is called "process abort."

This is often called "killing" the process.

Why is a smartphone NOT a good tool for writing a report? They have great user interfaces that enable you to write quickly. Touchscreen or mini keyboards are not optimized for writing lots of text. They have large displays with excellent resolution. Their size makes them easy to place in ergonomic positions.

Touchscreen or mini keyboards are not optimized for writing lots of text.

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 Turn Windows features on or off dialog tab from Programs and Features (if available). Try using the Repair option in Programs and Features (if available) or re-installing the program. Try using the software components tab under Device Manager to fix the problem. Log into User Account Control and edit the settings in the control panel and reduce the security posture. It may have blocked the other program.

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

Which of these statements is NOT true about Universal Serial Bus (USB) cables? There are USB cables with normal size connectors on one end and mini or micro device connectors on the other. The connectors for the host (PC) and device use different form factors. USB cables never have the same connectors at either end. There are now USB cables with reversible Type C connectors.

USB cables never have the same connectors at either end.

Which data representation format can encode the widest range of characters? Binary ASCII Unicode Hex

Unicode

Which type of display interface does NOT support high definition digital picture resolution? HDMI VGA Thunderbolt DVI

VGA

What should you do before attempting to set up a new computer system? Verify that the environment is suitable and that the installation will be safe. Verify that the computer is concealed within a desk compartment and out of sight. Verify that the computer cables are loose and free of any bindings. Verify that the placement maximizes space even if the keyboard is in an awkward place.

Verify that the environment is suitable and that the installation will be safe.

Which of these statements is FALSE regarding the Windows 10 versions available? Windows 10 Enterprise is similar to the Pro edition but designed for licensing by small businesses. Windows 10 Pro comes with extra networking and management features. Windows 10 Home is designed for domestic small/home office business use. Windows 10 Education/Pro Education is for schools and colleges.

Windows 10 Enterprise is similar to the Pro edition but designed for licensing by small businesses.

Which of these statements is false? You can transfer images from the camera over Wi-Fi or Bluetooth if supported. You can connect the camera itself to the PC over a USB cable. You can remove the flash media from the camera and insert it into a flash reader. You can connect the camera's flash memory card directly into your computer's USB port.

You can connect the camera's flash memory card directly into your computer's USB port.

Why might you use the Microsoft Management Console (MMC) Services snap-in to manage background processes rather than Task Manager? The Task Manager allows you to modify which user or system account the service runs as but the Services snap-in has restart functionality. The Service snap-in tool allows you to start and stop services, but the Task Manager will also allow you to configure service properties. Task Manager allows you to start and stop services but the Services snap-in also allows you to configure service properties. The Task Manager requires administrative privileges to run but the Services snap-in can be run by any user.

Task Manager allows you to start and stop services but the Services snap-in also allows you to configure service properties.

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. That you read the End User License Agreement (EULA) and agree to the terms of the license agreement. That you select the "repair" option if the software program has stopped working properly. That you review the advanced options and select specific feature sets.

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

What kind of data would you expect to find in a file with a TIFF extension? This is a text format. This is a video format. This is a sound format. This is an image file format.

This is an image file format.

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? Look in the Warranty information packet. Usually via the Help > About menu. Open the System Settings menu. Search manufacturer's website.

Usually via the Help > About menu.

What is the file path to the Documents folder for a user named "David", assuming Windows is installed to a hard disk with a single partition using the default settings? c:\Users\David\Documents d:\Users\David\Documents C:\Windows\DAVID\Documents D:\Windows\David\Documents

c:\Users\David\Documents

You want to purchase a flat panel monitor that can show widescreen movies. Which native resolution should you choose? 1024x768 1920x1080 1920x1440 1400x1050

1920x1080

A hard drive is rated at 10,000 rpm. What is the significance of this statistic? A measurement of the capacity of the drive A measurement of the speed of the drive A measurement of the composition of the drive's platters A measurement of the access time for information on the drive

A measurement of the speed of the drive

What type of computer is most likely to need peripheral devices? .Smartphone Laptop Desktop Server

Desktop

What is an interpreted programming language? Interpreted languages represent machine code in human-readable text and are typically specific to a particular hardware architecture. Interpreted languages do not need to be compiled and are designed to retrieve specific records from a data set. Interpreted languages do not need to be compiled because the code gets converted to machine code at runtime. Interpreted languages organize data through structured nested tags and are rendered by a web browser.

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

What function of a scanner would you use if you want to convert a letter that someone has mailed to you into a computer-editable document? Optical Character Recognition (OCR). TWAIN Windows Image Acquisition (WIA) Portable Document Format (PDF) or Joint Photographic Experts Group (JPEG)

Optical Character Recognition (OCR).

What is the main advantage of using a CPU in 64-bit mode? It's new and technically more scalable than the 32-bit CPU. CPUs don't use 64-bit mode; they are limited to 16 bits. This means that each instruction is 16-bits "wide". There are no advantages of a 64-bit CPU over a 32-bit CPU. They cost more money and are not worth the cost. 64-bit software is more reliable and is faster than 32-bit software. It also supports more system memory.

64-bit software is more reliable and is faster than 32-bit software. It also supports more system memory.

You want to purchase a computer with a fast graphics interface. What type of expansion slot should you look for? Motherboard SIMM slots—this type of slot has 30-pin slots typically used in laptops while the 64-pin and 72-pin slots were found on desktop motherboards. SDRAM and DDR—this type of slot is common for desktop computers (if you use a laptop, you need to look for a SODIMM) each having various types and speeds. PCIe x16—this is a type of PCI Express slot that uses 16 'lanes'. Each lane can transfer 250 MBps (or 500 MBps for PCIe 2 and 1 GBps for v3). Connect solid-state graphics to the high-speed SATA slots and mechanical disk drives to the lower-speed slots.

PCIe x16—this is a type of PCI Express slot that uses 16 'lanes'. Each lane can transfer 250 MBps (or 500 MBps for PCIe 2 and 1 GBps for v3).

You are trying to find a use for an old dot matrix printer. The only port on the printer is a large edge-style one with 36 contacts. What type of port is this? USB port Parallel port HDMI port RJ45 port

Parallel port

What is TRUE about legal protection for a novel software algorithm? Patent provides the best protection as it can enforce ownership even if someone tries to write the algorithm in a slightly different way. Trademark provides the best protection as it can enforce ownership to protect the unique elements of a software algorithm. You can only copyright the name, not the software algorithm itself. The copyright will make you the sole owner of that brand. You can't legally protect a novel software algorithm. It will be owned by the original publisher of the software that you used to create it.

Patent provides the best protection as it can enforce ownership even if someone tries to write the algorithm in a slightly different way.

Your colleague has to run many applications at the same time and finds it difficult to know which icon to choose when switching between them. What alternative method could you suggest? Place all the application shortcuts within a favorites folder for quick access. Press Alt+Tab - this shows previews of the window and allows the user to quickly switch between windows. Upload documents to the cloud and use a cloud interface to switch between them. Press "CTL-ALT-DEL" - task manager will show him a list of all the active programs.

Press Alt+Tab - this shows previews of the window and allows the user to quickly switch between windows.

What type of software would you use to configure a server by connecting to it over the network? System restore Wireless input device Collaboration software Remote desktop

Remote desktop

A friend is asking for your help in using her computer. When your friend presses the key marked @, the " symbol appears. What could be the cause? The keyboard is set to use a UK layout. Somebody has moved a key to a different place on the keyboard. The Shift button doesn't work properly. The keyboard is broken.

The keyboard is set to use a UK layout

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 Repair option inherent in most programs to automatically fix this issue. The program's Details tab to use settings for the latest version with the latest patches. Use the uninstall/reinstall feature that should fix any compatibility issues you may have. Use the program's Compatibility tab to use settings for the older Windows version.

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

What are the structural elements of a database? Each table stores information about queries and reports. Each query stores information about tables in reports. Each report stores information about tables in fields. Each table stores information about records in fields.

Each table stores information about records in fields.

Your computer has 4 SATA ports. How many hard drives can be installed? Two drives Eight drives Four drives Zero drives

Four drives

The Task Scheduler allows you to run a process automatically in Windows. What is a widely-used Linux equivalent? Taskkill Cron Vi Nano

Cron

Which four toners are used to produce color prints? Red, green, blue, black Cyan, magenta, yellow, and black Red, blue, yellow, and black Light blue, pink, yellow, black

Cyan, magenta, yellow, and black

You have a motherboard that is designed for Double Data Rate 2 (DDR2) memory that works at a bus speed of 533 MHz. You have some DDR3 memory modules that also work at a bus speed of 533 MHz. Are the modules compatible with the motherboard? DDR3 modules cannot be used in DDR2 slots. DDR3 modules can be used in DDR2 slots. DDR2 and DDR3 are packaged in DIMMs and can be used in any slots. DDR2 and DDR3 are both packaged in SO-DIMMs and can be used in any slots.

DDR3 modules cannot be used in DDR2 slots.

An INSERT statement is an example of what data language type? Both Data Manipulation Language and Data Definition Language Data Definition language Data Manipulation Language Neither Data Manipulation Language nor Data Definition Language

Data Manipulation Language

Which Windows interface is used for advanced management and troubleshooting of devices? Display tab Web configuration Personalization applet Device manager

Device manager

What data protection technology could you implement in order to restrict the type of activity that a user could employ on digital products that they have purchased or rented? Trademark Patent Digital Rights Management Copyright

Digital Rights Management

Give two examples of semi-structured data stores. Relational databases and text files Key/value pair database and PowerPoint presentations Key/value pair databases and markup language document stores. Word documents and PowerPoint presentations

Key/value pair databases and markup language document stores.

You are considering buying a new display device. The model you are considering accepts digital inputs only. Your computer's graphics adapter has a blue port with 15 holes. Would this flat panel be a wise purchase? Yes, as this connector is DVI which supports digital only. No, as this connector is VGA which supports analog output only. Yes, as this connector is HDMI which supports both digital and analog. No, as this connector is DisplayPort which supports analog output only.

No, as this connector is VGA which supports analog output only.

You need to configure settings for a bluetooth device. What should be your first step? Configure the wireless adapter to connect to the new input device. Open the Settings app or Control Panel. Go to the Printers and Scanners tab in system setting. Open the Settings add or remove programs.

Open the Settings app or Control Panel.

What type of file system must be used for the partition where Windows 10 is installed? The NTFS file system The FAT-32 files system The ext file system The HFS+ file system

The NTFS file system

What default installation folders contain system and application files that should not normally be deleted or modified manually? The Downloads folder The Windows and Program Files folders. The Temp folder The Desktop folder

The Windows and Program Files folders.

Why might one of your first tasks on receiving a new computer be to remove software applications? The computer may already have a virus pre-installed that you do not want. The computer may be bundled with pre-installed software that you do not want. The computer may have spyware bundled in that will watch every action that do on your computer. The computer may not have enough storage left to run any of the software applications.

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

What two things are configured on a disk to make storage space on the disk available to the Windows OS? The disk must have a recovery file and configure the backup settings to point to that file. The disk must have 6 GB of RAM configured and the system should automatically allocate a matching pagefile. The disk must contain at least one partition, typically allocated a drive letter, and the partition must be formatted with a suitable file system. The GUID Partition Table (GPT) needs to be configured and then you must populate the volumes.

The disk must contain at least one partition, typically allocated a drive letter, and the partition must be formatted with a suitable file system.

Why should you be more careful about deleting files from a USB flash drive than from the main hard drive? The files from the flash drive get recycled to the Windows recycle bin, making for easy recovery at a later time. The files from the main hard drive will not be recycled, so retrieving them if you change your mind will be very difficult. The files from a flash drive will not be recycled, so retrieving them if you change your mind will be very difficult. The files from the main hard drive get flagged for deletion but remain until the next Windows Update cycle.

The files from a flash drive will not be recycled, so retrieving them if you change your mind will be very difficult.

What crucial piece of information would you need when trying to locate support information about a computer system on the manufacturer's website? The type of keyboard and mouse you are using. The cost and date of purchase. The voltage on the power supply. The model number or a service code.

The model number or a service code.

What computer component is most restrictive in terms of determining upgrade potential for a desktop computer? System firmware The Network Interface Card (NIC) The motherboard The Graphics Processing Unit (GPU)

The motherboard

Your colleague is using a laptop and you notice that he laboriously clicks the external mouse repeatedly to scroll through the document you are co-editing. Which feature could he use to be more productive? The zoom function to zoom out so that each click scrolls through more pages The Ctrl + Arrow Keys to move through a document word by word instead of letter by letter The trackpad on the laptop since it is designed for easy scrolling The mouse scroll-wheel on the external mouse to maneuver the scroll bar

The mouse scroll-wheel on the external mouse to maneuver the scroll bar

What do you need to know to connect to a device that is configured over the network? Typically, the Internet Protocol (IP) address of its management page or the device's hostname Typically, the Media Access Control (MAC) address of the device you want to connect to Typically, the physical location of the computer Typically, the port in the wall where the network cable is plugged into

Typically, the Internet Protocol (IP) address of its management page or the device's hostname

You are looking for content on a topic, but your search is returning millions of matches that are not particularly helpful. Which option includes two methods that you could use to get better search results? Search using a broader criterion (don't be as specific), or use an asterisk (*) in place of a character in your search term. Use a different search engine, or start your search over and come back to it later. Use more search keywords (ideally with 'uncommon' words), or search for an exact phrase by enclosing it in quotes. Verify your spelling using a spellchecker, or use a question mark in place of a character in your search term.

Use more search keywords (ideally with 'uncommon' words), or search for an exact phrase by enclosing it in quotes.

Which method does a technician use to configure and improve a system's memory usage? Users do not configure any of the system memory setup because the OS handles all system memory activities. Use of virtual memory or a pagefile, where disk space is used to supplement system RAM. Use of general system memory, where a percentage of memory can be allocated to specific applications. Use of mass storage, where disks can be partitioned to separate OS files from user files.

Use of virtual memory or a pagefile, where disk space is used to supplement system RAM.

When setting up a desktop computer, what factor should you consider when deciding on the location of the system case? You need to find a dry and warm place where a cover can protect the unit from dust. You need to find the best location on the floor so that the system unit has accessible drives and USB ports. You need to check the proximity of the refrigerator to ensure that it is close enough. You need to consider the position of power outlet(s) and peripheral devices as well as air flow around the system unit.

You need to consider the position of power outlet(s) and peripheral devices as well as air flow around the system unit.

What type of disk has the greatest capacity? DVD that is dual layer and single sided DVD that is dual layer and double sided DVD that is single layer and single sided Blu-ray that is a single layer

Blu-ray that is a single layer

Which of these statements is true regarding how you set up your display? Dots Per Inch (DPI) or scaling is configured via the Personalization applet. Dots Per Inch (DPI) or scaling is configured via Display settings. Dots Per Inch (DPI) is determined by the monitor and device driver and cannot be user configured. Dots Per Inch (DPI) or scaling is configurable using your computers IP-based interface.

Dots Per Inch (DPI) or scaling is configured via Display settings.

What view options could you use to show files of a particular type sorted by date? Group the files by category, then sort by date. Group the files by date, then sort by file type. Group the files by file type, then sort by date. Group the files by file type, then sort by category

Group the files by file type, then sort by date.

What factors should you consider when positioning input and output devices? Ensure that there is proper lighting on your desk to illuminate the screen. Ensure that there is enough room on your desk to stack them on top of each other. Ensure that the monitor is located at the edge of the desk to maximize work area. Ensure that they can be used without exerting strain, especially on the arms / wrists and back / neck.

Ensure that they can be used without exerting strain, especially on the arms / wrists and back / neck.

How is a relationship identified between two tables in an RDBMS? Each table contains a foreign key whose value is unique for each record in the table. A secondary table can use the value of a foreign key as a relation, storing the value in a primary key field. Each table contains a primary key whose value is unique for each record in the table. A secondary table can use the value of a primary key as a relation, storing the value in a foreign key field. A relationship between tables is created and identified by the schema. A constraint defines the relationship between tables.

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

How does Microsoft SQL Server differ from Microsoft Excel when used to store a dataset? Excel is an example of relational database software that is better suited for larger volumes of information and more users, whereas SQL Server is a flat file system. Excel is an example of relational database software, whereas SQL Server is a flat file system that is better suited for larger volumes of information and more users. Excel is an example of a flat file system that is better suited for larger volumes of information and more users, whereas SQL Server is relational database software. 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.

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.

What shows the structure of code without using the specific syntax of any one language? Pseudocode Variables Functions Conditional statements

Pseudocode

What type of software is an ODF file associated with? Video conferencing software Word processing software Email client software Database software

Word processing software

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. Original Equipment Manufacturer (OEM) licenses can be transferred between different computers, just not at the same time. Original Equipment Manufacturers (OEM) licenses are only used in Enterprise environments, prohibiting use on a new computer. Original Equipment Manufacturer (OEM) licenses are authorized for use on multiple computer systems at the same time, enabling use on the new computer.

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

What is a zip file? A file archive containing other files in a compressed format. A Windows installer file used to install and uninstall software applications. A container file format designed to deliver Flash Video. An image file format most widely used for photographic pictures.

A file archive containing other files in a compressed format.

How is a Windows library different from a folder? A library acts as a virtual folder by displaying the contents of multiple folders, which could be located on different drives. A library is the user's private folder containing subfolders for different types of files like documents, music, and pictures. A folder acts as a virtual library by displaying the contents of multiple libraries, which could be located on different drives. A library and a folder are virtually the same thing.

A library acts as a virtual folder by displaying the contents of multiple folders, which could be located on different drives.

In a program, what does a loop do? A loop is a container that can be used as a term to reference multiple values or elements. A loop accesses a program element, such as a stored value, class, method, or interface. A loop performs one or more instructions until a condition is met. Loops grow or shrink in size as elements are added or removed.

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

How does a markup language differ from a compiled language? A compiled language is not a programming language, rather it is a way of using nested tags within a document to describe its structure and contents. A markup language is not a programming language, rather it is a way of using nested tags within a document to describe its structure and contents. A markup language is a programming language and is commonly used to retrieve data from a database. A compiled language is a programming language and is commonly used to retrieve data from a database.

A markup language is not a programming language, rather it is a way of using nested tags within a document to describe its structure and contents.

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. A function does something, while a procedure does something and then returns a value to the main program. A procedure is a container that can grow or shrink in size during program execution as elements are added or removed, while a function cannot be resized. A function is a container that can grow or shrink in size during program execution as elements are added or removed, while a procedure cannot be resized.

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

If you do not have a support contract, what is likely to be the best option for obtaining advice about a problem with an application? A product support or community forum Download a free application fix-it tool off the Internet Delete and reload the application Obtain a copy of the application from a third-party vendor

A product support or community forum

How would you access the system setup program on a PC? Historically, by pressing and holding the Windows key (4 little white boxes) on your keyboard. Modern PCs use the function key "F5" Historically, by pressing the appropriate key during startup (ESC, DEL, F1, F2, or F10). Modern PCs often use fast boot modes that require some other means of booting to the firmware setup program. Logically, by pressing CTL+ALT+DEL twice during startup. Just like when you want to exit a program on your PC. Logically, by pressing ALT+F4 during startup will access the startup menu through windows.

Historically, by pressing the appropriate key during startup (ESC, DEL, F1, F2, or F10). Modern PCs often use fast boot modes that require some other means of booting to the firmware setup program.

In terms of data storage, what is the advantage of using a server over a workstation? If data is stored on the server and not on the local workstation, it will be available to the user if a network device fails. If data is stored on the server and not on the local workstation, it is easier to apply access controls and to back it up. If data is stored on the server and not on the local workstation, it will be available during power outages. If data is stored on a local network storage device and not on specific workstations, different users will not be able to access the information.

If data is stored on the server and not on the local workstation, it is easier to apply access controls and to back it up.

Why would Windows prompt you to enter a password if you try to install a software application? Installing an application requires the use of the application's setup files which may require specific user privileges to access. Installing an application requires administrator privileges and is an action protected by User Account Control Installing an application requires a second level of verification. An administrator verifies a standard user and a second administrator can verify the first one. Installing an application requires that you have exited other applications so that the antivirus software can be disabled.

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

You are setting up a new computer, but it doesn't seem to be working. Should you check anything or contact the manufacturer? It's broken. Unplug everything and send it back. It's a brand-new computer, you don't need to check anything. It would be best to double-check you have connected the cables correctly. Just contact the manufacturer and get their technical opinion.

It would be best to double-check you have connected the cables correctly.

Why can't you use memory modules designed for a desktop computer in a laptop? Desktops use a different voltage level and it is unsafe to use DIMMs in a SO-DIMM slot because of overheating. You should be able to swap them because laptops and desktops both use the same type of DIMM Memory cards. The functionality of laptop and desktop memory are different enough so that one cannot be used in the other. Laptops use a smaller form factor called SO-DIMM while desktops use DIMMs.

Laptops use a smaller form factor called SO-DIMM while desktops use DIMMs.

What type of mouse would you recommend for someone who uses their computer principally to play computer games and why? Laser mouse — this registers cursor movements more quickly and accurately. Mechanical mouse — it requires less wrist movement and you don't need a mouse pad. A stylus mouse — as its accuracy is high and can easily be moved around the input field. Optical mouse — it senses movement relative to a surface using light instead of a roller ball.

Laser mouse — this registers cursor movements more quickly and accurately.

What is an example of open source operating systems? BIOS and UEFI firmware Windows and MacOS Embedded operating systems Linux, Chromium, or Android

Linux, Chromium, or Android

You have to open a word processing application, but you cannot see an icon on the desktop. What should you do? Look for the shortcut in Start Menu or Start Screen. Right-click on the desktop, go to view, and change the icon size to large. Double click the Blue E or Orange Fox in your taskbar, and search for the icon on the internet. Look for the shortcut in the C: drive of the computer.

Look for the shortcut in Start Menu or Start Screen.

What sort of device would you need to transfer data from a "Memory Stick"? Memory card reader / multi-card reader. A keyboard A wireless adapter A microphone and headset

Memory card reader / multi-card reader

In Windows, do letter-labeled "drives" correspond exactly to physical disks? Not in the case of hard disks, which can be configured with multiple partitions, each of which can be assigned a drive letter. Only in the case of hard disks, which are usually allocated letter "c." Not in the case of optical drives, which can be configured with multiple partitions, each of which can be assigned a drive letter. Only in the case of hard disks, which are usually allocated the letter "a."

Not in the case of hard disks, which can be configured with multiple partitions, each of which can be assigned a drive letter.

You are using the mouse to access a file located on a network server. There are currently no mapped drives. What should be your first step? Open the search dialog box and type the name of the file you are looking for. Open the This PC object from Explorer and locate the server hosting the file. Open the Quick Access object from Explorer and locate the server hosting the file. Open the Network object from Explorer and locate the server hosting the file.

Open the Network object from Explorer and locate the server hosting the file.

What basic command demonstrates that a printer is connected properly to a computer and that its driver is installed correctly for Windows? Run the troubleshooter Check devices and features Print test page. Printing preferences

Print test page.

You want to configure a printer to use both sides of the paper (duplex) by default. You have right-clicked the printer object. Which command should you select to proceed? Open Printer properties Printing preferences Troubleshoot

Printing preferences

You need a development environment with a library of database functions. What type of interface are you using? Direct/Manual Access Programmatic access Query/Report Builder Utility Access

Programmatic access

What type of connector would you NOT use for an external hard drive to connect to a Windows PC? USB Firewire eSATA RGB

RGB

Which of the following is NOT an example of unstructured data? PowerPoint presentation Image files Text files Relational databases

Relational databases

If you have made changes to a file and want to keep both the original file and the modified version, what command should you use? Share Save Save As. Export

Save As.

What IoT device may contain a "black box" that is able to record event data? Environmental controls Home appliances Window curtains Smart Vehicle

Smart Vehicle

How is sound processed in a personal computer? Sound functions in modern PCs will send your audio directly to an external radio for processing. Sound functions must be provided by a plug-in sound card. Sound functions are provided by a plug-in card with external speakers. Sound functions are often provided by the motherboard chipset.

Sound functions are often provided by the motherboard chipset.

Which of these statements is true regarding a standard user and their password? Standard users must get permission from the administrator to change a password. Standard users can change their own password but cannot change anyone else's password. Once a standard user sets their first password they cannot change or modify it. Password management is automatically controlled in the BIOS.

Standard users can change their own password but cannot change anyone else's password.

A printer is rated at 20ppm. What is the significance of this statistic? This is the number of projects per minute that your printer can handle. This is an image format used to measure the quality of an image the printer can produce. This is the number of pages per minute the printer can output. High page rates are important in high-volume environments. This is the voltage measurement of your printer.

This is the number of pages per minute the printer can output. High page rates are important in high-volume environments.

What type of wired interface is a printer MOST likely to use? HDMI USB VGA S/PDIF

USB

Windows comes with web server software, but it is not installed by default. How would you install this software? Use the Turn Windows features on or off dialog from Programs and Features. Use App Installer feature in Programs and Features tab to uninstall and then reinstall the web server software. Use the Repair option inherent in Programs and Features to automatically run the web server feature. Use the Server Software tab in Programs and Features to install the web server.

Use the Turn Windows features on or off dialog from Programs and Features.

You are configuring dual monitors positioned side-by-side. You want to increase the amount of screen space available. Which multiple display option should you set? Portrait orientation Extend the displays. Show only on display #2 Duplicate the displays.

Extend the displays.

Which notation system supports presenting the largest numbers using the fewest digits? Hexadecimal Decimal Binary KiloByte

Hexadecimal

What part of the process of data analytics is most closely supported by meaningful reporting? Insights Data Information Correlation

Insights

What key combination can you use to force the browser to ignore any locally cached files when refreshing a page? Ctrl++ Crtl+Alt+Del Ctrl+F5 Alt+F4

Ctrl+F5

What type of print technology uses toner? Inkjet Thermal transfer Laser Impact

Laser

What term is used to describe selecting and viewing information in a database? Report Query Storage Create

Query

What sort of device could you use to expand the storage capacity of a smartphone? A flash memory card An extra battery An SSD A SIM card

A flash memory card

You are advising a colleague about best practices when troubleshooting. You have identified the following techniques to use to identify a problem: gather information, duplicate the problem, question users, identify symptoms, and approach multiple problems individually. If you are following CompTIA's troubleshooting model, what other piece of advice should you give? Test the theory to determine a cause Research the knowledge base or Internet Establish a theory of probable cause Determine if anything has changed

Determine if anything has changed