Download Computer Hardware and Software Fundamentals and more Exams Advanced Education in PDF only on Docsity!
NOCTI PRACTICE TEST
The unauthorized copying of software is referred to as: - Pirated Software There are images online that you want to use. The website states that the images are not copyrighted. You think you can use these without breaking the law. These images are referred to being in the what? - Public Domain The best security for passwords is: - Memorize it Eight bits equal how many bytes? - 1 One megabyte equals how many bytes? - 1,048, Storing data for the long term is called what? - Archiving A logical series of instructions given to a computer is called a what? - Program A technician can run a program or file on your computer that performs commonly repeated tasks. What is this program or file called? - Script What is one piece of hardware that can be used to prevent Carpal Tunnel Syndrome? - Wrist Rest Which of the following fire extinguishers should be used to put out an electrical fire? - Class C Of the following printers, which one actually touches the paper to print? - Impact What is the most popular port that can connect peripheral devices like printers? - USB A single-sided, single density DVD recordable has a capacity of what? - 4.7 GB In Excel, the intersection of a row and a column is called what? - Cell A database file that contains all the information about a single entity is called what? - Record Margin, spacing, and font size are all examples of what? - Formatting Combining address file data with a form letter is called what? - Mail Merge What type of a network would you set up for use in a single building? - LAN
A network set up where each computer could be a server or a workstation is called what? - Peer to peer What is the most common networking protocol? - TCP/IP The wireless encryption of _______ is the weakest encryption used. - WEP A computer that has malicious software on it that can be controlled by a master computer is called what? - Bot A simple and inexpensive way to increase network security is to: - Keep all network equipment locked up and limit the number of people who have access - "access control" Select the most secure password from the list below: 07SuhBW36 ; Hbabies78 ; Password ; 67Eww98 - 07SuhBw The slowest connection to the internet is a ______ connection. - Dial-up Which of the following transmits data using light pulses? - Fiber optic cables Use Bluetooth technology for connecting: - Wireless accessories To make it easier for people to get to places on the World Wide Web, a ______ server translates a public domain name into its IP address. - DNS The OSI networking model contains ______ layers. - 7 A national or global network of computers is called a: - LAN A widely used method to display a network topology is a: - Network Chart A type of virus that copies itself repeatedly using up system resources is called? - Worm Entering the statement ("cat and dog"), without the parenthesis will return what results?
- Precisely "cat and dog" only What software is required to access .pdf files? - Acrobat Reader The general way to transfer files over the internet is to use? - FTP A/An ______ is an address for a web page or other resource online. - URL On the World Wide Web, the ______ is also known as the server. - Web host On the World Wide Web, the ______ is also known as the client. - Web browser
Organizing a solution that proceeds from the general to the specific is called? - Top- down design A program of logical series of ______ that tell a computer what to do. - Instructions Input/output devices are also known as? - Peripherals The term computer ethics, refers to - A person's conduct and behavior as a computer operator A user connected to the company LAN complains that he or she cannot access the Internet. No one else on the network is having this problem. The computer technician should first check the: - Ethernet Cable Select the most secure password from the list below: 078uhBU38 ; hbacon68 ; 93niGhkL ; kruystall23 - 078uhBU When keying a title in the first row of a six-column table, use the ______ option in the table menu to combine and center a title across all columns. - Merge To resize the chart in a spreadsheet, the user can: - Drag the corner of the chart A field that uniquely identifies a record within a database is called a/an _____ field. - Key When using a spreadsheet to specify a simple arithmetic expression perform ______ first. - Exponentiation What type of control function allows for the body of the loop to run a set number of iterations? - For next What is the default sort order in a database? - Ascending One component of a database file that contains all the information about a single entity is referred to as/an: - Record The two methods to consolidate data from multiple spreadsheets are position and: - Category The term, prioritizing, relates to: - Managing time Use Bluetooth technology for connecting: - Wireless accessories A router is a device that makes decisions about: - What network path packets should follow
To navigate to the next cell horizontally and the vertically in a word processing table, press the ______ key. - Tab The best method to test whether RAM is faulty is to - Replace faulty RAM with working RAM The two basic ways to retrieve records in most database programs are: - Find command and queries Choose the correct word to complete this sentence. An audit of our organization's financial records will be conducted on the ______ of September. - fourth Employees in the ABC Company have limited access to company information. This security measure is called: - Access Control A set of moral standards for judging whether something is right or wrong is known as: - Ethics A/An _____ is an address for a web page or other resource on the internet. - URL The crime of ______ occurs when someone obtains enough personal information about another person to masquerade as that person for access to credit and bank accounts. - Identity Theft In presentation applications, which of the following options is selected to add transitions to all slides? - Apply to all A file sent with an email message is called: - An attachment In a spreadsheet application, a reference that refers to the same cell or range on multiple sheets is called: - 3-D During the implementation phase, code is constructed by information gathered during the ______ phase. - Design A software program that automatically routes unwanted email advertisement and other junk mail to the deleted items folder or email software is called: - Spam filter A _____ would be used for detailed comments at the bottom of every page with a reference in a research document. - Footnote A high-end cellular phone that combines the functionality of a personal digital assistant and a mobile phone is called a/an: - Smart phone An input device that is used to identify fingerprints is: - Biometric device
A word or a very short line that appears by itself at the end of a paragraph is called a/an
- orphan When a disk error message appears during the boot-up process, the user should FIRST
- reboot the computer When referencing more than one worksheet in a formula, the user would use which of the following symbols? -! What option should the user select to play a sound clip continuously through a presentation? - loop until stopped The purpose of a subscript is to - designate an element of an array Text design, such as drop capitals and graphics embedded with watermarks, are both forms of ____ when using desktop publishing - special effects Unit testing is defined as the process of testing - each module individually to discover errors in the code When listening to a customer's complain, which of the following is the most important - repeat in concise terms the problem as understood What spreadsheet function returns the largest number in a range? - MAX Preset margins, tabs, line spacing, and fonts are all called ____ settings - default The most common networking protocol of the internet is - TCP/IP The ____ provides an interface between the user or application program and the computer hardware - operating system An approach that combines visual, audio, and interactive technologies is called - multimedia In a command prompt, which utility scans a hard drive for problems with the file system and also for bad sectors - chkdisk Which of the following sentences illustrates correct capitalization? - The White House is located in Washington, D.C. The wireless encryption of ____ is the weakest encryption used. - WEP A database ____ is a piece of code that is sent to a database in order to get information back from the database - query
Which of the following codes is produced by a compiler from the source code and is executed by the machine - object If all computers on the network segments do not have network connectivity, the computer technicians to examine the - switch When reviewing step-by-step procedures, an easy way to review the logical steps in a process is by creating a - flowchart To balance the text in columns, insert a/an ____ break - continuous section A technician is listening to a customer explain a problem. While listening to the customer, the technician should - make eye contact with the customer The ____ command would allow the user to see the border of a sheet of labels when working in a word processing document. - show guidelines One advantage of the off the shelf software over customer-written software is that - the purchase cost is relatively low to the development cost A design specification calls for a relational database to be designed and implemented that would enable "plain english" queries. The appropriate language would be - SQL A wrist grounding strap should be worn to repair a - system board Presentation program like Microsoft PowerPoint provides a variety of ____ to guide and simplify the process of designing presentations - templates The unit of measurement for a CPU speed is - hertz To view all the slides in presentation at the same time, use ____ view - slide sorter The ability to process both numerical and word processing data by collecting, deleting, modifying, analyzing, and summarizing is referred to as - data manipulation To give a list of options in a database, users are typically provided choices from a ____ box - control A VPN is used to link - home office (SOHO) users to headquarters internal network To change the word "Nebraska" to "New York" throughout a document with a single instruction, the user should choose - find and replace In an ERD, the ____ are known as independent items that can be identified uniquely, and are also referred to as nouns - entities
When you buy goods on the internet you are participating in - electronic commerce When buying a new computer the first consideration should always be - present and future use An example of a portable touchscreen device is? - smartboard A program that searches the web for keyboards and returns a list is called - search engine Physical components of a computer system are called - hardware Input and output devices are called - peripherals This device reads printed text and graphics and transfers it into a form the computer can use? - scanner RAM stands for - random access memory An input device that uses a LCD panel as the backdrop for input is - touch screen CPU is an acronym for - central processing unit An anti virus program is an example of - utility program Anti virus programs can - repair infected programs and files If you want to tie various locations together you would create a - WAN This is used to restrict information from traveling into and out of a computer. - Firewall What is the internet protocol that allows a user to safely transfer information? - SSL A program designed to copy onto other software and spread is called a - virus When prompted to insert the current date in a word document, use the following format.
- April 3, 2015 A word document with a full blank line between each line is called what? - double- spaced Preset margins, tabs, line spacing, and fonts are called _____ settings? - default What shape represents a decision in a flow chart? - diamond
If you are tasked with sending letters to 200 people, you should create what? - mail merge What is the best file type to use for mail merge? - .csv If you want to produce high quality marketing materials you should use the following software program - desktop publishing The y-axis scale on a 3-D chart is derived from - values in the worksheet To create a graph in excel, highlight - numbers in rows and columns When a formula is automatically updated it is called ____ referencing. - relative If you want to create a macro, you should use the following programming - VBA A common character used to create a delimited list to export from a spreadsheet is? - , A function must follow a set of established rules is called? - order of operations To store a person's contact information in email software, use this folder - contacts Introducing new products to people would make you use this software - presentation To maintain uniformity in a slide show use - theme What contains formatting and text that you can customize? - template If you don't want a document changed you should ____ it. - protect To completely change the format of one section of the document within the same page to a new format, you would use what kind of break? - section Text and graphics in top of each margin in a document are called? - headers This key is used when copying multiple sets of information. - CTRL In excel, what are the three types of information that can be entered? - text characters, numbers, formulas To reverse an action you should use the ____ command. - Undo What chart shows the relationship of a part to the whole? - pie To switch information from columns to rows in Excel, click the check box for? - transpose
If you use AND during a search, you are trying to - focus and narrow the search As each software application module is completed, it undergoes ____ to ensure each line of code operates reliably and correctly. - unit testing Which of the following is an advantage of unit testing? - errors are detected early Which programming method uses polymorphism, encapsulation, and inheritance? - object-oriented The concentration function allows a programmer to - build a string by combining strings Which of the following is a correct variable name? - last_name Which loop structure test at the beginning of the loop? - if/then If you make an error in programming a loop, it could have no terminating condition, called? - infinite The control method in Access that allows for more than two or more possible outcomes is called? - select A visual programming language used to create GUI's are known as ____ generation languages. - 5th To make a GUI you should use this programming language - visual Icons are used in this type of program - GUI A program execution error is called - runtime People that analyze new software as it is developed are called - beta testers User manuals are updated when? - When changes affect the user New user tutorials come with this - user documentation A help system that provides information about the current screen or screen item is said to be _____ sensitive. - context The problem solving process includes the 3 following steps - identify issue, search for facts, and find alternatives If a component fails and there is no alternative component to take its place, we call this - single point failure
The very first step in troubleshooting is always to check the - wire and cabling If an application stops running, use this to stop it - task manager If you have a question while using the software, always check this first - the help screen What should you use to remove software? - Add/remove program Use this to return the computer to the previous state - system restore When a central resource stores and manages files while local computers do most of the processing, it is called? - client/server
