Deck 4: Databases and DataWarehouses

Question 1

An organization's data warehouse contains information drawn from multiple sources that can be used for analysis, intelligence gathering, and strategic planning.

Answer 1

True

Question 2

When a user clicks "SUBMIT" on a web-based survey, the record is inserted into the database through an SQL command.

Answer 2

True

Question 3

A blog with a title, subtitle, content with date of creation, and a few images exemplifies semi-structured information.

Answer 3

True

Question 4

Shadow systems are managed by individuals or departments and not by the central IT staff in an organization.

Question 5

In an organization, each employee might work for one or more projects, as well as for different managers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Question 6

One of the disadvantages of interactive voice response (IVR) is that it cannot handle massive call volumes.

Question 7

Master data management has more to do with technology than people, processes, and governance.

Question 8

During mergers, integration of multiple databases becomes a major challenge.

Question 9

Companies often use different relational DBMS for their data warehouse and operational database.

Question 10

Data stewards ensure that people adhere to the definitions for the master data in their organizational units.

Question 11

The process of sequentially executing operations on each record in a large batch is called data integration.

Question 12

Database developers should use meaningful information for primary keys.

Question 13

The data collected by online pop-up surveys can be considered to be high-quality data.

Question 14

A marketing representative who wants to put a positive spin on a tally of recent orders chooses to include orders that have been canceled in his report. This report exemplifies high-quality data.

Question 15

A relational database is less dependent on the hardware and its particular operating system.

Question 16

A network database supports many-to-many relationships.

Question 17

Building interfaces, or bridges, between different databases to link common fields is an integration strategy.

Question 18

In a table, a field can contain either numeric data or text but not a combination of both.

Question 19

Shards or slices of a database should be accessed from the same computer for improved performance.

Question 20

While creating a relational database for an organization, "Employees" would constitute one attribute with employee ID number, last name, first name, birth date, email address, and phone number as entities.

Question 21

Changes to an integrated database take less time from IT but more from the end users.

Question 22

Which of the following is a characteristic of structured information?

A) It cannot be linked together to enable searching and sorting.
B) It can be broken down into component parts and organized in hierarchies.
C) It is contained in physical data storage such as printouts.
D) It only includes homogenous data types in one set of information.

Question 23

A separate file processing system leads to the creation of redundant information because ________.

A) it does not allow changes to be made to existing file structures
B) computer programs create a fresh record for each task
C) each set of computer programs operates on its own records
D) different sets of computer programs process files in a similar manner

Question 24

What is the main drawback of using unstructured information?

A) It hinders creativity.
B) It is expensive to maintain.
C) It cannot be used to store numerical information.
D) It makes retrieving information very difficult.

Question 25

An integrated collection of information that is logically related and stored in such a way as to minimize duplication and facilitate rapid retrieval is called a ________.

A) dataset
B) data dictionary
C) data definition
D) database

Question 26

Batch processing is defined as ________.

A) the sequential execution of operations on each record in a large set
B) the arrangement of data in a table as records and fields
C) the removal of duplicates from a set of data
D) the strategy of defining and linking records

Question 27

Structured information can be defined as data ________.

A) that can be organized into hierarchies
B) that cannot be linked together
C) about data that clarifies the nature of the information
D) that is difficult to break down

Question 28

A representation of an entity in a meaningful way, which includes the attributes of the entity, is called a ________.

A) field
B) primary key
C) data definition
D) record

Question 29

Databases are created and handled using ________.

A) database management software
B) database architecture software
C) data modeling software
D) data definition software

Question 30

White and Brown, a legal firm, stores details of each case in physical files and folders. The firm has a back room stacked with boxes containing hundreds of files. White and Brown's storage structure resembles ________.

A) semi-structured information
B) unstructured information
C) meta data
D) relational data

Question 31

How is metadata related to information?

A) It helps clarify the nature of the information.
B) It helps gather unstructured information.
C) It organizes unstructured information to form structured information.
D) It removes redundant data from unstructured information.

Question 32

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report?

A) metadata
B) count data
C) boolean data
D) binary data

Question 33

An attribute of an entity in a table is called a ________.

A) record
B) subset
C) field
D) character

Question 34

Pieces of information that cannot be linked together are called ________.

A) unstructured information
B) semi-structured information
C) structured information
D) secure information

Question 35

The early file processing systems were very difficult to maintain because of ________.

A) complicated tables and fields with no metadata
B) data dependency between the programs and files
C) frequent software upgrades
D) lack of database administrators and IT personnel

Question 36

Flippy, an online shoe store, uses an information system to store sales transactions with clearly defined fields for date, customer number, item number, invoice number, and amount. What type of information resource does Flippy use?

A) unstructured information
B) semi-structured information
C) structured information
D) shard information

Question 37

________ specifies the characteristics of a field, such as the type of data it will hold.

A) Data definition
B) A record
C) Database architecture
D) An entity

Question 38

In comparison with unstructured information, semi-structured information ________.

A) is more difficult to break down
B) has no inherent order
C) is easier to query and aggregate
D) is more difficult to link together

Question 39

To balance the information needs of multiple stakeholders, top-level managers need clear, consistent, and accurate reports that summarize information from across the enterprise.

Question 40

In Robin Dave Hospital, visiting physicians use different spreadsheets to record the name, address, mobile number, and email of clients. These individual spreadsheets are then compiled by a data-entry operator into one spreadsheet. What type of information does the compiled spreadsheet represent?

A) unstructured information
B) semi-structured information
C) structured information
D) secure information

Question 41

Aban Constructions Limited, a construction company, maintains data in the form of records within tables, and the tables are interconnected by linking matching fields. Which type of database architecture does Aban Constructions Limited use?

A) hierarchical database
B) network database
C) relational database
D) object-oriented database

Question 42

Which of the following is the most widely used database architecture?

A) stratified database
B) object-oriented database
C) network database
D) relational database

Question 43

Which database architecture is especially used for managing web content and web-based resources?

A) relational database
B) hierarchical database
C) object-oriented database
D) XML database

Question 44

________ is a process that refines entities and their relationships to help minimize duplication of information in tables.

A) Normalization
B) Autonumbering
C) Querying
D) Data modeling

Question 45

What is the drawback of using Social Security Numbers (SSN) as the primary key for tables of employees, hospital patients, students, or cable TV customers?

A) Typing the nine digit SSN numbers is laborious and time consuming.
B) Non-U.S. citizens may not have an SSN.
C) It is not a confidential identification number.
D) It is not a unique identification number.

Question 46

A drawback of the hierarchical database was that ________.

A) it was ineffective at handling many-to-many relationships
B) it did not mimic every detail of an organizational chart
C) it worked only for one-to-one relationships
D) it failed to reduce redundancies introduced by file systems

Question 47

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

A) network database
B) hierarchical database
C) object-oriented database
D) cluster database

Question 48

Which of the following is an early database approach that allowed flexible links to support many-to-many relationships?

A) hierarchical database
B) stratified database
C) lean database
D) network database

Question 49

Which database architecture is popularly used for organizing complex data types such as graphics and multimedia?

A) stratified database
B) object-oriented database
C) network database
D) relational database

Question 50

Which process assigns incremental numbers to records as they are created to ensure that each record has a unique primary key?

A) normalization
B) scaling
C) standardization
D) autonumbering

Question 51

The database model that organizes information into tables of records that are connected to one another by linking a field in one table to a field in another table is called ________.

A) hierarchical database
B) relational database
C) network database
D) object-oriented database

Question 52

A model used for planning the organization's database that identifies what kind of information is needed, what entities will be created, and how they are related to one another is called a(n) ________.

A) archiving model
B) functional model
C) data model
D) hierarchical model

Question 53

Which of the following databases resembles an organizational chart?

A) network database
B) hierarchical database
C) stratified database
D) cluster database

Question 54

Which of the following is a function of normalization?

A) assigning primary keys
B) assigning incremental numbers to records
C) minimizing duplication of information
D) decreasing the functional dependency of data

Question 55

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

A) one-to-many relationship
B) many-to-one relationship
C) many-to-many relationship
D) one-to-one relationship

Question 56

Which type of database architecture does Oracle use?

A) network database
B) relational database
C) hierarchical database
D) object-oriented database

Question 57

Roman Jade, an interior decorations company, stores employee details in its employee information system. The birth date of each employee is stored along with other details, including employee names. The relationship between the employee names and employee birth dates is a ________.

A) one-to-many relationship
B) many-to-one relationship
C) many-to-many relationship
D) one-to-one relationship

Question 58

In a relational database, information is organized into tables in which each row represents a(n) ________.

A) record
B) field
C) attribute
D) primary key

Question 59

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

A) autonumbering
B) accuracy checks
C) normalization
D) referential integrity

Question 60

A field or a group of fields that make a record unique in a table is called a(n) ________.

A) primary key
B) autonumber
C) central entity
D) attribute record

Question 61

Shadow systems focus on ________.

A) specific information requirements of an individual or department
B) improving the scalability of relational databases
C) intelligence gathering and strategic planning
D) reducing redundancies in relational data

Question 62

Which product allows voice commands, sequenced like a natural conversation, as a means to access a database?

A) Yelp
B) MySQL
C) Oracle
D) Siri

Question 63

A foreign key is ________.

A) an attribute that is present in only one table
B) a primary key which appears as an attribute in a different table
C) a unique value or attribute that determines a primary key
D) a field, or a group of fields, that makes each record unique in a table

Question 64

Structured query language is a standard query language ________.

A) used to manipulate information in relational databases
B) that uses the signals transmitted via the phone to access databases
C) that offers voice commands as a means to access a database
D) used to enhance security, plan capacity requirements, and design backup

Question 65

One goal of normalization is to ________.

A) duplicate essential information
B) assign primary keys to every table
C) reduce the number of foreign keys
D) make data functionally dependent

Question 66

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

A) foreign key
B) primary key
C) complex key
D) functional key

Question 67

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

A) database schema
B) data dictionary
C) data model
D) data definition

Question 68

SQL links tables together by ________.

A) using primary keys and foreign keys
B) using data stored in cloud computers
C) assigning incremental numbers to records
D) assigning XML tags to the tables

Question 69

Databases that are smaller than enterprise databases and focus on their creators' specific information requirements are known as ________.

A) shadow systems
B) data warehouses
C) data stewards
D) referential schemas

Question 70

Which of the following is the best way to handle complex relationships, such as the data for a company where employees can be assigned to more than one project, and each project can have more than one employee assigned to it?

A) creating two or more records for the employee, each of which lists a different project
B) including multiple project fields, such as project 1, project 2, and so on, for the employee
C) normalizing the relationship between "employees" records and "projects" records
D) making the relationship between "employees" records and "projects" records hierarchically dependent

Question 71

Which of the following ensures that there will be minimum redundancy in a relational database?

A) foreign keys
B) autonumbers
C) functionally independent attributes
D) one to one relationships

Question 72

The database performance tuning process takes into account ________.

A) the system's capacity of scaling
B) the kind of data accessed by the end users
C) the language used by users to access the database
D) the security permissions accorded to different users

Question 73

The process by which users are directed to a copy of the database when the main one fails is called ________.

A) mirroring
B) threading
C) tuning
D) scaling

Question 74

Which of the following is a disadvantage of using shadow systems?

A) longer time to retrieve information
B) lack of stability and security
C) requirement of tools that are not easily available
D) lack of documentation and support

Question 75

________ ensures that every foreign key entry actually exists as a primary key entry in its main table.

A) Scalability
B) Database schema
C) Referential integrity
D) Database integration

Question 76

To collate innovative ideas for an important business project, a manager creates a database which is not integrated into the enterprise database. The new database is an example of a(n) ________.

A) mirror database
B) shadow system
C) information system
D) data warehouse

Question 77

A system's ability to handle rapidly increasing demand is called ________.

A) load balancing
B) parallelism
C) scalability
D) caching

Question 78

A data model that graphically shows the tables, attributes, keys, and logical relationships for a database is called a ________.

A) data graph
B) shadow schema
C) database schema
D) referential schema

Question 79

A database schema is used to ________.

A) graphically document a data model
B) record details of the fields in a table
C) create a backup of a database
D) identify redundant information in a database

Question 80

________ takes advantage of signals transmitted via the phone to access a database, retrieve account information, and enter data.

A) Structured query language
B) Interactive voice response
C) Electronic reported outcome
D) Dialog system