Databases

Question 1

Concurrent Access

Answer 1

Many users can access the data. Data is consistent between users.

Question 2

Data Integrity

Answer 2

The maintenance that the data selected is correct

Question 3

Throughput

Answer 3

How many actions can be submitted per second

Question 4

Availability

Answer 4

The amount of users and times that can access the data

Question 5

Fault Tolerance

Answer 5

The system in place to correct the data should a partial part of the storage be corrupted

Question 6

Structured Query Language (SQL)

Answer 6

Language used to manage data in a Database Management System (DBMS)

Question 7

Database Management System (DBMS)

Answer 7

The software package which creates and manages the database.

Question 8

Declarative

Answer 8

Finding the most efficient way of completing a query

Question 9

Relations

Answer 9

A collection of attributes making a tables

Question 10

Data Definition Language (DDL)

Answer 10

Creates and deletes tables

Question 11

Data Manipulation Language (DML)

Answer 11

Query tables. Insert/Update/Delete

Question 12

Design Goals

Answer 12

Business rules, throughput, contain all data, readable

Question 13

Data Quality

Answer 13

Accuracy, completeness, consistency, reliability

Question 14

Business Requirements

Answer 14

Throughput vs availability

Question 15

Elements of Database Design

Answer 15

Conceptual modelling, logical design, distributed design, physical design

Question 16

Cardinality

Answer 16

Constraint on the number of entities in a relationship

Question 17

Weak Entities

Answer 17

Entities with no primary key. Borrowed part from another entity.

Question 18

Replace Many-Many

Answer 18

Associate entity with 2 one to many relationships

Question 19

Instance Diagram

Answer 19

Shows the structure of the relationships between entities

Question 20

ACID

Answer 20

Atomicity, Consistency, Isolation, Durability

Question 21

Atomicity

Answer 21

Each set of queries is treated as a single transaction

Question 22

Consistency

Answer 22

Each transaction will leave the database in a valid state

Question 23

Isolation

Answer 23

Transactions carried out sequentially or concurrently will produce the same result

Question 24

Durability

Answer 24

Transactions sent are completed entirely or not at all

Question 25

Rollback

Answer 25

Partial effects of a transaction are reverted