Worksheetstesting
Total questions: 42
Worksheet time: 3hrs 15mins
Name
Class
Date
1.
How much storage does a character data type use?
a)
3 Bytes
b)
1 Kilobyte
c)
Your Mom
d)
1 Byte
2.
A table contains information about the company's customers. The information includes First Name, Last Name, Address, Phone, and Email for each customer. What's the best way to set up a primary key for this table?
a)
Your mom
b)
Create a new field called ID
c)
Link them together
d)
Create a new field called Primary Key
3.
After a system outage, a netowrk administrator restores data from a backup. What is the first step before allowing user access to the data
a)
test the system
b)
Your mom
c)
Ensure the integrity of the data
d)
Nothing, you'll find problems as users access the restored system
4.
In a SQL (Structured Query Language) command, what does the WHERE clause determine in the result set?
a)
Your mom
b)
Where you will teleport to
c)
Where the command executes
d)
Number of rows
5.
A laptop buitl a year ago is likely to have which Central Processing Unit (CPU)
a)
64-bit
b)
32-bit
c)
Your Mom
d)
It would have a GPU, not a CPU
6.
An Employee object includes the following fields:<br /><br />Name<br /><br />Address<br /><br />Phone<br /><br />Age<br /><br />DateOfBirth<br /><br />Salary<br /><br />Which of the following is NOT a good example of a method in this object?
a)
Name
b)
Your mom
c)
CalculateSalesTax, which multiplies two numbers (inputted as variables) and returns the result to the calling program
d)
Your Social Security Number
7.
How much storage does a character data type use?
a)
3 Bytes
b)
1 Kilobyte
c)
Your Mom
d)
1 Byte
8.
A table contains information about the company's customers. The information includes First Name, Last Name, Address, Phone, and Email for each customer. What's the best way to set up a primary key for this table?
a)
Your mom
b)
Create a new field called ID
c)
Link them together
d)
Create a new field called Primary Key
9.
After a system outage, a netowrk administrator restores data from a backup. What is the first step before allowing user access to the data
a)
test the system
b)
Your mom
c)
Ensure the integrity of the data
d)
Nothing, you'll find problems as users access the restored system
10.
In a SQL (Structured Query Language) command, what does the WHERE clause determine in the result set?
a)
Your mom
b)
Where you will teleport to
c)
Where the command executes
d)
Number of rows
11.
A laptop buitl a year ago is likely to have which Central Processing Unit (CPU)
a)
64-bit
b)
32-bit
c)
Your Mom
d)
It would have a GPU, not a CPU
12.
An Employee object includes the following fields: Name, Address, Phone, Age, DateOfBirth, Salary. Which of the following is NOT a good example of a method in this object?
a)
Name
b)
Your mom
c)
CalculateSalesTax, which multiplies two numbers (inputted as variables) and returns the result to the calling program
d)
Your Social Security Number
13.
Why doe companies pay for a software license subscription plan instead of a less expensive one-time purchase
a)
Because your mom said so
b)
One-time purchases don't include full-feature upgrades
c)
One-time purchases don't exist
d)
Companies want to sped as much money as possible
14.
What is the main purpose of Network Interface Card expansion (NIC) cards
a)
For your mom
b)
To extend the power of your onboard NIC
c)
To provide additional NICs to servers on a wired buiness network
d)
NIC expansion cards aren't used for anything<br />
15.
An attacker captures password packets to figure out a user's password and gain access to a host on a corporate network, masquerading as that user. Which of the following is the threat to integrity that described in this attack
a)
Man-in-the-middle
b)
Your mom
c)
Impersonation
d)
Adware
16.
What type of software is Microsoft Office
a)
Flat file
b)
Sharing software
c)
Your Mom
d)
Productitiy software
17.
A package-delivery service is working with address information, which contains a house number and a street name. What is the best data type to use for the house number?
a)
Integer
b)
Your mom
c)
String
d)
Variable
18.
What is an example of using a locally installed application without network access
a)
Printing
b)
Creating a Excel document
c)
Using Microsoft Word to write a letter
d)
Coding
19.
A computer program contains a boolean variable. What are the stored values of this variable?
a)
1,2,3,4,5,6
b)
0,1
c)
50100
d)
Your mom
20.
What type of language has working with datasets as its primary purpose?
a)
Python
b)
Your mom
c)
Query
d)
C++
21.
Which of the following best describes their capacity in petabytes?
a)
Cloud systems
b)
Microsoft Word
c)
Your Mom
d)
Zoom
22.
Which notation is a more efficient method to express large numbers?
a)
Binary
b)
UTF-8
c)
Hexadecimal
d)
Decimal
23.
Which of the following is exposed in a Man-in-the-Middle (MitM) attack?
a)
Your mom
b)
Plain text
c)
Cipher text
d)
Nothing
24.
Which of the following types of collaboration software is least sensitive to latency?
a)
Video Calls
b)
Your mom
c)
Typing in a document
d)
Document sharing
25.
Why is scalability an important consideration when choosing to use a database instead of a flat file?
a)
Nonscalabe systems increase their costs at the same rate as the number of users that they support
b)
It's not important
c)
Because your mom said it's important
d)
Nonscalabe systems decrease in cost at the same rate as the number of users increase
26.
Which of the following poses a higher risk to ensuring business continuity?
a)
Remote attacks
b)
Split Networks
c)
A converged network
d)
Your mom
27.
What is a key difference between copyright and a patent?
a)
Patents are created by computers
b)
Copyright protection happens automatically, but a patent must be applied and registered for
c)
Your Mom
d)
They're the same thing<br />
28.
Which feature of IoT (Internet of Things) for motor vehicles uses a component of IoT home automation?
a)
In-vehicle control over the house
b)
Your mom
c)
Maps
d)
In-vehicle entertainment
29.
Which of the following is most likely an example of cross-platform software?
a)
Game Pigeon (Apple texting app)
b)
Applications that run on a Dell PC and a Samsung smartphone
c)
Your Mom
d)
Windows OS
30.
Why is it important to protect computer data?
a)
Computer data is your mom
b)
Computer data is not important to protect
c)
Computer data is an asset
d)
Computer data is already protected
31.
The accountant of a small company uses a database application to maintain the list of vendors, their services and their invoices to the company. The application uses Microsoft Access for the database layer, with the front-end interface layer in Visual Basic, to work with the data and to generate custom reports. What is the application architecture of this system, which resides on the accountant's desktop computer?<br />
a)
One-tier
b)
Two-tier
c)
Your Mom
d)
Fifty-tier
32.
What is the difference between a software product key and a product ID?
a)
The product key activates the software, and the product ID is for technical support
b)
The product key is the same thing as your MAC address, product ID's are the same thing as your IP address
c)
The product key and product ID are the same thing
d)
The product key is your mom<br />
33.
When a general language performs scripting, what does it call on as part of the code?
a)
Linux commands
b)
Your mom
c)
System comands
d)
How should I know?
34.
How is business software different from productivity software?
a)
Business software is for a particular process, and productivity software is for general office functions
b)
They're the same thing
c)
Your Mom
d)
Business software is for general office functions and productivity software is for a particular process
35.
A web application needs to make changes to the contents of a table in a database, in response to a user's input. What method contains the command to do that?
a)
Data Definition Language (DDL)
b)
Data Manipulation Language (DML)
c)
Python commands
d)
Your mom
36.
What should a company that's trying to promote its goods and services have on it name and/or logo to protect it from imitators?
a)
Copyright
b)
Your mom
c)
Trademark
d)
Patent
37.
A database administrator needs to extend a table with another column. What method contains the commands to do that?
a)
Data Definition Language (DDL)
b)
Data Manipulation Language (DML)
c)
Trademark
d)
Your mom
38.
Which of the following SQL (Structured Query Language) is not a DML command?
a)
WHERE
b)
Your mom
c)
While
d)
DROP
39.
Why do laptops use a heat spreader instead of heatsinks in their cooling system?
a)
Heat spreaders are bulky objects with lots of height and weight
b)
Heatsinks are bulky objects with a lot of height
c)
Your Mom
d)
Heatsinks don't exist
40.
In addition to making a copy of an entire database, a program can invoke the SQL BACKUP command to work at which level?
a)
Flat file
b)
Excel
c)
Table
d)
Your mom
41.
What is the maximum transfer for the Firewire standard which uses 6-pin "alpha" connectors and cabling?
a)
200 Gbps
b)
400 Mbps
c)
Your Mom
d)
4e-7 Petabytes
42.
The first step in the troubleshooting process is to identify the problem. What are some of the components of this step?
a)
When in doubt, shut it down
b)
Resolve the problem
c)
Duplicate the problem
d)
Determine if anything has changed
100 %
