Font size
WorksheetsB.4 Practice Exam #1 April
Total questions: 32
Worksheet time: 29mins
When Jacob first starts his computer, he hears several warning beeps and nothing else happens. Which of the following is sending out the beeps?
Operating System (OS)
Heat Sink
Power Source
Power-On-Self-Test
You need a storage device that has very large storage capacity, is fast, and is relatively inexpensive. Which storage device will best suit your needs?
USB flash drive
Hard disk
SSD
Optical
What is the name of the narrow strip along the bottom of the Windows environment?
Navigation bar
Shortcuts menu
Toolbar
Taskbar
When protecting your online identity, which of the following is an internet security threat you need to be aware of?
Using a different password for each social media platform
Phishing attempts
USB key loggers
Using personal information
Christian has logged onto his bank's website. He wants to pay some bills electronically and transfer funds to his savings account. He checks to see if the padlock icon is visible in the address bar. The padlock is there, and it is green. What does that indicate?
You should not trust a green padlock
A highly trusted certificate
The green color has no meaning
The certificate is pending, but you should trust it anyway.
Brandon is a member of an online gaming community that makes files available to each other from their local hard drives. Which of the following BEST describes this file system feature?
Permissions
NTFS (New Technology File System)
Hierarchal file system
P2P (peer-to-peer) sharing
Which network type uses light pulses to transmit data?
Fiber Optic
Wireless
Cable
Satellite
Software that requires a monthly subscription fee is often called _______________.
Temporary Software
Online-only software
Web applications
Software as a Service (SaaS)
Which of the following is an advantage of using an 802.11n/ac standard over an 802.11b/g standard for a wireless network?hich of the following is an advantage of using an 802.11n/ac standard over an 802.11b/g standard for a wireless network?
An 802.11n/ac standard is encrypted.
An 802.11n/ac standard provides Bluetooth wireless networking.
An 802.11n/ac standard has many more non-overlapping channels.
An 802.11n/ac standard covers more distance.
As a database administrator, you want to speed up query retrieval time in your relational database. Which of the following SQL commands could you use to accelerate retrieving data with a query?
CREATE TABLE
CREATE INDEX
CREATE VIEW
ALTER TABLE
In a relational database table, columns are better known as ________________.
Categories
Records
Instances
Fields
Which of the following database features would provide a formatted, easy-to-read listing of the results of a query?
Report
Record
Form
SQL Command
Which of the following is an advantage of using a database over a flat file system?
Imports and exports
CSV files
Software upgrades
Processing speed
Which of the following SQL commands would change the title of a movie in a Movies relational database from "The Education of Rita" to "Educating Rita"?
UPDATE Movies FROM movie-title="The Education of Rita" TO "Educating Rita" WHERE id=124
UPDATE Movies SET movie_title="Educating Rita" WHERE id=124
UPDATE Movies OLD movie_title="The Education of Rita" NEW "Educating Rita" WHERE id=124
UPDATE movie_title="Educating Rita" IN Movies Where id=124
Which of the following is a SQL statement?
IF(C3>=65, “Pass”,”Fail”)
SELECT*FROM Orders WHERE OrderID=5
If len(sys.arv) !=2: print usage sys.exit (0)
var rollDie = (Math.floor(Math.random()*6)+1
Edward, a database user, would like to gather some specific information from a database and then manipulate the data in a spreadsheet. Edward then wants to save that information in a file format that will be used by another application. Which of the following database features would work BEST to accomplish this?
Table
Report
Form
Query
Which of the following is a Structured Query Language (SQL) command that lets you view information stored in a database?
SELECT
GRANT
RETRIEVE
CREATE VIEW
In programming, which of the following is the BEST use of a function?
Contain methods
Bundle data and methods
Provide reusable code snippets
Prevent unauthorized access to data
Select the tags you MUST use to have a proper HTML document. (Select three.)
<head>
<a>
<body>
<html>
<h1>
A developer is creating an application that requires a value to be stored with decimal precision. Which of the following data types should be used for the variables that will store these values?
Float
Boolean
Integer
String
Which of the following are specifically designed to help protect digital products? (Select two.)
Digital Rights Management (DRM) tools
Fair use
Technological Protection Measures (TPM)
US Patent and Trademark office
Trademarks
As a systems engineer, which of the following is the BEST way to secure a new wireless access point or router that you have just installed?
Enable the default firewall or a third-party firewall.
Change the device's default software.
Configure anti-malware software.
Make sure to use data encryption
Mark received an email from a software company claiming his account will be disabled soon. The email contains several spelling errors, an attachment, and states he should open the attachment for further instructions. What should Mark do?
Forward the email to a friend and ask for advice.
Open the attachment because he has anti-virus software installed.
Delete the email without opening the attachment.
Reply to the sender and ask if the attachment is safe.
What do biometrics use to perform authentication of identity?
Ability to perform tasks
Knowledge of passwords
Possession of a device
Biological attributes
Which of the following are examples of social engineering? (Select two.)
Shoulder surfing
Brute force password cracking
War dialing
Port Scanning
Dumpster diving
A technician is installing a cable modem that supplies internet connectivity for a home office.
Which of the following cabling types would be used to connect the cable modem to the cable wall outlet?
CAT 5e
CAT 6a
RG6
Multimode fiber
Which of the following notational systems is MOST likely used to represent a MAC address?
Binary
Octal
Decimal
Hexadecimal
Before two computers can communicate over a network, some type of network media must be used to connect the computers together. Which of the following are examples of network media? (Select three.)
Near Field Communications (NFC)
Fiber optics
Radio signals
Network protocols
Copper wiring
A technician walks into the office with a UPS. What sort of threat will this device prepare a system for?
Power outage
Wiretapping
Data redundancy
Denial-of-service
In which of the following situations should you expect total privacy?
Financial transactions
Instant messaging
Social networking
Email messages and attachments
Arrange the following from smallest to largest.
Kilobyte, Megabye, Terabye, Gigabyte
Kilobyte, Megabyte, Gigabyte, Terabyte
Megabyte, Kilobyte, Gigabyte, Terabyte
Megabyte, Kilobyte, Terabye, Gigabyte
Which of the following is the fundamental difference between WPA (Wi-Fi Protected Access) and WPA2 wireless encryption standards?
WPA2 uses WEP (Wired Equivalent Privacy).
WPA2 uses Rivest Cipher with TKIP.
WPA2 uses DES (Data Encryption Standard).
WPA2 uses AES (Advanced Encryption Standard).
