Lecture Test 2

Navigation » List of Schools » El Camino College » Computer Information System » CIS 13 – Computer Information System » Spring 2020 » Lecture Test 2

Need help with your exam preparation?

Existing Quiz Clients Login here

Below are the questions for the exam with the choices of answers:

Try The Exam

Question #1

Which aggregate function would be used to calculate the lowest field value for the selected records?

A minimum

B maximum

C count

D average

Question #2

In the criterion, <=250, the operator will return values for the specified field that are

A less than or equal to 250

B greater than or equal to 250

C equal to 250

D less than 250

Question #3

The comparison operator, < >, is used to insert a condition that means ____

A less than

B not equal to

C and

D greater than

Question #4

What data type is appropriate for a field containing street addresses?

A attachment

B number

C short text

D yes/no

Question #5

Skyler needs to print mailing labels for a fundraising campaign her company is hosting. Which type of software should she use?

A Word processing

B Presentation

C Spreadsheet

D Email

Question #6

Erin just bought a new coffee maker that she can control with Alexa to turn on automatically in the morning. She plugs the coffee maker into the wall outlet, but when she tells Alexa to turn it on, Alexa reports she can’t find the coffee maker. What does Erin need to do so Alexa can find the coffee maker?

A Connect the coffee maker to the Internet

B Turn the coffee maker off and back on again

C Plug the coffee maker into a port on the Alexa device

D Buy a different coffee maker from Amazon

Question #7

Lexie just bought a new smartphone and is looking through the pre-installed app She sees several apps she recognizes and some that are new to her. One of the apps is named for the manufacturer of her phone. What kind of app is this?

A Portable app

B Web app

C Native app

D App store

Question #8

Lisa is hanging out at a coffee shop with her laptop to work on her research paper using Microsoft Office Online. What must she do before she starts working?

A Save her document on a flash drive

B Plug her laptop power cord into a wall outlet

C Connect to the Internet

D Install Microsoft Office Online

Question #9

Skype is an app that allows you to make video calls to other Skype users. What type of app is Skype?

A Personal interest app

B Media app

C Communications app

D Productivity app

Question #10

What is the file management tool available by default on a Windows computer?

A iCloud

B Finder

C File Manager

D Clipboard

Question #11

What kind of port do you need to use a flash drive?

A USB

B DVI

C RAM

D DOCX

Question #12

Which of these file sizes is largest?

A 3KB

B 3B

C 3MB

D 3GB

Question #13

Which type of memory is nonvolatile?

A RAM

B Virtual

C ROM

D Cache

Question #14

Ricky’s computer keeps freezing when he’s running several apps or webpages simultaneously. What resource does his computer probably need more of?

A memory

B operating system

C storage

D power

Question #15

What software must every computer have at least one of?

A Operating system

B Antivirus app

C Browser

D Firewall

Question #16

Tristan just downloaded a new game he wants to play on his computer. What kind of file should he open in order to install and run the game?

A Executable file

B Desktop file

C Data file

D Text file

Question #17

When you open a program’s window on your computer, what kind of interface are you using?

A platform

B GUI

C SaaS

D utility

Question #18

How is SaaS software distributed?

A PrPreeinstalled in an operating system

B Through the Internet

C On a flash drive

D On an optical disc

Question #19

Nigel is about to purchase an office app for some tasks he needs to do for work. What will he have to consider before buying the app that will ensure the app will work on his computer?

A The computer’s operating system

B The computer’s form factor

C The app’s features

D The app’s price

Question #20

A ____ is an area in RAM or on the hard drive designated to hold input and output on their way in or out of the system

A sector

B segment

C buffer

D page

Question #21

What device can protect a computer from damage if the power suddenly goes out during a thunderstorm?

A UPS

B AC adapter

C compressed air

D backup drive

Question #22

For which of the following devices might a cooling pad help with overheating problems?

A laptop

B phone

C tablet

D desktop

Question #23

Which CPU clock speed is fastest?

A 3 MHz

B 3 GHz

C 3 million cycles per second

D 300 million cycles per second

Question #24

What kind of output does a 3-D printer create?

A visual

B logical

C physical

D audio

Question #25

You’ve just signed a document for an insurance settlement, and you need to mail it back to the insurance company. However, you want to keep an electronic copy of it for yourself. Which device would best help you do this?

A camera

B scanner

C keyboard

D webcam

Question #26

Rory is shopping for a computer to do some lightweight research, office work, and web browsing. She also wants to watch movies on her new computer. Which two factors will help maximize her computer’s speed when doing multiple tasks at one time?

A Form factor and CPU

B CPU and RAM

C RAM and storage

D CPU and storage

Question #27

Which computer type will take up the most space in a workspace?

A all-in-one

B tablet

C laptop

D desktop

Question #28

Riley needs more storage space on his small laptop, and he needs that storage to be accessible without Internet access. What is the best storage option for Riley to easily add to his computer?

A external hard drive

B optical hard drive

C magnetic tape

D cloud storage

Question #29

When you save a file to the cloud, where is it stored?

A internal storage

B remote storage

C flash drive

D external storage

Question #30

How many bits make a byte?

A 4

B 8

C 16

D 10

Question #31

What does 1 represent in stored data?

A A single character on the keyboard

B Absence of an electronic charge

C a single item in storage

D Presence of an electronic charge

Question #32

15. What kind of device is the camera on a smartphone?

A Input

B Output

C Memory

D Processing

Question #33

An all-in-one computer occupies less space and is difficult to service and upgrade because the components are housed in a very limited space.

A FALSE

B TRUE

Question #34

External hard drives and optical media are portable and can be used to transfer data from one computer to another

A FALSE

B TRUE

Question #35

The clipboard is a Windows term referring to _________.

A memory

B an internal hard drive

C the CPU

D an external hard drive

Question #36

All are pointing devices except__________.

A touchpad

B trackball

C mouse

D keyboard

Question #37

Memory is chip-based storage used by the computer and can be in the form of ___________.

A RAM

B CD’s

C virtual memory

D all of these

Question #38

Bandwidth determines the _____ that can be transferred on the bus in a given period of time.

A speed of data

B amount of data

C all of these

D distance of data

Question #39

A ____ is an electronic path over which data can travel.

A cache

B lane

C bus

D word

Question #40

The speed of a CPU (rated in gigahertz (GHz)) is called the _____.

A CPU clock speed

B system rpm

C system speed

D CPU rpm

Question #41

____ are very small pieces of silicon or other semiconducting material onto which integrated circuits, like CPU’s or memory, are embedded.

A Pentiums

B Pixels

C Chips

D Busses

Question #42

Which characteristic(s) is true of Solid State drives ?

A Its more durable than a magnetic hard drive

B It has no moving parts

C It is non-volatile

D All of the above

Question #43

There are a maximum of ___ numbers in a binary numbering system

A 2

B 10

C 1

D 0

Question #44

A ____ is equal to 1,024 bytes.

A gigabyte (GB)

B kilobyte (KB)

C megabyte (MB)

D terabyte (TB)

Question #45

A ____ is the smallest unit of data that a binary computer can recognize

A unicode

B pixel

C byte

D bit

Question #46

The numbering system used by computers, is called _________.

A 2

B binary

C decimal

D Machine language

Try The Exam

Fresh Grad Lands Job as Real Estate Agent With Help from Professional Writers

Need help with your exam preparation?

Below are the questions for the exam with the choices of answers:

Christian S.

Tyra

Linda

Manush

We accept payment