Domain 8: Databases

Question 1

Controls all access to the database and enforces the database security

Answer 1

Database Management System (DBMS)

Question 2

• Allows for searching within a database

- i.e. Structured Query Language (SQL)

Answer 2

Query language

Question 3

• Creates relationships between records in tables by using a primary key
• Contains two-dimensional tables made up of rows and columns

Answer 3

Relational database

Question 4

Another name for a table

Answer 4

Relation

Question 5

Row in a database

Answer 5

Tuple

Question 6

Database column

Answer 6

Attribute

Question 7

Single cell in a database

Answer 7

Value

Question 8

Contains the data in a database

Answer 8

Cell

Question 9

• Selected from the set of candidate keys inside a table
• Used to uniquely identify the records in a table
• Relational databases require unique value in each tuple in a table

Answer 9

Primary Key

Question 10

Any attribute (column) in the table with unique values

Answer 10

Candidate Keys

Question 11

• Key in a relational database table that matches a primary key in a parent database table
• Used to enforce relationships between two tables

Answer 11

Foreign Key

Question 12

• Means that every foreign key in a secondary table matches a primary key in the parent table
• If not this is not true, integrity has been broken

Answer 12

Referential Integrity

Question 13

Means each attribute (column) value is consistent with the attribute data type

Answer 13

Semantic Integrity

Question 14

Means each tuple has a unique primary key that is not null

Answer 14

Entity Integrity

Question 15

• Removes redundant data

- Purpose is to make data in a database table concise, organized and consistent

Answer 15

Database normalization

Question 16

• Virtual tables you can query like a table
• Doesn’t store data
• Can combine data from two or more tables using joins
• Can be used to implement multilevel security

Answer 16

Database View

Question 17

Allows the creation of database tables, read/write access to those tables, and many other functions

Answer 17

Database query languages

Question 18

What are the two subset of commands for Database query languages?

Answer 18

1. Data definition language (DDL)

2. Data manipulation language (DML)

Question 19

Used to create, modify, an delete tables

Answer 19

Data definition language (DDL)

Question 20

Used to query and update data stored in the tables

Answer 20

Data manipulation language (DML)

Question 21

• Combine data with functions (code) in an code-accessible framework
• Data and functions form an object
• Objects can then be accessed, read, and, written to by using code written in an _____ programming language

Answer 21

Object-oriented databases

Question 22

• Log of all database transactions

- If database becomes corrupted, this can be used to restore the database

Answer 22

Database journal

Question 23

• Allows simultaneous reads and writes to multiple replicated databases by clients
• Provides a means of backing up an entire database or of creating high availability and redundancy

Answer 23

Database Replication

Question 24

Mirrors all database changes made to primary, but clients do not have access to this copy

Answer 24

Database Shadowing

Question 25

• Combines records and fields that are related in a logical tree structure (one-to-many)
• i.e. Organization chart, NCAA March Madness bracket system, DNS

Answer 25

Hierarchical database model