Info 360 Quiz 6 – Flashcards

What is the first step you should take in managing data for a firm? A) Cleanse the data before importing it to any database B) Identify the data needed to run the business C) Normalize the data before importing to a database D) Audit your data quality

The type of logical database model that treats data as if they were stored in two-dimensional tables is the: A) relational DBMS. B) hierarchical DBMS. C) pre-digital DBMS. D) two-tiered DBMS

A characteristic or quality describing an entity is called a(n): A) tuple. B) key field. C) field. D) attribute.

A field identified in a table as holding the unique identifier of the table's records is called the: A) key field. B) foreign key. C) primary field. D) primary key.

A DBMS makes the: A) physical database available for different relational views. B) logical database available for different analytical views. C) relational database available for different physical views. D) physical database available for different logical views.

The logical view of a database: A) shows how data are organized and structured on the storage media. B) allows the creation of supplementary reports. C) presents data as they would be perceived by end users. D) presents an entry screen to the user.

An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the: A) data definition diagram. B) data dictionary. C) entity-relationship diagram. D) relationship dictionary.

You are working in the IT department of a small paper supply company and planning a new database that monitors employee benefits and productivity. What would be the relationship you need to establish between Employee_ID in the Employee table and Parking_spot_number in the Perks table? A) one-to-many B) many-to-many C) one-to-one D) many-to-one

Within a corporate information services department, the task of creating the physical database and its logical relations are responsibilities of the ________ function. A) data administration B) server administration C) database administration D) data modeling

Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called: A) data scrubbing. B) data optimization. C) defragmentation. D) data auditing.