CompTIA Job exam
What is the loopback ip address of a computer/network device.
127.0.0.1
What is the default port number for MSSQL
1433
What is the maximum amount of memory that 32 bit OS can address? What is the maximum that a 64 bit OS can handle?
32 bit: 4gb 64 bit: depends on OS
What is the default port number for MySQL
3306
.BAK extension refers usually to what kind of files?
A. Backup File
which of the following settings are found in CMOS?
A. Date and Time
When a program installed in Windows stops responding or encounters an error, logs describing error can be examined with the use of:
A. Event Viewer
A page from a laser printer is smeared? what is the most probable cause?
A. Low Toner
What levels of RAID use striping
A. RAID 0 C. RAID 2 D. RAID 3 E. RAID 4 F. RAID 5
What do domain controllers do?
A. Store the database, maintain the policies and provide the authentication of domain logons
Windows Vista and Windows 7 offer a security feature which limits privileges of software applications and access to administrative tasks. When a program makes a change that requires administrator - level permission or a user attempts to modify system settings that require administrative access it triggers an on screen prompt requiring an administrator password to proceed. This functionality is called.
A. User Account Control (UAC)
Although MS outlook is often used mainly as an e-mail application, it also provides features among the following:
A. a calander B. Task and contact management D. Allows web browsing
Blueberries cost more than strawberries. Blueberries cost less than raspberries. raspberries cost more than both strawberries and blueberries. If the first tow statements are true the third statement is.
A.True
Which of the following is a valid IP address?
B. 192.168.1.7
Ping
B. A computer network tool used to test whether a particular host is reachable across an IP network; it is also used to self test the Network Interface Card (NIC) of the computer.
Bandwith
B. A measurement of how much information can be carried in a given time period (usually a second) over a wired or wireless communications link.
In Excel, Is the formula = ((A2+B5) *5% valid?
B. No
What level of RAID is commonly known as "mirroring"?
B. RAID 1
With SQL, How do you select all the records from a table named "persons" where the value of the column "firstname" is "peter"?
B. SELECT * FROM Persons WHERE FirstName='Peter'
With SQL, how do you select a column named "Firstname" from a table named "Persons"?
B. SELECT FirstName From Persons
Previous versions are copies of files and folders that windows automatically saves as part of a restore point. Precious versions are sometimes referred to:
B. Shadow Copies
Two methods for recovering from a forgotten BIOS password are:
B. Shorting CMOS with a jumper E. Removing CMOS
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true.
B. True
If you want to move an MSSQL Database from server to another how do you do it?
Back up database on old server and restore database on destination server.
Where is the online chat icon located on our company website?
Bottom left
What does a VLAN do?
C. Breaks up broadcast domains in a layer 2 switch internetwork
Which of the following is not a purpose of an internet firewall?
C. Hide the identity of the user
Which of the following is a type of memory that cannot have information written to it?
C. ROM
Which SQL statement is used to extract data from a database?
C. Select
In excel, which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
C. Sum
Which protocol does DHCP use at the Transport Layer?
C. UDP
Which is not one of the four divisions or container structures in Active Directory
C. Webs
You have just completed a clean installation of Windows 7 and have removed the installation DVD from the drive. When you restart the system you receive the following error message, cant find bootable device. Which of the following would you do to correct the problem?
C. change the BIOS boot sequence
In Excel, A fast way to add up this column of numbers is to click the cell below the numbers and then:
C. click the autosum button on the standard toolbar, then press enter.
Malware is best defined as:
C. computer programs designed to infiltrate and damage computers without the users consent
When dealing with a customer, you should not?
D all of the above
One MB is equal to ...
D. 1024kb
What are group policy objects?
D. A collection of settings that define what a system will look like and how it will behave for a defined group of users.
What is the name of a Microsoft Windows feature that allows for encrypting entire drives.
D. Bitlocker
Clock Speed is measured in
D. Hertz
Marathon is to race as hibernation is to
D. Sleep
Which SQL statement is used to update data in a database?
D. Update
Which of the following are the system memory requirements for Microsoft Windows?
D. Win 10 : 1gb 32 bit or 2gb 64 bit
Why is great customer service important?
D. all of the above
What is GPF?
D. all of the above GPF: General Protection Fault
What does DHCP stand for and what is its purpose?
DHCP: Dynamic Host Configuration Protocol Purpose: Assigns IP addresses and configuration parameters to communicate with other IP networks
What does DNS stand for and what is it used for?
DNS: Domain Name System Purpose:to locate devices on a network
When someone says that an image is 300 dpi, what is the dpi stands for?
DPI: dots per inch
Which level of RAID should be used to provide high fault tolerance without the high cost of completely duplicating data without possible performance bottlenecks?
F. RAID 5
what does FTP stand for and what is the default port
FTP: File Transfer Protocol Port: 21
Name 2 different web servers that can run on windows operating system.
IIS, Apache
What does LAN stand for
Local Area Network
Servers are computers that provide resources to other computers connected to a:
Network
What does NAT stand for
Network Access Translation
what is an odbc stand for and what is it used for?
OBDC: open database connectivity API for accessing database management systems
What are two common driver types that a scanner uses to communicate with software applications?
OEM drivers, Virtual Device Drivers.
____ Controls the way in which the computer system functions and provides a means by which users can interact with the computer.
Operating system
The acronym for the process by which a computer tests its subsystem immediately when booting is:
POST
In the following address: 192.168.0.12:3325 what does 3325 stand for?
Port number
What does RAM stand for
Random Access Memory
SQL, Access, CRM and Oracle: which one is not a database application.
SQL
What is the latest version of MSSQL that has been fully released?
SQL server 2016
On a window domain controller server where can you add/manage users.
Server manager -> tools -> active directories
What is the difference between a switch and a router?
Switch: connects computers within a network Router: connects multiple networks together
What is the keyboard shortcut for copy
ctrl+c
What is the keyboard shortcut for paste
ctrl+v
what is the keyboard shortcut for cut.
ctrl+x
What are the default port numbers for unsecured/secured web publishing (http & https)
http: 80 https:443
What is the DOS command to find out the entire IP configuration of a computer.
ipconfig
can you run a 64 bit application on a 32 bit operating system?
no
What is the DOS command to find out if a computer is connected to a network?
ping *location* netstat
In MS outlook, the file extension for an Archive file is ______
pst
The standard cable used in ethernet based networking is called
rj-45
Which of these file extensions are images?
tiff, tif, gif, jpg, png
can you run a 32 bit application on a 64 bit operating system?
yes