 Question 1 1 out of 1 points Suppose you wish to learn what tables are included in a database, what entity characteristics these tables contain, and how these tables are related. Which resource would provide this information? Selected Answer: c. schema Answers: a. SQL commands b. attributes c. schema d. sample data Response c Feedback: Because the DBMS is responsible for providing access to a database, one of the first steps in installing and using a large relational database involves “telling” the DBMS the logical and physical structure of the data and the relationships among the data for each user. This description is called a schema (as in a schematic diagram). In a relational database, the schema defines the tables, the attributes in each table, and the relationships between attributes and tables.  Question 2 1 out of 1 points _____ is a special-purpose programming language for accessing and manipulating data stored in a relational database. Selected Answer: c. Structured Query Language (SQL) Answers: a. Query by Example (QBE) b. Access c. Structured Query Language (SQL) d. Java Response Feedback: c SQL is a special-purpose programming language for accessing and manipulating data stored in a relational database.  Question 3 1 out of 1 points What process detects and then corrects or deletes “bad data”? Selected Answer: c. data cleansing Answers: a. data recovery b. data enhancement c. data cleansing d. data validation Response c Feedback: Data cleansing is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, or irrelevant records that reside in a database. Data cleansing is different from data validation, which involves the identification of “bad data” and its rejection at the time of data entry.  Question 4 1 out of 1 points To ensure reliability and integrity, SQL databases conform to four specific properties. Which of the following is NOT one of those four properties? Selected Answer: d. currency Answers: a. atomicity b. durability c. isolation d. currency Response d Feedback: SQL databases conform to ACID properties (atomicity, consistency, isolation, durability), which were defined by Jim Gray soon after Codd’s work was published. These properties guarantee database transactions are processed reliably and ensure the integrity of data in the database.  Question 5 1 out of 1 points What core component of an integrated set of functions defining data processing defines the roles, responsibilities, and processes for ensuring that data can be trusted and used by the entire organization? Selected Answer: d. data governance Answers: a. data dictionary b. relational database model c. data management d. data governance Response d Feedback: Data governance is the core component of data management; it defines the roles, responsibilities, and processes for ensuring that data can be trusted and used by the entire organization, with people identified and in place who are responsible for fixing and preventing issues with data.

Enterprise Applications - Quiz Number 5 Week 5

Related Documents

Details

Description

Related Documents

Struggling with your assignment and deadlines?

Free up your schedule!

Take 5 seconds to unlock