WorksheetsDatabases Week 2 Review
Total questions: 12
Worksheet time: 6mins
Individual responsible for maintenance of database
Naive User
Application Programmer
Casual User
Database Administrator
This user is responsible for query tuning
Naive User
Casual User
Application Progarmmer
Database Administrator
Software that controls access to the database and is used to implement the physical database as well as backup and disaster recovery is called
CASE Tool
DMB
Database Management System
Coddulator
Units of a database that store data in rows and columns related to the same subject
CASE Tool
DBMS
Relationship
Table
A single row of information in a table
Record
Field
DBMS
Relationship
A single column in a database table
Record
Field
DBMS
CASE Tool
When we have the same data in multiple locations throughout a database, we call that
Concurrency
Redundancy
Efficiency
Normalcy
A field that uniquely identifies a record in a database
Primary Key
Foreign Key
Attribute
Index
A field in one table that is the primary key of another table and establishes a relationship between the two tables
Primary Key
Foreign Key
House Key
Attribute
This SQL command is used to specify which table(s) data is retrieved
SELECT
FROM
WHERE
INTO
This SQL command is used to specify which field(s) should be returned from the database
SELECT
FROM
WHERE
INTO
This SQL command is used to add a new row of data to a table
SELECT
INSERT
UPDATE
DELETE
