Question 1

In a distributed database when the data is divided so that separate columns 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 B

Question 2

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

Accepted Answer

A) primary key 
B) ​foreign key 
C) object identifier 
D) ​candidate key 
A) primary key 
B) ​foreign key 
C) object identifier 
D) ​candidate key B

Question 3

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.​

Accepted Answer

A) True 
 B)False  False

Question 4

Including a total amount field as the sum of other fields in a table is a violation of second normal form.​

Accepted Answer

A) True 
 B)False

Question 5

A(n)____ describes the structure,content,and access controls of a physical data store or database.​

Accepted Answer

A) relation 
B) ​DBMS 
C) schema 
D) ​attribute 
A) relation 
B) ​DBMS 
C) schema 
D) ​attribute

Question 6

A relational database table is in ____________________ normal form if it has no repeating fields or groups of fields,i.e.if it has the same number of columns for every row.​

Accepted Answer

The answer of A relational database table is in ____________________...

Question 7

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.​

Accepted Answer

A) first 
B) ​second 
C) third 
D) ​fourth 
A) first 
B) ​second 
C) third 
D) ​fourth

Question 8

GUID stands for ______ ______ ______.​

Accepted Answer

globally u

Question 9

A field in a relational table called "address" would be an example of what?​

Accepted Answer

A) candidate data type 
B) ​primitive data type 
C) compound data type 
D) ​complex data type 
A) candidate data type 
B) ​primitive data type 
C) compound data type 
D) ​complex data type

Question 10

Relationships between tables is usually indicated through the use of a foreign key.​

Accepted Answer

A) True 
 B)False

Question 11

Which is not one of the responsibilities of the DA?​

Accepted Answer

A) Provide data naming standards 
B) ​Keep track of who owns the data 
C) Set up standards for data validation 
D) ​Establish user authentication for data access 
A) Provide data naming standards 
B) ​Keep track of who owns the data 
C) Set up standards for data validation 
D) ​Establish user authentication for data access

Question 12

A relational database management system stores data in tables.​

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a synonym of the others?​

Accepted Answer

A) column 
B) ​attribute 
C) field 
D) ​tuple 
A) column 
B) ​attribute 
C) field 
D) ​tuple

Question 14

Every table in a relational database must have a foreign key.​

Accepted Answer

A) True 
 B)False

Question 15

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?​

Accepted Answer

Referential integrity depends on primary

Question 16

A local business office with a small database which is only used by two or three users would most probably implement a desktop DBMS.​

Accepted Answer

A) True 
 B)False

Question 17

A(n)____________________ describes the structure,content,and access controls of a physical data store or database.​

Accepted Answer

The answer of A(n)____________________ describes the structure,content,and access controls of...

Question 18

Databases and DBMSs include several important data access and data management features,four of which are identified in the chapter.List three of the four.​

Accepted Answer

1.Simultaneous access by many users and

Question 19

If there is more than one field in a database table that is unique for all rows only one of those fields will be identified as the ______ ______ for the table.​

Accepted Answer

The answer of If there is more than one field...

Question 20

​What does SQL stand for?

Accepted Answer

structured

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

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

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.

Including a total amount field as the sum of other fields in a table is a violation of second normal form.

A(n)____ describes the structure,content,and access controls of a physical data store or database.

A relational database table is in ____________________ normal form if it has no repeating fields or groups of fields,i.e.if it has the same number of columns for every row.

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

GUID stands for __.

A field in a relational table called "address" would be an example of what?

Relationships between tables is usually indicated through the use of a foreign key.

Which is not one of the responsibilities of the DA?

A relational database management system stores data in tables.

Which of the following is not a synonym of the others?

Every table in a relational database must have a foreign key.

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?

A local business office with a small database which is only used by two or three users would most probably implement a desktop DBMS.

A(n)____________________ describes the structure,content,and access controls of a physical data store or database.

Databases and DBMSs include several important data access and data management features,four of which are identified in the chapter.List three of the four.

If there is more than one field in a database table that is unique for all rows only one of those fields will be identified as the for the table.

What does SQL stand for?

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 columns of the same table are at distinct locations that is referred to as _________.

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

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.​

Including a total amount field as the sum of other fields in a table is a violation of second normal form.​

A(n)____ describes the structure,content,and access controls of a physical data store or database.​

A relational database table is in ____________________ normal form if it has no repeating fields or groups of fields,i.e.if it has the same number of columns for every row.​

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.​

GUID stands for ______ ______ ______.​

A field in a relational table called "address" would be an example of what?​

Relationships between tables is usually indicated through the use of a foreign key.​

Which is not one of the responsibilities of the DA?​

A relational database management system stores data in tables.​

Which of the following is not a synonym of the others?​

Every table in a relational database must have a foreign key.​

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?​

A local business office with a small database which is only used by two or three users would most probably implement a desktop DBMS.​

A(n)____________________ describes the structure,content,and access controls of a physical data store or database.​

Databases and DBMSs include several important data access and data management features,four of which are identified in the chapter.List three of the four.​

If there is more than one field in a database table that is unique for all rows only one of those fields will be identified as the ______ ______ for the table.​

​What does SQL stand for?

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

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

A relational database table is in third normal form (3NF)if it is in second normal form (2NF)and if every non-key field is functionally dependent on the primary key.

Including a total amount field as the sum of other fields in a table is a violation of second normal form.

A(n)____ describes the structure,content,and access controls of a physical data store or database.

A relational database table is in ____________________ normal form if it has no repeating fields or groups of fields,i.e.if it has the same number of columns for every row.

A relational database table is in ____ normal form if no non-key field is functionally dependent on any other non-key field.

GUID stands for __.

A field in a relational table called "address" would be an example of what?

Relationships between tables is usually indicated through the use of a foreign key.

Which is not one of the responsibilities of the DA?

A relational database management system stores data in tables.

Which of the following is not a synonym of the others?

Every table in a relational database must have a foreign key.

What danger(s)is/are inherent in using keys invented by external agents as primary keys in a relational database?

A local business office with a small database which is only used by two or three users would most probably implement a desktop DBMS.

A(n)____________________ describes the structure,content,and access controls of a physical data store or database.

Databases and DBMSs include several important data access and data management features,four of which are identified in the chapter.List three of the four.

If there is more than one field in a database table that is unique for all rows only one of those fields will be identified as the for the table.

What does SQL stand for?