Filters
Question type
Study Flashcards

________ is a DBMS that provides a full set of object-relational features.


A) Oracle Database
B) Microsoft Access
C) Microsoft SQL Server 2014
D) MySQL

E) None of the above
F) B) and C)

Correct Answer

verifed

verified

Operational databases contain a fact table.

A) True
B) False

Correct Answer

verifed

verified

To format a PivotTable in Microsoft Excel 2013,we use the ________.


A) Design command tab in the PivotTable Tools contextual command tab
B) Format command tab in the PivotTable Tools contextual command tab
C) Design command tab in the Report Tools contextual command tab
D) Format command tab in the Report Tools contextual command tab

E) All of the above
F) B) and D)

Correct Answer

verifed

verified

When distributed databases break the database into sections and store the sections on different servers,this is known as ________.


A) replication
B) partitioning
C) disbursing
D) distributed two-phase locking

E) A) and C)
F) B) and C)

Correct Answer

verifed

verified

In the MapReduce process,the first step is the ________ step.


A) column
B) reduce
C) column family
D) map

E) B) and C)
F) B) and D)

Correct Answer

verifed

verified

A data mart differs from a data warehouse in that ________.


A) it has a larger database
B) it deals with a particular component or functional area of the business
C) data mart users must have more data management expertise than data warehouse employees
D) it is updated more frequently by the data mart users

E) A) and C)
F) None of the above

Correct Answer

verifed

verified

What is a Microsoft Excel PivotTable?

Correct Answer

verifed

verified

A PivotTable is the reporting mechanism ...

View Answer

Why is operational data sometimes unusable for Business Intelligence (BI)use? Include at least two examples.

Correct Answer

verifed

verified

Data in operational databases can suffer...

View Answer

Showing 101 - 108 of 108

Related Exams

Exam 1

Introduction

100 Questions

Exam 2

Introduction to Structured Query Language

114 Questions

Exam 3

The Relational Model and Normalization

100 Questions

Exam 4

Database Design Using Normalization

100 Questions

Exam 5

Data Modeling With the Entity-Relationship Model

104 Questions

Exam 6

Transforming Data Models Into Database Designs

103 Questions

Exam 7

SQL for Database Construction and Application Processing

104 Questions

Exam 8

Database Redesign

103 Questions

Exam 9

Managing Multiuser Databases

102 Questions

Exam 10

Managing Databases With SQL Server 2014

101 Questions

Exam 11

Managing Databases With Oracle Database

106 Questions

Exam 12

Managing Databases With Mysql 5.6

101 Questions

Exam 13

The Web Server Environment

128 Questions

Exam 15

Getting Started With Microsoft Access 2013

53 Questions

Exam 16

Getting Started With Systems Analysis and Design

37 Questions

Exam 17

E-R Diagrams and the IDEF1X Standard

37 Questions

Exam 18

E-R Diagrams and the UML Standard

36 Questions

Exam 19

Getting Started With Mysql Workbench Data Modeling Tools

37 Questions

Exam 20

Getting Started With Microsoft Visio 2013

32 Questions

Exam 21

Data Structures for Database Processing

39 Questions

Exam 22

the Semantic Object Model

35 Questions

Exam 23

Getting Started With Web Servers, PHP, and the Netbeans IDE

35 Questions

Exam 24

Business Intelligence Systems

82 Questions

Exam 25

Big Data

81 Questions

Show Answer