BCIS 4620 Final

Which comparison operator indicates a value is not equal?

<>

The _____ function returns the current system date in MS Access.

DATE()

The PL/SQL block starts with the _____ section.

DECLARE

The Oracle _____ function compares an attribute or expression with a series of values and returns an associated value or a default value if no match is found.

DECODE

Which query is used to list a unique value for V_CODE, where the list will produce only a list of those values that are different from one another?

Distinct

Which statement describes a feature of Oracle sequences?

Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.

A data store is used by data analysts to create queries that access the database.

False

Every PL/SQL block must be given a name.

False

Master data management's main goal is to provide a partial and segmented definition of all data within an organization.

False

Most SQL implementations yield case-insensitive searches.

False

Normalizing fact tables improves data access performance and saves data storage space.

False

Queries against operational data typically are broad in scope and high in complexity.

False

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.

False

Stored procedures must have at least one argument.

False

The ability to graphically present data in a way that makes it understandable is the concept of value.

False

Triggers can only be used to update table values.

False

​Scaling out is keeping the same number of systems, but migrating each system to a larger one.

False

​​A block report is used to let the name node know that the data mode is still available.

False

______ was the first SQL on Hadoop application.

Impala

If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use a(n) _____ clause.

Join On

Which of the following is a personal analytics vendor for BI applications?

MicroStrategy

In Oracle, _____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping.

Procedural Language SQL

_____ extends SQL so that it can differentiate between access requirements for data warehouse data and operational data.

ROLAP

______ is a tool for converting data back and forth between a relational database and the HDFS.

Sqoop

Document databases group documents into logical groups called ______.

collections

In business intelligence framework, data are captured from a production system and placed in _____ on a near real-time basis.

data warehouse

The _____ schema must support complex (non-normalized) data representations.

decision support database

To query the value component of the pair when using a key-value database, use get or ______.

fetch

Modeling and storing data about relationships is the focus of ______ databases.

graph

Neo4j is a ______ database.

graph

When using a(n) _____ join, only rows from the tables that match on a common value are returned.

inner

Oracle recommends _____ for creating audit logs.

triggers

When using MapReduce, best practices suggest that the number of mappers on a given node should be ______.

100 or less

How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B contains 18?

144

By default, Hadoop uses a replication factor of ______.

3

When using a HDFS, a heartbeat is sent every ______ to notify the name node that the data mode is still available.

3 seconds

All changes in a table structure are made using the _____ TABLE command, followed by a keyword that produces the specific changes a user wants to make.

ALTER

The special operator used to check whether an attribute value is within a range of values is _____.

Between

The _____ constraint is used to validate data when an attribute value is entered.

CHECK

Using the _____ command, SQL indexes can be created on the basis of any selected attribute.

CREATE INDEX

Which of the following is NOT one of the standard NoSQL categories?

Chart

Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) _____.

Data Warehouse

The special operator used to check whether a subquery returns any rows is _____.

EXISTS

A data warehouse designer must define common business dimensions that will be used by a data analyst to expand a search.

False

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

False

An explicit cursor must return two or more rows.

False

By default, the fact table's primary key is always formed by combining the superkeys pointing to the dimension tables to which they are related.

False

Comparison operators cannot be used to place restrictions on character-based attributes.

False

​​​Flume is a tool for converting data back and forth between a relational database and the HDFS.

False

Fact and dimension tables are related by _____ keys.

Foreign

In star schema representation, a fact table is related to each dimension table in a _____ relationship.

M:1

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name.

MON

A _____ is a block of code containing standard SQL statements and procedural extensions that is stored and executed at the DBMS server.

PSM

The syntax for a left outer join is _____.

SELECT column-list FROM table1 LEFT [OUTER] JOIN table2 ON join-condition

Which SQL format would be best used for a small, numeric data type?

SMALLINT

Which is a feature of a correlated subquery?

The outer subquery initiates the process of execution in a subquery.

A column family database is a NoSQL database model that organizes data in key-value pairs with keys mapped to a set of columns in the value component

True

A star schema is designed to optimize data query operations rather than data update operations.

True

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords.

True

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause.

True

Big Data processing imposes a structure on the data as needed for applications as a part of retrieval and processing.

True

Date procedures are often more software-specific than other SQL procedures.

True

Decision support data is a snapshot of the operational data at a given point in time.

True

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks

True

Just like database triggers, stored procedures are stored in the database

True

Key-value and document databases are structurally similar.

True

Some RDBMSs, such as Microsoft Access, automatically make the necessary conversions to eliminate case sensitivity.

True

The ANSI SQL standards are also accepted by the ISO.

True

The CUBE extension enables you to get a subtotal for each column listed in the expression, in addition to a grand total for the last column listed.

True

The analysis of data to produce actionable results is feedback loop processing.

True

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules.

True

Data collected or aggregated around a central topic or entity is said to be ______ aware.

aggregate

The attribute hierarchy provides a top-down data organization that is used for two main purposes: _____ and drill-down/roll-up data analysis

aggregation

The tables on which a view, or a virtual table derived from a SELECT query, are based are called _____ tables.

base

______ processing occurs when a program runs from beginning to end without any user interaction.

batch

From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and _____.

dimensionality

The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.

dimensions

Decision support data tends to be non-normalized, _____, and pre-aggregated.

duplicated

_____ is a relational set operator.

except

In a star schema, attributes are often used to search, filter, or classify _____.

facts

A persistent stored module is stored and executed on the database client machine.

false

Hive is a good choice for jobs that require a small subset of data to be returned very quickly.​

false

Oracle users can use the Access QBE (query by example) query generator.

false

The ROLLUP extension is used with the GROUP BY clause to generate aggregates by the listed columns, including the last one.

false

A(n) ______ is a tag that is used to associate a collection of nodes as being of the same type or belonging to the same group.

label

​When using MapReduce, a _______ function takes a collection and data and sorts and filters it into a set of key-value pairs.

map

A ______ is a programmed function within an object used to manipulate the data in that same object.

method

Computed or derived facts, at run time, are sometimes called _____ to differentiate them from stored facts.

metrics

Graph theory is a mathematical and computer science field that models relationships, or edges, between objects called ______.

nodes

The reliance on _____ as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems.

normalization

What type of command does this SQL statement use? SELECT P_CODE, P_DESCRIPT, P_PRICE_V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE=VENDOR. V_CODE

old style join

In subquery terminology, the first query in the SQL statement is known as the _____ query.

outer query

Two of the most popular applications to simplify the process of creating MapReduce jobs are Hive and ______.

pig

The SQL data manipulation command HAVING:

restricts the selection of grouped rows based on a condition.

______ is keeping the same number of systems, but migrating each system to a larger system.

scaling up

The Oracle equivalent to an MS Access AutoNumber is a(n) _____.

sequence

A _____ schema is a type of star schema in which dimension tables can have their own dimension tables.

snowflake

Operational data are commonly stored in many tables, and the stored data represents information about a given _____ only.

transaction

Numeric functions take one numeric parameter and return one value.

true

The Oracle string concatenation function is _____.

||