INF503 Week 1 Quize's

 Pre-Course Assessment

Your Score: 92%
23 Correct out of 25
Question 1 of 25

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

• child
• strong
• weak
• business

CORRECT

In the relational model, _____ are important because they are used to ensure that each row in a table is uniquely identifiable.

• indexes
• keys
• relations
• logical structures

CORRECT

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

• denormalization
• star schema
• normalization
• multidimensional schema

CORRECT

Fully equivalent means that the optimized query results are always the same as the original query.

• True
• False

CORRECT

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

• Column-oriented database
• Column-family database
• Column-centric storage
• Row-centric storage

CORRECT

The storage locations for multiple backups must include sites inside and outside the organization.

• True
• False

CORRECT

In the single-site processing, single-site data (SPSD) scenario, all processing must be done on the end user's side of the system.

• True
• False

CORRECT

Which statement describes a feature of Oracle sequences?

• An Oracle sequence uses the identity column property to automatically number rows.
• Oracle sequences are tied to columns and tables.
• Oracle sequences generate a character string that can be assigned to tables.
• Dropping a sequence does not delete values assigned to table attributes; it deletes only the sequence object from the database.

CORRECT

Automatic query optimization means that the:

• DBMS finds the most cost-effective access path without user intervention.
• database access strategy is defined when the program is executed.
• optimization takes place at compilation time by the programmer.
• optimization process is scheduled and selected by the end user or programmer.

CORRECT

_____ 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.

• Local mapping
• Location
• Transaction
• Fragmentation

CORRECT

The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

• True
• False

CORRECT

MySQL allows multiple triggering conditions per trigger.

• True
• False

CORRECT

An operational database is sometimes referred to as an enterprise database.

• True
• False

INCORRECT

The scheduler establishes the order in which the operations within concurrent transactions are executed.

• True
• False

CORRECT

Which of the following is true of business rules?

• They allow the designer to set company policies with regard to data.
• They allow the designer to develop business processes.
• They can serve as a communication tool between the users and designers.
• They provide a framework for the company's self-actualization.

CORRECT

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

• True
• False

CORRECT

The _____ component of a CASE tool produces the information system's input/output formats.

• screen painter and report generator
• program document generator
• graphics
• analysis

CORRECT

The effects of bad database design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred.

• True
• False

CORRECT

Which of the following is a specialization hierarchy overlapping constraint scenario in case of partial completeness?

• Supertype has optional subtypes.
• Subtype does not have a supertype.
• Subtype sets are unique.
• Subtype discriminators cannot be null.

CORRECT

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

• Password security
• Access rights
• Data encryption
• Physical security

CORRECT

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?

• SELECT DIFFERENT V_CODE
  
  FROM PRODUCT;
• SELECT UNIQUE V_CODE
  
  FROM PRODUCT;
• SELECT DISTINCT V_CODE
  
  FROM PRODUCT;
• SELECT ONLY V_CODE
  
  FROM PRODUCT;

INCORRECT

Which of the following is true of a web application server?

• It is automatically invoked by the browser when needed.
• It runs on the client machine, freeing server resources.
• It provides security and authentication of users through user IDs and passwords.
• It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access.

CORRECT

A(n) _____ specifically reserves access to the transaction that locked the object.

• exclusive lock
• shared lock
• binary lock
• deadlock

CORRECT

Advanced OLAP feature become more useful when access to them is kept simple.

• True
• False

CORRECT

An atomic attribute _____.

• is always chosen to be a foreign key
• displays multiplicity
• cannot be further subdivided
• cannot exist in a relational table

CORRECT

An atomic attribute _____.

• is always chosen to be a foreign key
• displays multiplicity
• cannot be further subdivided
• cannot exist in a relational table

CORRECT

Question 1

Correct

1.00 points out of 1.00

Flag question

Question text

_____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information.

Select one:

a.

Raw data

b.

Structured data

Correct

c.

Obsolete data

d.

Unstructured data

Feedback

The correct answer is: Structured data

Question 2

Correct

1.00 points out of 1.00

Flag question

Question text

_____ data exist in a format that does not lend itself to processing that yields information.

Select one:

a.

Semistructured

b.

Historical

c.

Unstructured

Correct

d.

Structured

Feedback

The correct answer is: Unstructured

Question 3

Correct

1.00 points out of 1.00

Flag question

Question text

_____ data exist in the format in which they were collected.

Select one:

a.

Structured

b.

Unstructured

Correct

c.

Semistructured

d.

Historical

Feedback

The correct answer is: Unstructured

Question 4

Correct

1.00 points out of 1.00

Flag question

Question text

_____ exists when different versions of the same data appear in different places.

Select one:

a.

Data inconsistency

Correct

b.

Poor data security

c.

Conceptual dependence

d.

Structural dependence

Feedback

The correct answer is: Data inconsistency

Question 5

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

Select one:

a.

Data integrity

Correct

b.

Data ubiquity

c.

Data anomaly

d.

Data quality

Feedback

The correct answer is: Data integrity

Question 6

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the body of information and facts about a specific subject.

Select one:

a.

Knowledge

Correct

b.

A database

c.

Validation

d.

A format

Feedback

The correct answer is: Knowledge

Question 7

Correct

1.00 points out of 1.00

Flag question

Question text

_____ is the result of revealing the meaning of raw facts.

Select one:

a.

End-user data

b.

Information

Correct

c.

An encrypted bit

d.

An encoded sample

Feedback

The correct answer is: Information

Question 8

Correct

1.00 points out of 1.00

Flag question

Question text

_____ provide a description of the data characteristics and the set of relationships that link the data found within the database.

Select one:

a.

End-user data

b.

Queries

c.

Schemas

d.

Metadata

Correct

Feedback

The correct answer is: Metadata

Question 9

Correct

1.00 points out of 1.00

Flag question

Question text

_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.

Select one:

a.

Database management

b.

Performance tuning

Correct

c.

Database design

d.

Query access

Feedback

The correct answer is: Performance tuning

Question 10

Correct

1.00 points out of 1.00

Flag question

Question text

_____ serve as the intermediary between the user and the database.

Select one:

a.

Metadata

b.

Programming languages

c.

DBMSs

Correct

d.

End-user data

Feedback

The correct answer is: DBMSs

Question 11

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is a character or group of characters that has a specific meaning.

Select one:

a.

field

Correct

b.

database

c.

record

d.

file

Feedback

The correct answer is: field

Question 12

Incorrect

0.00 points out of 1.00

Flag question

Question text

A _____ is a collection of related records.

Select one:

a.

field

Incorrect

b.

file

c.

column

d.

schema

Feedback

The correct answer is: file

Question 13

Correct

1.00 points out of 1.00

Flag question

Question text

A _____ is a logically connected set of one or more fields that describes a person, place, or thing.

Select one:

a.

column

b.

file

c.

record

Correct

d.

database

Feedback

The correct answer is: record

Question 14

Correct

1.00 points out of 1.00

Flag question

Question text

A data warehouse contains historical data obtained from the _____.

Select one:

a.

enterprise databases

b.

desktop database

c.

workgroup databases

d.

operational databases

Correct

Feedback

The correct answer is: operational databases

Question 15

Correct

1.00 points out of 1.00

Flag question

Question text

A desktop database is a _____ database.

Select one:

a.

multiuser

b.

distributed

c.

single-user

Correct

d.

workgroup

Feedback

The correct answer is: single-user

Question 16

Correct

1.00 points out of 1.00

Flag question

Question text

A workgroup database is a(n) _____ database.

Select one:

a.

distributed

b.

desktop

c.

single-user

d.

multiuser

Correct

Feedback

The correct answer is: multiuser

Question 17

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ database is used by an organization and supports many users across many departments.

Select one:

a.

desktop

b.

transactional

c.

workgroup

d.

enterprise

Correct

Feedback

The correct answer is: enterprise

Question 18

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.

Select one:

a.

workgroup

Correct

b.

transactional

c.

enterprise

d.

desktop

Feedback

The correct answer is: workgroup

Question 19

Correct

1.00 points out of 1.00

Flag question

Question text

A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.

Select one:

a.

query

b.

application

Correct

c.

operating system

d.

database management system

Feedback

The correct answer is: application

Question 20

Correct

1.00 points out of 1.00

Flag question

Question text

Accurate, relevant, and timely information is the key to ____.

Select one:

a.

data management

b.

good decision making

Correct

c.

knowledge

d.

understanding

Feedback

The correct answer is: good decision making