Review Questions

Question 1

Which software is a set of programs that helps the user to complete tasks?

Answer 1

application software

Question 2

Leading and following

Answer 2

are business strategies

Question 3

Motherboard

Answer 3

is considered a primary circuit board

Question 4

Entities

Answer 4

store information/data about a person, place, thing, transactions and events

Question 5

where do businesses store their information before business databases? comes along?

Answer 5

filing cabinets

Question 6

when creating queries where are they being stored at?

Answer 6

navigation pane

Question 7

a row in a data table is called a what

Answer 7

a record

Question 8

what is it called when trying to clarify purpose of information

Answer 8

field description

Question 9

which views modify the structure of the table

Answer 9

design view and data sheet view

Question 10

what is the difference between entity and attribute?

Answer 10

entity is a table and attribute is a field, difference is entity stores person, place, etc. and attribute represents the specific information that has been input in a table

Question 11

database allows you to:

Answer 11

create, read it, update it, and delete

Question 12

which attribute can be calculated by using another attribute

Answer 12

dependent attribute, derived

Question 13

advantage and disadvantage of access

Answer 13

multiple users that is both an advantage and disadvantage

Question 14

what to avoid when creating a well thought report..?

Answer 14

redundancy

Question 15

what is considered a composite attribute?

Answer 15

things like an address which can be broken down into simple

Question 16

what is considered to be a multivalued attribute?

Answer 16

things that you can get 2 more of like cars, degrees, books, groceries, etc.

Question 17

single attribute

Answer 17

special unique only one of those like UIN, drivers license number, age

Question 18

things to expect to find in the TAMU database?

Answer 18

UIN, address, name, birthdate

Question 19

things you would NOT expect to find in TAMU database

Answer 19

weight, height

Question 20

what are some comparison operators?

Answer 20

<,>,=,<=,>=

Question 21

what are some of the files that can be inputed into access?

Answer 21

excel, text files, html, xml

Question 22

2 kinds of views

Answer 22

design and layout view

Question 23

whats one field that needs to be unique?

Answer 23

primary key

Question 24

what is it when you want to populate usable data?

Answer 24

data validation rules which used to ensure using usable data

Question 25

which object is used for presenting and decision making

Answer 25

reports

Question 26

which is used to input data to where it automatically goes into the table

Answer 26

forms

Question 27

which extracts data from the tables

Answer 27

queries

Question 28

when you create a table and form which record is displayed first?

Answer 28

the first record from that table

Question 29

when information is entered into a form

Answer 29

it goes into a record as the last latest record

Question 30

which will allow you to input zip code, phone numbers, etc.

Answer 30

input mask

Question 31

when trying to login into a tamu computer what does it make you do first

Answer 31

authenticate yourself

Question 32

way to start applications

Answer 32

GUI

Question 33

what is the standard called when its converting energy to 80%

Answer 33

80+ standard

Question 34

what consists of an external hard drive

Answer 34

USB drives, flash drives, anything thats external and you plug into a computer to access data

Question 35

pros and cons of backing up to an external hard drive

Answer 35

pros: another place to store data cons easier to lose a hard drive than to lose a whole computer

Question 36

is the cloud a better way to back up your data?

Answer 36

pros: -its on demand and you can access it from anywhere - you can determine what you want to see back up, -easy to adapt and change scale up or down, - you pay for what you use cons: - if you upload a corrupt file it could potentially corrupt the rest of your files - security you're not 100% sure where your information goes

Question 37

what do you need to know before using the cloud in your business

Answer 37

- know the advantages and disadvantages - only save things you need to be saved - make sure everything is saved properly - make sure you have access to it 24/7 - know when you need to scale up or down

Question 38

what type of cloud would a drug company use

Answer 38

community

Question 39

what do relational databases create

Answer 39

decrease redundancy, helps with mistakes, and scalable and flexible helps increase performance by keeping the data updated

Question 40

what is it called when you're trying to create a schema that creates visual representation

Answer 40

ERM, Enterprise Risk Management

Question 41

what is it called when you're trying to create a drawing that relates the attributes

Answer 41

ERD,Entity Relationship Diagram

Question 42

business usually place databases for multiple access?

Answer 42

network

Question 43

SQL is used to?

Answer 43

query data to extract data

Question 44

CSP stands for

Answer 44

cloud service provider

Question 45

what is the most common computer programming language called

Answer 45

SQL

Question 46

what kind of relationship is it if a student is taking many classes

Answer 46

1:M

Question 47

who created the internet

Answer 47

Tim berners Lee, his biggest regret lack of privacy and fake news

Question 48

which type of malware is used to steal personal data and information

Answer 48

spyware

Question 49

do IT professionals have an easier or harder time finding new jobs

Answer 49

easier

Question 50

which dept. takes a systematic approach when developing new products?

Answer 50

research and development dept.

Question 51

what are goods and services that are being sold called

Answer 51

products

Question 52

what are something that can go wrong when backing up from an external hard drive?

Answer 52

corrupt files, if you lose it you dont know who could find it and get access to it

Question 53

instead of saving everything to internal hard drive whats the best way to save data?

Answer 53

always make sure data is secured and backed up better to back up off site

Question 54

what is called that godaddy tried to offer?

Answer 54

IDrive

Question 55

what was the open source business software mentioned?

Answer 55

apache open office

Question 56

what is it called when a business wants to rent software to try it out

Answer 56

SaaS

Question 57

why did IDrive not make it

Answer 57

internet was too slow at that time

Question 58

who is the person that created policies and procedures for networks

Answer 58

network admins

Question 59

most common type of cable when creating a topology

Answer 59

twisted pair cable