Question 1

In a distributed database when the data is divided so that separate rows of the same table are at distinct locations that is referred to as _________.​

Accepted Answer

A) data replication 
B) ​horizontal partitioning 
C) vertical partitioning 
D) ​synchronization 
A) data replication 
B) ​horizontal partitioning 
C) vertical partitioning 
D) ​synchronization

Question 2

An attribute or set of attributes that uniquely define the rows in a table is called a(n)______.​

Accepted Answer

The answer of An attribute or set of attributes that...

Question 3

A formal technique for transforming a relational schema to an equivalent one that eliminates data anomalies is called _______.​

Accepted Answer

The answer of A formal technique for transforming a relational...

Question 4

A specific type of DBMS that organizes the data into tables is called a(n)______ ______ _____ _____.​

Accepted Answer

relational

Question 5

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.​

Accepted Answer

A) True 
 B)False

Question 6

A data type that is defined by extending or combining other data types is called a(n)______  data type.​

Accepted Answer

The answer of A data type that is defined by...

Question 7

Referential integrity is normally enforced by the ____.​

Accepted Answer

A) application programmer 
B) ​database management system 
C) operating system 
D) ​user 
A) application programmer 
B) ​database management system 
C) operating system 
D) ​user

Question 8

Microsoft SQL Server is an example of what?​

Accepted Answer

A) An application server 
B) ​A database management system 
C) A programming language compiler 
D) ​A Web server 
A) An application server 
B) ​A database management system 
C) A programming language compiler 
D) ​A Web server

Question 9

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.​

Accepted Answer

A) True 
 B)False

Question 10

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.​

Accepted Answer

A) True 
 B)False

Question 11

When it is necessary to update one database copy with changes made to the other database,it is called _________.​

Accepted Answer

database s

Question 12

Each class on an class diagram is represented by a(n)____ in a relational database.​

Accepted Answer

A) attribute 
B) ​row 
C) table 
D) ​column 
A) attribute 
B) ​row 
C) table 
D) ​column

Question 13

The person who is in charge of the structure and integrity of the data is called the _____ _____.​

Accepted Answer

The answer of The person who is in charge of...

Question 14

​What can be said about the following relational database table (key is underlined): (Choose the most correct answer)
StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

Accepted Answer

A) Not in any valid normal form 
B) ​In First Normal Form 
C) In First and Second Normal Form 
D) ​​In First, Second, and Third Normal Form 
A) Not in any valid normal form 
B) ​In First Normal Form 
C) In First and Second Normal Form 
D) ​​In First, Second, and Third Normal Form

Question 15

In a many-to-many association,the primary key of the created table consists of which of the following?

Accepted Answer

A) The primary keys of the associated tables 
B) An invented key with computer generated values​ 
C) The foreign keys of the associated tables 
D) ​Does not need a key field 
A) The primary keys of the associated tables 
B) An invented key with computer generated values​ 
C) The foreign keys of the associated tables 
D) ​Does not need a key field

Question 16

What does DBA stand for?​

Accepted Answer

database a

Question 17

A distributed database configuration which contains both global and local schemas and which allows purely local data is called a(n)______ ______ ______.​

Accepted Answer

heterogeneous distri

Question 18

List and briefly describe the four components of a database management system.​

Accepted Answer

1.Application Program Interface -- allow

Question 19

A(n)____________________ is a field or set of fields stored in one table that also exist as a primary key in another table.​

Accepted Answer

The answer of A(n)____________________ is a field or set of...

Question 20

A technique for protecting the database wherein every update to the database is recorded with audit information is called ______ ______.​

Accepted Answer

transactio

In a distributed database when the data is divided so that separate rows of the same table are at distinct locations that is referred to as _________.

An attribute or set of attributes that uniquely define the rows in a table is called a(n)______.

A formal technique for transforming a relational schema to an equivalent one that eliminates data anomalies is called _______.

A specific type of DBMS that organizes the data into tables is called a(n)__ _ ___.

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.

A data type that is defined by extending or combining other data types is called a(n)______ data type.

Referential integrity is normally enforced by the ____.

Microsoft SQL Server is an example of what?

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.

When it is necessary to update one database copy with changes made to the other database,it is called _________.

Each class on an class diagram is represented by a(n)____ in a relational database.

The person who is in charge of the structure and integrity of the data is called the _ _.

What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

In a many-to-many association,the primary key of the created table consists of which of the following?

What does DBA stand for?

A distributed database configuration which contains both global and local schemas and which allows purely local data is called a(n) __.

List and briefly describe the four components of a database management system.

A(n)____________________ is a field or set of fields stored in one table that also exist as a primary key in another table.

A technique for protecting the database wherein every update to the database is recorded with audit information is called .

From Beginning to End: An Overview of Systems Analysis and Design

Investigating System Requirements

Identifying User Stories and Use Cases

Domain Modeling

Use Case Modeling

Foundations for Systems Design

Defining the System Architecture

Designing the User Interface

Approaches to System Development

Project Planning and Project Management

Object-Oriented Design: Fundamentals

Object-Oriented Design: Use Case Realization

Deploying the New System

The Role of the Systems Analyst

The Traditional Approach to Requirements

Project Management Techniques

Filters

Exam 9: Designing the Database

In a distributed database when the data is divided so that separate rows of the same table are at distinct locations that is referred to as _________.​

An attribute or set of attributes that uniquely define the rows in a table is called a(n)______.​

A formal technique for transforming a relational schema to an equivalent one that eliminates data anomalies is called _______.​

A specific type of DBMS that organizes the data into tables is called a(n)______ ______ _____ _____.​

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.​

A data type that is defined by extending or combining other data types is called a(n)______ data type.​

Referential integrity is normally enforced by the ____.​

Microsoft SQL Server is an example of what?​

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.​

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.​

When it is necessary to update one database copy with changes made to the other database,it is called _________.​

Each class on an class diagram is represented by a(n)____ in a relational database.​

The person who is in charge of the structure and integrity of the data is called the _____ _____.​

​What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

In a many-to-many association,the primary key of the created table consists of which of the following?

What does DBA stand for?​

A distributed database configuration which contains both global and local schemas and which allows purely local data is called a(n)______ ______ ______.​

List and briefly describe the four components of a database management system.​

A(n)____________________ is a field or set of fields stored in one table that also exist as a primary key in another table.​

A technique for protecting the database wherein every update to the database is recorded with audit information is called ______ ______.​

From Beginning to End: An Overview of Systems Analysis and Design

Investigating System Requirements

Identifying User Stories and Use Cases

Domain Modeling

Use Case Modeling

Foundations for Systems Design

Defining the System Architecture

Designing the User Interface

Approaches to System Development

Project Planning and Project Management

Object-Oriented Design: Fundamentals

Object-Oriented Design: Use Case Realization

Deploying the New System

The Role of the Systems Analyst

The Traditional Approach to Requirements

Project Management Techniques

Filters

In a distributed database when the data is divided so that separate rows of the same table are at distinct locations that is referred to as _________.

An attribute or set of attributes that uniquely define the rows in a table is called a(n)______.

A formal technique for transforming a relational schema to an equivalent one that eliminates data anomalies is called _______.

A specific type of DBMS that organizes the data into tables is called a(n)__ _ ___.

Referential integrity is a consistent relational database state in which every foreign key value also exists as a primary key value.

A data type that is defined by extending or combining other data types is called a(n)______ data type.

Referential integrity is normally enforced by the ____.

Microsoft SQL Server is an example of what?

Classes that participate in a classification relationship can only be represented within a relational database as a single table containing all the attributes in each class.

One-to-many and many-to-many relationships are both represented by foreign keys in a relational database.

When it is necessary to update one database copy with changes made to the other database,it is called _________.

Each class on an class diagram is represented by a(n)____ in a relational database.

The person who is in charge of the structure and integrity of the data is called the _ _.

What can be said about the following relational database table (key is underlined): (Choose the most correct answer) StudentID,Name,Major,CreditsCompleted,GPA,AcademicStanding

What does DBA stand for?

A distributed database configuration which contains both global and local schemas and which allows purely local data is called a(n) __.

List and briefly describe the four components of a database management system.

A(n)____________________ is a field or set of fields stored in one table that also exist as a primary key in another table.

A technique for protecting the database wherein every update to the database is recorded with audit information is called .