Review Questions Flashcards

1
Q

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

A

application software

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Leading and following

A

are business strategies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Motherboard

A

is considered a primary circuit board

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Entities

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

filing cabinets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

when creating queries where are they being stored at?

A

navigation pane

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

a row in a data table is called a what

A

a record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

what is it called when trying to clarify purpose of information

A

field description

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

which views modify the structure of the table

A

design view and data sheet view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

what is the difference between entity and attribute?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

database allows you to:

A

create, read it, update it, and delete

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

which attribute can be calculated by using another attribute

A

dependent attribute, derived

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

advantage and disadvantage of access

A

multiple users that is both an advantage and disadvantage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

redundancy

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

what is considered a composite attribute?

A

things like an address which can be broken down into simple

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

what is considered to be a multivalued attribute?

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

single attribute

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

things to expect to find in the TAMU database?

A

UIN, address, name, birthdate

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

things you would NOT expect to find in TAMU database

A

weight, height

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

what are some comparison operators?

A

<,>,=,<=,>=

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

excel, text files, html, xml

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

2 kinds of views

A

design and layout view

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

whats one field that needs to be unique?

A

primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

what is it when you want to populate usable data?

A

data validation rules which used to ensure using usable data

25
Q

which object is used for presenting and decision making

A

reports

26
Q

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

A

forms

27
Q

which extracts data from the tables

A

queries

28
Q

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

A

the first record from that table

29
Q

when information is entered into a form

A

it goes into a record as the last latest record

30
Q

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

A

input mask

31
Q

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

A

authenticate yourself

32
Q

way to start applications

A

GUI

33
Q

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

A

80+ standard

34
Q

what consists of an external hard drive

A

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

35
Q

pros and cons of backing up to an external hard drive

A

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

36
Q

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

A

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

37
Q

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

A
  • 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
38
Q

what type of cloud would a drug company use

A

community

39
Q

what do relational databases create

A

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

40
Q

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

A

ERM, Enterprise Risk Management

41
Q

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

A

ERD,Entity Relationship Diagram

42
Q

business usually place databases for multiple access?

A

network

43
Q

SQL is used to?

A

query data to extract data

44
Q

CSP stands for

A

cloud service provider

45
Q

what is the most common computer programming language called

A

SQL

46
Q

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

A

1:M

47
Q

who created the internet

A

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

48
Q

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

A

spyware

49
Q

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

A

easier

50
Q

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

A

research and development dept.

51
Q

what are goods and services that are being sold called

A

products

52
Q

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

A

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

53
Q

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

A

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

54
Q

what is called that godaddy tried to offer?

A

IDrive

55
Q

what was the open source business software mentioned?

A

apache open office

56
Q

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

A

SaaS

57
Q

why did IDrive not make it

A

internet was too slow at that time

58
Q

who is the person that created policies and procedures for networks

A

network admins

59
Q

most common type of cable when creating a topology

A

twisted pair cable