Computer study guide

Question 1

What is a data dictionary and what does it do for a database?

Answer 1

Documentation that says what the field types are

A data dictionary is a file or a set of files that contains a database’s metadata (data that provides information about other data). The data dictionary contains records about other objects in the database, such as data ownership, data relationships to other objects, and other data.

Question 2

What is a data warehouse?

Answer 2

Huge amount of data that is out there about some topic people use to gain insight into the topic.

data warehousing is a technology that aggregates structured data from one or more sources so that it can be compared and analyzed for greater business intelligence.

Question 3

What is a relational database?

Answer 3

Relational database has the columns and rows and has the ability to relate tables

Question 4

What does CPU stand for?

Answer 4

Central processing unit

Question 5

What does QBE stand for?

Answer 5

Query by example

Question 6

What is a bus?

Answer 6

Component of motherboard data moves around on

Question 7

What is a processor?

Answer 7

The main brains of the computer that allows for the computer to be operated and controls all operations

Question 8

What are the two parts of a CPU? What is the control unit?

Answer 8

1. The arithmetic logic unit (ALU), which performs arithmetic and logical operations.
2. The control unit (CU), which extracts instructions from memory and decodes and executes them, calling on the ALU when necessary.

Traffic cop moving things around moving the data into the cpu and the answers out of the cou

Question 9

What are the two parts of a CPU? What does ALU stand for?

Answer 9

arithmatic logic unit

Question 10

What is the definition of the word “data”?

Answer 10

data is unprocessed items or text or numbers

Question 11

What is a scanner?

Answer 11

Device that takes a printed page and converts it into pdfs

Question 12

What is DPI (dots per inch) as it relates to printers?

Answer 12

It’s the measrment of the quality of print

Question 13

What is MICR as it relates to the banking industry?

Answer 13

Micr is the wayt he banking industry can read the checks

Question 14

What is “capacity” as it relates to a hard drive?

Answer 14

It’s the size or storage space available on the hard drive

Question 15

How many bytes in a gigabyte?

Answer 15

billion

Question 16

How many bytes in a megabyte? Million

Answer 16

Million

Question 17

What is a RAID?

Answer 17

Redundent array of independent disc

• RAID (redundant array of independent disks; originally redundant array of inexpensive disks) is a way of storing the same data in different places on multiple hard disks to protect data in the case of a drive failure.

Question 18

What kind of operating system is Android? Mobile or Desktop?

Answer 18

mobile

Question 19

Who provides OneDrive?

Answer 19

microsoft

Question 20

What is a platform as it pertains to a computer?

Answer 20

Platform ex. Windows, mac. Platform puts out various version of itself every so often

Question 21

What is an RSI and what is ergonomics?

Answer 21

Repetitive stress or strain injury ex. Typing a lot and u et carpel tunnel. Ergonomics is the study of people’s efficiency in their working environment.

Question 22

What is a driver as it pertains to an operating system?

Answer 22

Something added to the operating system to get it to work. A driver is software and/or firmware that controls hardware. Often it connects an operating system with specific hardware devices.