DAT 390 Wk 1 – Practice: Pre-Course Assessment Quiz

$19.99

DAT 390 Wk 1 – Practice: Pre-Course Assessment Quiz

Description

DAT 390 Wk 1 – Practice: Pre-Course Assessment Quiz

DAT 390 Wk 1 – Practice: Pre-Course Assessment Quiz

SCORE 25/25 100%

 

The purpose of an I/O operation is to move data to and from different computer components or devices.

  • True
  • False

 

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

  • procedure caches
  • operation modes
  • data caches
  • file groups

 

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

  • store
  • fetch
  • gather
  • retrieve

 

_____ code is embedded inside an HTML page and is activated by triggering events such as clicking on a link.

  • Visual Basic
  • SQL
  • XML
  • VBScript

 

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

  • procedure cache
  • table space
  • listener
  • data cache

 

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

  • Data
  • Vertical
  • Horizontal
  • Request

 

On the client side, the objective is to generate an SQL query that returns a correct answer in the least amount of time, using a minimum amount of resources at the server end. The activities required to achieve this goal are commonly referred to as _____ tuning.

  • DBMS performance
  • SQL performance
  • client SQL
  • database SQL

 

A good API makes it easy to develop a program by providing all of the building blocks.

  • True
  • False

 

Data visualization has its roots in the _____ sciences, which focus on how the human brain receives, interprets, organizes, and processes information.

  • cognitive
  • social
  • health
  • developmental

 

Incremental backups produce a backup of all data.

  • True
  • False

 

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

  • Combination
  • Homogeneous
  • Heterogeneous
  • Fully heterogeneous

In a typical star schema, each dimension record is related to thousands of _____ records.

  • key
  • attribute
  • fact
  • primary

Indexes do not facilitate join operations.

  • True
  • False

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

  • remote
  • fragmented
  • distributed
  • transaction

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

  • Relational database management
  • Business intelligence
  • Business
  • Networking

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

  • True
  • False

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

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

The web browser’s job is to interpret the HTML code that it receives from a web server and to:

  • develop web-based applications.
  • extract details, such as order data, from it.
  • perform immediate data entry validation.
  • display it in a standard formatted way.

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

  • True
  • False

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

  • page-level
  • table-level
  • database table
  • row-level

A reduce function takes a collection of key-value pairs with the same key value and summarizes them into a single result.

  • True
  • False

Time stamps must only have the single property of uniqueness.

  • True
  • False

The B-tree index is used mainly in tables in which column values repeat a relatively small number of times.

  • True
  • False

The multiuser DBMS must implement controls to ensure serializability and isolation of transactions, in addition to atomicity and durability, in order to guard the database’s consistency and integrity.

  • True
  • False

The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.

  • True
  • False

 

V081920

DAT 390 Wk 1 – Practice: Pre-Course Assessment Quiz