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