INF503 All Quizzes

Week 1 Quiz

Week 2 Quiz

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

A derived attribute is indicated in the Chen notation by a _____ that connects the attribute and an entity.

Select one:

single line

double line

double dashed line

dashed line

Correct

Feedback

The correct answer is: dashed line

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ attribute is one that cannot be subdivided.

Select one:

multivalued

composite

single-valued

simple

Correct

Feedback

The correct answer is: simple

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

_____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.

Select one:

Database

Relational

Index

Predicate

Correct

Feedback

The correct answer is: Predicate

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

_____ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.

Select one:

1:1

1:N

M:1

M:N

Correct

Feedback

The correct answer is: M:N

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ relationship exists when three entities are associated.

Select one:

unary

strong

ternary

Correct

weak

Feedback

The correct answer is: ternary

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is the set of possible values for a given attribute.

Select one:

key

range

identifier

domain

Correct

Feedback

The correct answer is: domain

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ relationship exists when an association is maintained within a single entity.

Select one:

weak

ternary

unary

Correct

strong

Feedback

The correct answer is: unary

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

A relationship is an association between _____.

Select one:

fields

databases

objects

entities

Correct

Feedback

The correct answer is: entities

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

_____ expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.

Select one:

Connectivity

Relationship

Dependence

Cardinality

Correct

Feedback

The correct answer is: Cardinality

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ attribute can be further subdivided to yield additional attributes.

Select one:

multivalued

composite

Correct

single-valued

simple

Feedback

The correct answer is: composite

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ contains at least all of the attribute names and characteristics for each table in the system.

Select one:

database

data dictionary

Correct

logical schema

relational schema

Feedback

The correct answer is: data dictionary

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is any key that uniquely identifies each row.

Select one:

foreign key

candidate key

superkey

Correct

special key

Feedback

The correct answer is: superkey

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

Select one:

business

data

relationship

existence

Correct

Feedback

The correct answer is: existence

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

_____ are especially useful when you are trying to determine what values in related tables cause referential integrity problems.

Select one:

Outer joins

Correct

Inner joins

Theta joins

Equijoins

Feedback

The correct answer is: Outer joins

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Select one:

strong

business

weak

Correct

child

Feedback

The correct answer is: weak

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ key is defined as a key that is used strictly for data retrieval purposes.

Select one:

foreign

candidate

lookup

secondary

Correct

Feedback

The correct answer is: secondary

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

_____, also known as RESTRICT, yields values for all rows found in a table that satisfy a given condition.

Select one:

INTERSECT

UNION

SELECT

Correct

DIFFERENCE

Feedback

The correct answer is: SELECT

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ key can be described as a minimal superkey, a superkey without any unnecessary attributes.

Select one:

candidate

Correct

foreign

secondary

primary

Feedback

The correct answer is: candidate

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

_____ returns only the attributes requested, in the order in which they are requested.

Select one:

PROJECT

Correct

UNION

DIFFERENCE

SELECT

Feedback

The correct answer is: PROJECT

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is the primary key of one table that has been placed into another table to create a common attribute.

Select one:

candidate key

foreign key

Correct

composite primary key

superkey

Feedback

The correct answer is: foreign key

Week 3 Quiz

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

Select one:

repeating group

partial dependency

atomic attribute

transitive dependency

Correct

Feedback

The correct answer is: transitive dependency

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

A partial completeness constraint is represented by _____.

Select one:

a dotted line

a single horizontal line under a circle

Correct

two dashed lines

a double horizontal line over a circle

Feedback

The correct answer is: a single horizontal line under a circle

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.

Select one:

Normalization

Generalization

Correct

Total completeness

Specialization

Feedback

The correct answer is: Generalization

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____.

Select one:

2NF

3NF

1NF

Correct

4NF

Feedback

The correct answer is: 1NF

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

A relational table must not contain a(n) _____.

Select one:

entity

attribute

relationship

repeating group

Correct

Feedback

The correct answer is: repeating group

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

An entity cluster is formed by combining multiple interrelated entities into _____.

Select one:

multiple abstract entity objects

a single entity object

a single abstract entity object

Correct

multiple entity objects

Feedback

The correct answer is: a single abstract entity object

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

A table where all attributes are dependent on the primary key but are independent of each other, and no row contains two or more multivalued facts about an entity is said to be in _____.

Select one:

1NF

2NF

4NF

Correct

3NF

Feedback

The correct answer is: 4NF

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is a primary key created by a database designer to simplify the identification of entity instances.

Select one:

compound key

composite key

surrogate key

Correct

natural key

Feedback

The correct answer is: surrogate key

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

According to the "preferably single-attribute" characteristic of a primary key, the primary key:

Select one:

must be able to guarantee unique attribute values.

should have the minimum number of attributes possible.

Correct

must be composed of attributes that are free from security risks or violations.

should have embedded semantic meaning associated with each attribute.

Feedback

The correct answer is: should have the minimum number of attributes possible.

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

A(n)_____ is a generic entity type that is related to one or more entity subtypes.

Select one:

entity supertype

Correct

inheritance

subtype discriminator

specialization hierarchy

Feedback

The correct answer is: entity supertype

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ key is a real-world, generally accepted identifier used to uniquely identify real-world objects.

Select one:

primary

foreign

surrogate

natural

Correct

Feedback

The correct answer is: natural

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

A table that is in 2NF and contains no transitive dependencies is said to be in _____.

Select one:

4NF

2NF

3NF

Correct

1NF

Feedback

The correct answer is: 3NF

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

A total completeness constraint is represented by a _____.

Select one:

rhombus inside a circle

single horizontal line above a circle

smaller circle inside a bigger circle

double horizontal line under a circle

Correct

Feedback

The correct answer is: double horizontal line under a circle

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

A specialization hierarchy can have _____ level(s) of supertype/subtype relationships.

Select one:

many

Correct

zero

only one

one or many

Feedback

The correct answer is: many

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

_____ databases reflect the ever-growing demand for greater scope and depth in the data on which decision support systems increasingly rely.

Select one:

Temporary

Data warehouse

Correct

Report

Normalized

Feedback

The correct answer is: Data warehouse

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is the attribute in the supertype entity that determines to which entity subtype each supertype occurrence is related.

Select one:

specialization hierarchy

subtype discriminator

Correct

entity supertype

inheritance discriminator

Feedback

The correct answer is: subtype discriminator

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

An attribute that is part of a key is known as a(n) _____ attribute.

Select one:

nonprime

entity

important

prime

Correct

Feedback

The correct answer is: prime

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

An atomic attribute _____.

Select one:

is always chosen to be a foreign key

cannot be further subdivided

Correct

displays multiplicity

cannot exist in a relational table

Feedback

The correct answer is: cannot be further subdivided

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ derives its name from the fact that a collection of multiple entries of the same type can exist for any single key attribute occurrence.

Select one:

transitive dependency

primary key

repeating group

Correct

partial dependency

Feedback

The correct answer is: repeating group

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

A table is in 4NF if it is in 3NF, and _____.

Select one:

all attributes must be dependent on the primary key and must be dependent on each other

it has no multivalued dependencies

Correct

no column contains the same values

all attributes are unrelated

Feedback

The correct answer is: it has no multivalued dependencies

Week 4 Quiz

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ join will select only the rows with matching values in the common attribute(s).

Select one:

outer

natural

Correct

full

cross

Feedback

The correct answer is: natural

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

SQL requires the use of the _____ command to enter data into a table.

Select one:

INSERT

Correct

SELECT

COMMIT

NOT NULL

Feedback

The correct answer is: INSERT

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

In Oracle, _____ retrieves the current value of a sequence.

Select one:

CURRVAL

Correct

VARCHAR

VARCHAR2

NEXTVAL

Feedback

The correct answer is: CURRVAL

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not.

Select one:

%NOTFOUND

%FOUND

Correct

%ISOPEN

%ROWCOUNT

Feedback

The correct answer is: %FOUND

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

144

Correct

Feedback

The correct answer is: 144

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

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.

Select one:

UPDATE

ROLLBACK

COMMIT

ALTER

Correct

Feedback

The correct answer is: ALTER

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

persistent storage module (PSM)

Correct

cursor-style process

statement-level trigger

base table

Feedback

The correct answer is: persistent storage module (PSM)

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a string function that returns the number of characters in a string value.

Select one:

UCASE

LENGTH

Correct

CONCAT

SUBSTRING

Feedback

The correct answer is: LENGTH

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ query specifies which data should be retrieved and how it should be filtered, aggregated, and displayed.

Select one:

COMMIT

UPDATE

INSERT

SELECT

Correct

Feedback

The correct answer is: SELECT

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a relational set operator.

Select one:

EXCEPT

Correct

ALL

EXISTS

PLUS

Feedback

The correct answer is: EXCEPT

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is a query that is embedded (or nested) inside another query.

Select one:

operator

alias

subquery

Correct

view

Feedback

The correct answer is: subquery

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

According to the rules of precedence, which of the following computations should be completed first?

Select one:

Operations within parentheses

Correct

Additions and subtractions

Power operations

Multiplications and divisions

Feedback

The correct answer is: Operations within parentheses

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

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.

Select one:

stored procedures

dynamic SQL

embedded SQL

Procedural Language SQL

Correct

Feedback

The correct answer is: Procedural Language SQL

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.

Select one:

outer

Correct

equi-

cross

inner

Feedback

The correct answer is: outer

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ join performs a relational product (also known as the Cartesian product) of two tables.

Select one:

equi-

natural

full

cross

Correct

Feedback

The correct answer is: cross

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

Oracle recommends _____ for creating audit logs.

Select one:

stored procedures

stored functions

triggers

Correct

tables

Feedback

The correct answer is: triggers

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

No matter what language you use, if it contains embedded SQL statements, it is called the _____ language.

Select one:

host

Correct

static

base

view

Feedback

The correct answer is: host

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ cursor is automatically created in procedural SQL when the SQL statement returns only one value.

Select one:

explicit

implicit

Correct

dynamic

static

Feedback

The correct answer is: implicit

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is an alternate name given to a column or table in any SQL statement.

Select one:

stored function

trigger

data type

alias

Correct

Feedback

The correct answer is: alias

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

A table can be deleted from the database by using the _____ TABLE command.

Select one:

DROP

Correct

ERASE

DELETE

MODIFY

Feedback

The correct answer is: DROP

Week 5 Quiz

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

_____ can render data useless to unauthorized users who might have violated some of the database security layers.

Select one:

Data encryption

Correct

Access rights

Password security

Physical security

Feedback

The correct answer is: Data encryption

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

_____ are required to prevent another transaction form reading inconsistent data.

Select one:

Schedules

Logs

Locks

Correct

Stamps

Feedback

The correct answer is: Locks

Question 3

Incorrect

0.00 points out of 1.00

Flag question

Question text

_____ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

Select one:

Time stamping

Serializability

Incorrect

Isolation [This is correct Answer]

Atomicity

Feedback

The correct answer is: Isolation

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

_____ occurs when a transaction accesses data before and after one or more other transactions finish working with such data.

Select one:

Inconsistent retrieval

Correct

Dirty read problems

The phenomena of uncommitted data

Lost update problems

Feedback

The correct answer is: Inconsistent retrieval

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

_____ requires that all operations of a transaction be completed.

Select one:

Atomicity

Correct

Durability

Time stamping

Specificity

Feedback

The correct answer is: Atomicity

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ lock allows concurrent transactions to access different rows of the same table.

Select one:

database table

table-level

page-level

row-level

Correct

Feedback

The correct answer is: row-level

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ lock will lock the entire diskpage.

Select one:

transaction-level

page-level

Correct

row-level

table-level

Feedback

The correct answer is: page-level

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ lock will lock the entire table, preventing access to any row by a transaction while another transaction is using the table.

Select one:

database-level

row-level

table-level

Correct

page-level

Feedback

The correct answer is: table-level

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

A consistent database state is one in which all _____.

Select one:

data integrity constraints are satisfied

Correct

table are normalized

SQL statements only update one table at a time

tables have foreign keys

Feedback

The correct answer is: data integrity constraints are satisfied

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

A diskpage, or page, is the equivalent of a _____.

Select one:

disk sector

database schema

diskblock

Correct

database table

Feedback

The correct answer is: diskblock

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A single-user database system automatically ensures_____ of the database, because only one transaction is executed at a time.

Select one:

atomicity and serializability

atomicity and isolation

serializability and durability

serializability and isolation

Correct

Feedback

The correct answer is: serializability and isolation

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources.

Select one:

Generalization

Normalization

Virtualization

Correct

Specialization

Feedback

The correct answer is: Virtualization

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the process of determining the data storage organization and data access characteristics of the database to ensure its integrity, security, and performance.

Select one:

Physical design

Correct

Logical design

Network design

Conceptual design

Feedback

The correct answer is: Physical design

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

"Should the existing system be replaced?" is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).

Select one:

maintenance

implementation

planning

Correct

analysis

Feedback

The correct answer is: planning

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

"What are the requirements of the current system's end users?" is a question asked during the _____ phase of the Systems Development Life Cycle (SDLC).

Select one:

implementation

maintenance

analysis

Correct

planning

Feedback

The correct answer is: analysis

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

Coding, testing, and debugging are part of the _____ phase of the Systems Development Life Cycle (SDLC).

Select one:

analysis

planning

implementation

Correct

detailed systems design

Feedback

The correct answer is: implementation

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).

Select one:

implementation

detailed systems design

planning

analysis

Correct

Feedback

The correct answer is: analysis

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

During decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.

Select one:

conceptual process

verification process

Correct

logical process

declaration process

Feedback

The correct answer is: verification process

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

During the _____ phase of the Systems Development Life Cycle (SDLC), the hardware, database management system (DBMS) software, and application programs are installed, and the database design is implemented.

Select one:

detailed systems design

maintenance

analysis

implementation

Correct

Feedback

The correct answer is: implementation

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.

Select one:

conservative backup

adaptive backup

transaction log backup

differential backup

Correct

Feedback

The correct answer is: differential backup

Week 6 Quiz

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the central activity during the parsing phase in query processing.

Select one:

Query validation

Query optimization

Correct

Partitioning

Clustering

Feedback

The correct answer is: Query optimization

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

_____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.

Select one:

Combination

Homogeneous

Correct

Heterogeneous

Fully heterogeneous

Feedback

The correct answer is: Homogeneous

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

_____ fragmentation allows a user to break a single object into two or more segments, or fragments.

Select one:

Vertical

Data

Correct

Request

Horizontal

Feedback

The correct answer is: Data

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the delay imposed by the amount of time required for a data packet to make a round trip from point A to point B.

Select one:

Data distribution

Network partitioning

Replica transparency

Network latency

Correct

Feedback

The correct answer is: Network latency

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

_____ transparency allows a physically dispersed database to be managed as though it were centralized.

Select one:

Failure

Distribution

Correct

Performance

Transaction

Feedback

The correct answer is: Distribution

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

_____ transparency exists when the end user or programmer must specify the database fragment names but does not need to specify where these fragments are located.

Select one:

Local mapping

Location

Correct

Fragmentation

Transaction

Feedback

The correct answer is: Location

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ distributed database system will support different database management systems (DBMS) that may even support different models running under different computer systems.

Select one:

homogeneous

fully heterogeneous

Correct

heterogeneous

fully homogeneous

Feedback

The correct answer is: fully heterogeneous

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ lets a single SQL statement access the data that are to be processed by a single remote database processor.

Select one:

remote transaction

remote request

Correct

distributed request

distributed transaction

Feedback

The correct answer is: remote request

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ request lets a single SQL statement reference data located at several different local or remote DP sites.

Select one:

remote

distributed

Correct

transaction

fragmented

Feedback

The correct answer is: distributed

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

A centralized database management is subject to a problem such as _____.

Select one:

growing numbers of remote locations

Correct

dependence on multiple sites

maintaining and operating small database systems

organizational flexibility of the database

Feedback

The correct answer is: growing numbers of remote locations

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A database management system needs _____ to prepare the data for presentation to the end user or to an application program.

Select one:

concurrency control

I/O interface

security

formatting

Correct

Feedback

The correct answer is: formatting

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

_____ refers to the number of different values a column could possibly have.

Select one:

Bitmap index

Data sparsity

Correct

Database statistics

Clustering

Feedback

The correct answer is: Data sparsity

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

A DBA determines the initial size of the data files that make up the database; however, as required, the data files can automatically expand in predefined increments known as _____.

Select one:

procedure cache

buffer cache

supplements

extents

Correct

Feedback

The correct answer is: extents

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

A system table space, a user data table space, an index table space, and a temporary table space are examples of _____.

Select one:

file groups

Correct

procedure caches

operation modes

data caches

Feedback

The correct answer is: file groups

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ is a logical grouping of several data files that store data with similar characteristics.

Select one:

procedure cache

table space

Correct

listener

data cache

Feedback

The correct answer is: table space

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

Automatic query optimization means that the:

Select one:

optimization takes place at compilation time by the programmer.

optimization process is scheduled and selected by the end user or programmer.

DBMS finds the most cost-effective access path without user intervention.

Correct

database access strategy is defined when the program is executed.

Feedback

The correct answer is: DBMS finds the most cost-effective access path without user intervention.

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

Bitmap indexes tend to use less space than a _____ because they use bits instead of bytes to store their data.

Select one:

sparse index

reverse index

hash index

B-tree index

Correct

Feedback

The correct answer is: B-tree index

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

During the ____ phase, the DBMS retrieves the data and sends the result set back to the client.

Select one:

process

parse

execute

fetch

Correct

Feedback

The correct answer is: fetch

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

From the performance point of view, _____ databases eliminate disk access bottlenecks.

Select one:

in-memory

Correct

distributed

RAID

index-organized

Feedback

The correct answer is: in-memory

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

If there is no index, the DBMS will perform a _____ scan.

Select one:

full table

Correct

row ID table access

loop

range

Feedback

The correct answer is: full table

Week 7 Quiz

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

_____ are in charge of presenting data to the end user in a variety of ways.

Select one:

Data analysis tools

Data stores

ETL tools

Data visualization tools

Correct

Feedback

The correct answer is: Data visualization tools

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

______ focuses on filtering data as it enters the system to determine which data to keep and which to discard.

Select one:

Feedback loop processing

Stream processing

Correct

Scaling up

Scaling out

Feedback

The correct answer is: Stream processing

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

Impala

Sqoop

Correct

Flume

Pig

Feedback

The correct answer is: Sqoop

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

Streaming

Scaling up

Correct

Scaling out

Clustering

Feedback

The correct answer is: Scaling up

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

______ was the first SQL on Hadoop application.

Select one:

Sqoop

Flume

Pig

Impala

Correct

Feedback

The correct answer is: Impala

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

______ minimizes the number of disk reads necessary to retrieve a row of data.

Select one:

Column-oriented database

Column-family database

Column-centric storage

Row-centric storage

Correct

Feedback

The correct answer is: Row-centric storage

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

Block

Batch

Correct

Hadoop

Hive

Feedback

The correct answer is: Batch

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

______ is NOT one of the "3 Vs" of Big Data.

Select one:

Variety

Volume

Velocity

Validation

Correct

Feedback

The correct answer is: Validation

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

node

block

batch

method

Correct

Feedback

The correct answer is: method

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

A query in a graph database is called a ______.

Select one:

script

hierarchy

traversal

Correct

schema

Feedback

The correct answer is: traversal

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) ______ is a process or set of operations in a calculation.

Select one:

structure

stream

algorithm

Correct

feedback loop

Feedback

The correct answer is: algorithm

Question 12

Correct

1.00 points out of 1.00

Flag question

Question text

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.

Select one:

label

Correct

edge

bucket

key

Feedback

The correct answer is: label

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

_____ can serve as a test vehicle for companies exploring the potential benefits of data warehouses.

Select one:

Data marts

Correct

Data cubes

OLAPs

Data networks

Feedback

The correct answer is: Data marts

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

OLAP

ROLAP

Correct

DBMS

Feedback

The correct answer is: ROLAP

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

_____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

Select one:

Normalization

Partitioning

Correct

Meta modeling

Replication

Feedback

The correct answer is: Partitioning

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

_____ tools focus on the strategic and tactical use of information.

Select one:

Networking

Business

Business intelligence

Correct

Relational database management

Feedback

The correct answer is: Business intelligence

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

_____ provide a unified, single point of entry for information distribution.

Select one:

Decision support systems

Data warehouses

Dashboards

Portals

Correct

Feedback

The correct answer is: Portals

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ index is based on 0 and 1 bits to represent a given condition.

Select one:

bitmapped

Correct

normal

logical

multidimensional

Feedback

The correct answer is: bitmapped

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows.

Select one:

SQL view

star schema

data cube

materialized view

Correct

Feedback

The correct answer is: materialized view

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

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

Select one:

starflake

dimension

matrix

snowflake

Correct

Feedback

The correct answer is: snowflake

Week 8 Quiz [Final Quiz]

US-India Student Support Services