Definition of Terms Flashcards

1
Q

It is a collection of related data.

A

Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q
  1. Represents an aspect of the real world
  2. Logically coherent collection of data with some inherent meaning
  3. Designed, built, and populated with data for a specific purpose.
  4. Can be of any size and complexity
  5. May be generated or maintained manually
A

Implicit properties of a database

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

It is a computerized system that enables users to create a database

A

DBMS

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

This function of a database specifies the data types, structures, and constraints of data to be stored in the database.

A

Defining a database

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

This function of a DBMS is the process of storing the data on a storage medium which is controlled by the DBMS

A

Constructing

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

This function of a DBMS allows fetching or querying the database to retrieve specific data, updating database information to reflect changes and generate reports

A

Manipulating a Database

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

This function of a DBMS allows system protection against hardware or software malfunction or crashes, and security protection against unauthorized and malicious access.

A

Protecting a database

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

This function of a DBMS allows the database system to evolve as requirement change over time.

A

Maintaining a database

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

It is a subset of data that may contain virtual data that is derived from the database but not explicitly stored.

A

View

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