MIS Exam 2

Question 1

What is the purpose of a database?

Answer 1

-Organize and keep track of things
-Keep track of multiple themes
-General rule:
Single theme - store in a spreadsheet
Multiple themes - use a database

Question 2

What is a byte in a database?

Answer 2

a character of data

Question 3

What are alternative names for columns, rows, and tables?

Answer 3

records

Question 4

What is metadata?

Answer 4

special data that describes the structure of a database

Question 5

What are keys and foreign keys in a database?

Answer 5

a column or group of columns that identifies a unique row in a table

Question 6

What is a relational database and what are its features?

Answer 6

databases that carry their data in the form of tables and represent relationships using foreign keys

Question 7

What is DBMS and its three functions?

Answer 7

database management system.

create, process, and administer a collection of self-describing integrated records

Question 8

Which DBMS and non-relational data store products are available in the market?

Answer 8

?

Question 9

Will NoSQL replace relational DBMS?

Answer 9

only for specialized applications

Question 10

What is SQL?

Answer 10

• Structured Query Language
• international standard
• a DBMS product from microsoft

Question 11

What is a database application and what does it do?

Answer 11

Collection of forms, reports, queries and application programs serves as intermediary between users and database data.

Question 12

What are features of browser-based applications?

Answer 12

Provide security, maintain data consistency, and handle special cases.

Question 13

What is the nature of cloud?

Answer 13

elastic leasing of pooled computer resources over the internet

Question 14

What does it mean for cloud to be elastic?

Answer 14

Leased computing resources increased or decreased dynamically, programmatically, in a short span of time and organizations only pay for resources used.

Question 15

What are web services?

Answer 15

they are SOA-designed programs that comply with web service standards

Question 16

What are pros and cons associated with cloud-based and in-house hosting?

Answer 16

?

Question 17

Why is cloud hosting becoming popular?

Answer 17

virtualization allows instantaneous creation of new virtual machines

Question 18

What is SaaS, Paas, and Iaas?

Answer 18

Saas (software as a service)
Paas(platform as a service)
Iaas(infrastructure as a service)

Question 19

What is CDN and what are CDN’s benefits?

Answer 19

content delivery network.

they reduce users access cost by delivering data faster

Question 20

What is VPC and what are its characteristics?

Answer 20

virtual private cloud

-can be built on public cloud infrastructure

Question 21

What is the difference between VPC and VPN?

Answer 21

VPC provides the advantages of cloud storage, but a VPN by itself cannot provide these advantages.

Question 22

What is the advantage of using a private cloud over a VPC?

Answer 22

Unlike a VPC, a private cloud does not require permission from regulating bodies to host sensitive data.

Question 23

What is VPN and what are its characteristics?

Answer 23

virtual private network

• it uses the internet to create secure point-to-point connections
• it sends encrypted messages over the public internet

Question 24

What are potential consequences of cloud computing in the future?

Answer 24

the cost of creating elastic resources will decrease