Exam 5: Database Processing

A(n) ___________ data model captures the entities and their relationships in a database application.

A DBMS can be used to add a new column to a table.

A group of columns that identify a unique table row is a __________.

A(n) ___________ DBMS is designed to process large organizational and workgroup databases.

Metadata is data about data.

Relational databases represent relationships through the use of formal keys.

Database integrity problems occur because of isolated information.

Removing data that is no longer wanted or needed is a task for the__________ _ function.

"PartNumber" would be a good identifier for a part entity in a database application.

What are the functions of a DBA? Search a job site such as monster or dice.com to find some advertisements for Oracle DBAs to see what they do.

Databases may have one or more________ , each of which may have multiple users..

Users have critical roles in database application development.

A(n) ________is an attribute or group of attributes whose value is associated with one and only one entity instance.

A group of similar records is called a________ .

It is very difficult and expensive to go back and change the ___________ once the database application is finished.

Database ________can be specifically limited..

SQL is a:

A _________ is the same as a field in a database table.

A database is a collection of tables, metadata, and ____________.

For Kant, the__________world is what really exists "out there".