A) A fourth generation language found in most DBMSs B) A storage tool that holds the data and definitions for a database C) An administrative tool that allows you to set access rights for database users D) A programming language that can be used instead of a DBMS A) A fourth generation language found in most DBMSs B) A storage tool that holds the data and definitions for a database C) An administrative tool that allows you to set access rights for database users D) A programming language that can be used instead of a DBMS

Exam 3: Databases and Data Warehouses: Building Business

Assume you have an order entry database with an Order file and a Customer file.The Order Date field most likely would be the common field used to relate the two files.

(True/False)

4.8/5

(28)

Question 41

Views are located within the _____ subsystem of the DBMS.

(Short Answer)

4.8/5

(39)

Question 42

Every primary key can also be a _____ key.

(Multiple Choice)

4.9/5

(33)

Question 43

What is SQL?

(Multiple Choice)

4.8/5

(41)

Question 44

If your phone number was used in a clothing store to uniquely identify you as a customer,the phone number would be considered a(n)_____.

(Multiple Choice)

4.9/5

(35)

Question 45

What is the term used to describe the sharing of information regardless of title or department.

(Multiple Choice)

4.9/5

(29)

Question 46

XYZ,Corp.would like to determine advertising strategies for customers who buy high-priced products.It would use OLTP on its data warehouse.

(True/False)

4.9/5

(37)

Question 47

Which database management subsystem helps you create and maintain the data dictionary and define the structure of the files in a database?

(Multiple Choice)

4.7/5

(45)

Question 48

To determine the impact of an advertising blitz based on a specific product line for the northern region in the 4th quarter,a _____ would be used.

(Short Answer)

4.8/5

(29)

Question 49

A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

(True/False)

4.9/5

(38)

Question 50

A(n)_____ is a multidimensional representation of information.

(Short Answer)

4.9/5

(34)

Question 51

Backup and recovery facilities are included in the data administration subsystem.

(True/False)

4.9/5

(29)

Question 52

If you were looking at information in a database and you able to see only the information you needed in the format you wanted,what type of database view would you see?

(Multiple Choice)

4.7/5

(37)

Question 53

A data dictionary is a two-dimensional table used to store data within a relational database.

(True/False)

4.7/5

(42)

Question 54

If you need to add a new field to a database,you would use the data manipulation system.

(True/False)

4.8/5

(36)

Question 55

A(n)_____ allows you to specify the logical organization for a database and access and use the information within a database.

(Short Answer)

5.0/5

(31)

Question 56

Data-mining tools include all but which of the following?

(Multiple Choice)

4.8/5

(46)

Question 57

Which system allows your organization to gather,process,and update transactional information?

(Multiple Choice)

4.9/5

(36)

Question 58

_____ maintain statistics regarding how the DBMS engine physically accesses information.

(Short Answer)

4.9/5

(35)

Question 59

Which type of constraint ensures the quality of information in a relational database?

(Multiple Choice)

4.9/5

(31)

Question 60

Showing 41 - 60 of 158

Assume you have an order entry database with an Order file and a Customer file.The Order Date field most likely would be the common field used to relate the two files.

Views are located within the _____ subsystem of the DBMS.

Every primary key can also be a _____ key.

What is SQL?

If your phone number was used in a clothing store to uniquely identify you as a customer,the phone number would be considered a(n)_____.

What is the term used to describe the sharing of information regardless of title or department.

XYZ,Corp.would like to determine advertising strategies for customers who buy high-priced products.It would use OLTP on its data warehouse.

Which database management subsystem helps you create and maintain the data dictionary and define the structure of the files in a database?

To determine the impact of an advertising blitz based on a specific product line for the northern region in the 4th quarter,a _____ would be used.

A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

A(n)_____ is a multidimensional representation of information.

Backup and recovery facilities are included in the data administration subsystem.

If you were looking at information in a database and you able to see only the information you needed in the format you wanted,what type of database view would you see?

A data dictionary is a two-dimensional table used to store data within a relational database.

If you need to add a new field to a database,you would use the data manipulation system.

A(n)_____ allows you to specify the logical organization for a database and access and use the information within a database.

Data-mining tools include all but which of the following?

Which system allows your organization to gather,process,and update transactional information?

_____ maintain statistics regarding how the DBMS engine physically accesses information.

Which type of constraint ensures the quality of information in a relational database?

The Information Age in Which You Live: Changing

Major Business Initiatives: Gaining Competitive

Decision Support and Artificial Intelligence

Electronic Commerce: Strategies for the New Economy

Systems Development: Phases, Tools, and Techniques

Enterprise Infrastructure, Metrics, and Business

Protecting People and Information

Emerging Trends and Technology

Computer Hardware and Software

Network Basics

Careers in Business

Filters