Question 1

To ensure that the database is designed correctly,an important member of the project team is the data administrator.​

Accepted Answer

A) True 
 B)False

Question 2

A lock on a portion of the database by one user,which does not allow other users to read or access the data is called a(n)______ ______.​

Accepted Answer

exclusive

Question 3

Another name for a read lock is a(n)______ ______.​

Accepted Answer

The answer of Another name for a read lock is...

Question 4

What does DBMS stand for?​

Accepted Answer

database m

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.​

Accepted Answer

A) columns 
B) foreign keys​ 
C) rows 
D) ​values 
A) columns 
B) foreign keys​ 
C) rows 
D) ​values

Question 7

A distributed database configuration where all databases use the same DBMS and have a global schema is called a(n)______ ______ ______.​

Accepted Answer

homogeneou

Question 8

______ ______ ______ is a query language used to access and update the data in a relational database.​

Accepted Answer

structured

Question 9

In a one-to-many association the primary key of the "many" class is placed as a foreign key in the "one" class.​

Accepted Answer

A) True 
 B)False

Question 10

Another name for a write lock is a(n)______ ______.

Accepted Answer

The answer of Another name for a write lock is...

Question 11

The technique of applying exclusive control to a part of the database to one user at a time is called a(n)______ ______.​

Accepted Answer

The answer of The technique of applying exclusive control to...

Question 12

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

Accepted Answer

A) row 
B) ​Tuple 
C) record 
D) ​field 
A) row 
B) ​Tuple 
C) record 
D) ​field

Question 13

If there is more than one field in a database table that is unique for all rows each one may be called a(n)______ _____.​

Accepted Answer

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

Question 14

____ are a critical element of relational database design because they are the bases for representing relationships among tables.​

Accepted Answer

A) Keys 
B) ​Attributes 
C) Fields 
D) ​Tables 
A) Keys 
B) ​Attributes 
C) Fields 
D) ​Tables

Question 15

In an iterative approach to software development,it is usually best to develop the database in the first few iterations.​

Accepted Answer

A) True 
 B)False

Question 16

A database table is in _____ _____ _____ if no non-key attributes are functionally dependent on any other non-key attributes.​

Accepted Answer

third norm

Question 17

The domain data in a database is sometimes referred to as metadata.​

Accepted Answer

A) True 
 B)False

Question 18

Every database in a DBMS consists of two separate data stores.​

Accepted Answer

A) True 
 B)False

Question 19

Which is NOT one of the responsibilities of the database administrator?​

Accepted Answer

A) Backup the database 
B) ​Do performance tuning 
C) Set up user authentication 
D) ​Determine data confidentiality 
A) Backup the database 
B) ​Do performance tuning 
C) Set up user authentication 
D) ​Determine data confidentiality

Question 20

​Invented keys that are not automatically generated in a relational database are dangerous and require careful scrutiny.

Accepted Answer

A) True 
 B)False

To ensure that the database is designed correctly,an important member of the project team is the data administrator.

A lock on a portion of the database by one user,which does not allow other users to read or access the data is called a(n) .

Another name for a read lock is a(n) .

What does DBMS stand for?

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

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

A distributed database configuration where all databases use the same DBMS and have a global schema is called a(n) __.

__ is a query language used to access and update the data in a relational database.

In a one-to-many association the primary key of the "many" class is placed as a foreign key in the "one" class.

Another name for a write lock is a(n) .

The technique of applying exclusive control to a part of the database to one user at a time is called a(n) .

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

If there is more than one field in a database table that is unique for all rows each one may be called a(n)__ _.

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

In an iterative approach to software development,it is usually best to develop the database in the first few iterations.

A database table is in ___ _ ___ if no non-key attributes are functionally dependent on any other non-key attributes.

The domain data in a database is sometimes referred to as metadata.

Every database in a DBMS consists of two separate data stores.

Which is NOT one of the responsibilities of the database administrator?

Invented keys that are not automatically generated in a relational database are dangerous and require careful scrutiny.

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

To ensure that the database is designed correctly,an important member of the project team is the data administrator.​

A lock on a portion of the database by one user,which does not allow other users to read or access the data is called a(n)______ ______.​

Another name for a read lock is a(n)______ ______.​

What does DBMS stand for?​

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

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.​

A distributed database configuration where all databases use the same DBMS and have a global schema is called a(n)______ ______ ______.​

______ ______ ______ is a query language used to access and update the data in a relational database.​

In a one-to-many association the primary key of the "many" class is placed as a foreign key in the "one" class.​

Another name for a write lock is a(n)______ ______.

The technique of applying exclusive control to a part of the database to one user at a time is called a(n)______ ______.​

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

If there is more than one field in a database table that is unique for all rows each one may be called a(n)______ _____.​

____ are a critical element of relational database design because they are the bases for representing relationships among tables.​

In an iterative approach to software development,it is usually best to develop the database in the first few iterations.​

A database table is in _____ _____ _____ if no non-key attributes are functionally dependent on any other non-key attributes.​

The domain data in a database is sometimes referred to as metadata.​

Every database in a DBMS consists of two separate data stores.​

Which is NOT one of the responsibilities of the database administrator?​

​Invented keys that are not automatically generated in a relational database are dangerous and require careful scrutiny.

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

To ensure that the database is designed correctly,an important member of the project team is the data administrator.

A lock on a portion of the database by one user,which does not allow other users to read or access the data is called a(n) .

Another name for a read lock is a(n) .

What does DBMS stand for?

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

All ____ in a table are guaranteed to be unique if the table's primary key is guaranteed to be unique.

A distributed database configuration where all databases use the same DBMS and have a global schema is called a(n) __.

__ is a query language used to access and update the data in a relational database.

In a one-to-many association the primary key of the "many" class is placed as a foreign key in the "one" class.

Another name for a write lock is a(n) .

The technique of applying exclusive control to a part of the database to one user at a time is called a(n) .

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

If there is more than one field in a database table that is unique for all rows each one may be called a(n)__ _.

____ are a critical element of relational database design because they are the bases for representing relationships among tables.

In an iterative approach to software development,it is usually best to develop the database in the first few iterations.

A database table is in ___ _ ___ if no non-key attributes are functionally dependent on any other non-key attributes.

The domain data in a database is sometimes referred to as metadata.

Every database in a DBMS consists of two separate data stores.

Which is NOT one of the responsibilities of the database administrator?

Invented keys that are not automatically generated in a relational database are dangerous and require careful scrutiny.