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