Question 1 of 25
Hints left: 3
Q1
The presentation logic component is responsible for formatting and presenting data on the user's screen or other output device, and for managing user input from a keyboard or other input device.
Q2
Symmetric multiprocessing (SMP) architectures are useful for situations where data must remain in memory during processing to achieve the desired performance level.
Q3
Data scrubbing is which of the following?
Q4
An operational system is which of the following?
Q5
Massively parallel processing (MPP) systems require a complete copy of the operating system to be resident in each dedicated memory.
Q6
The generic two-level data warehouse architecture includes which of the following?
Q7
Writing stored procedures takes less time than using Visual Basic or PowerBuilder to create an application.
Q8
A database server is responsible for which of the following?
Q9
The @active data warehouse architecture includes which of the following?
Q10
A snowflake schema is which of the following types of tables?
Q11
The database server is responsible for database storage, access, and processing.
Q12
A goal of data mining includes which of the following?
Q13
Fact tables are which of the following?
Q14
Client/server environments use a local area network (LAN) to support a network of personal computers, each with its own storage, that are also able to share common devices and software attached to the LAN.
Q15
Data transformation includes which of the following?
Q16
Query-by-Example (QBE) is the most widely available direct-manipulation database query language.
Q17
A data warehouse is which of the following?
Q18
Centralized systems are more susceptible to security threats than client/server architectures.
Q19
With an asynchronous system, the requesting system waits for a response in real time.
Q20
The Windows operating system and Windows applications are event driven.
Q21
The first client/server architectures developed were file servers.
Q22
Data processing logic includes such activities as data validation and identification of processing errors.
Q23
A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.
Q24
ODBC requires the specific driver.
Q25
Activities of a DBMS occur in the processing component logic.