Quiz
DB
This quiz has question types that open in the usual player.
Questions in this quiz (17)
1[blank_start]connection pool[blank_end] is a cache of database connectons maintained so that the connectons can be reused when future requests to the database are required.
- Aconnection pool
2network computing model that distributes processes between
clients and servers. [blank_start]Client/Server Systems[blank_end]- AClient/Server Systems
33 Components of Application Logic
[blank_start]Presentation Logic[blank_end]
[blank_start]Processing Logic[blank_end]
[blank_start]Storage[blank_end]- APresentation Logic
- BProcessing Logic
- CStorage
4A client workstaton is responsible for managing user interface,
including presentaton logic, data processing logic, and business
rules logic. A database server is responsible for database storage,
processing, and access. [blank_start]Two-Tier Architecture[blank_end]- ATwo-Tier Architecture
5A client/server confguraton that includes three layers: a client
layer and two server layers. The additonal server in a three-ter
architecture may be used for diferent purposes. [blank_start]Three-Tier Architecture[blank_end]- AThree-Tier Architecture
6Shows the various components of a typical Web applicaton. [blank_start]Web Application Components[blank_end]
- AWeb Application Components
7Four Key Components To Create A Web
application
[blank_start]database server[blank_end]
[blank_start]Web server[blank_end]
[blank_start]Applicaton server[blank_end]
[blank_start]Web browser[blank_end]- Adatabase server
- BWeb server
- CApplicaton server
- DWeb browser
8modules of code that implement application logic and are included on the database server.
[blank_start]Stored procedures[blank_end]- AStored procedures
9Popular Categorizaton Of Cloud Technologies
– [blank_start]Infrastructure-as-a Service[blank_end]
(Microsoft’s Azure and Rackspace)
– [blank_start]Platorm-as-a Service[blank_end]
(Applicaton servers, Web servers and database technologies)
– [blank_start]Sofware-as-a Service[blank_end]
(Google, Facebook, Twitter)- APlatorm-as-a Service
- BInfrastructure-as-a Service
- CSofware-as-a Service
10A [blank_start]data warehouse[blank_end] is a subject oriented, integrated, time-variant, and non-volatile collection of data. This data helps analysts to take informed decisions in an organization.
- Adata warehouse
11[blank_start]Subject-oriented[blank_end]
Key subjects/specific
[blank_start]Integrated[blank_end]
Integrates data
[blank_start]Non-volatile[blank_end]
Does not change
[blank_start]Time variant[blank_end]
Historical data- ASubject-oriented
- BIntegrated
- CNon-volatile
- DTime variant
12[blank_start]DERIVED DATA LAYER[blank_end]
It is the layer with which users normally interact for their decision support.- ADERIVED DATA LAYER
13DATA MART
Typically is accessed via [blank_start]Online Analytical Processing[blank_end]
(OLAP) tools.- AOnline Analytical Processing
14[blank_start]STAR SCHEMA[blank_end] (DIMENSIONAL MODEL)
Commonly used to implement DERIVED DATA
LAYER.
Is a specially designed, denormalized relational model
data.- ASTAR SCHEMA
15[blank_start]FACT TABLES[blank_end]
Contains factual or quantitative data
about a business, such as units sold,
orders booked, and so on.
[blank_start]DIMENSIONAL TABLES[blank_end]
Hold descriptive data about the
subjects of the business.- AFACT TABLES
- BDIMENSIONAL TABLES
16[blank_start]MULTIPLE FACT TABLES[blank_end]
It is often desirable for
performance or other reasons
to define more than one fact
table in a given star schema.- AMULTIPLE FACT TABLES
17[blank_start]Big data[blank_end]
An ill-defined term applied to databases whose
size strains the ability of commonly used
relational DBMSs to capture, manage, and
process the data within tolerable elapsed time.- ABig data
Information
- Description
- Quiz on DB, created by Inorinne on 29/08/2016.
- Author
- Inorinne
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz