Chapter 5 Flashcards

1
Q

Database

A

a structured collection of data stored for use by one or more applications.

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

Database management system

A

a suite of programs for constructing and maintain the database

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

query language

A

provides a uniform interface to the database for users and applications.

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

How many primary keys and how many foreign keys may a table have in a relational database?

A

One primary key per tuple, but there can be multiple foreign keys.

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

What are the disadvantages to database encryption

A

Key management and inflexibility.

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

List and briefly define three cloud service models

A

Software as a service: Provides service to customers in the form of software.

Platform as a service: Provides service to customers in the form of a platform on which the customer’s applications can run.

Infrastructure as a service: Provides the customer access to the underlying cloud infrastructure.

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

relation

A

a flat table

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

Tuples

A

Rows

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

Attributes

A

columns

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

Primary key

A

portion of a row used to uniquely identify a row in a table

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

foreign key

A

a primary key in one table that appears as attributes in another table

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

view

A

a virtual table

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

Three attack types

A

inband, inferential and out of band.

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

cloud computing

A

a model for enabling ubiquitous, convenient, on-deman network access to a shared pool of resources.

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

essential characteristics of cloud computing

A
Broad network access
Rapid elasticity
measured service
on-demand self-service
resource pooling
How well did you know this?
1
Not at all
2
3
4
5
Perfectly