Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Sql Advanced DataBase > Test 2 > Flashcards

Test 2 Flashcards

1
Q

One of the advantages of a distributed database management system (DDBMS) is _______operating cost.

A

reduced/ Lower

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

A user-friendly______ is one advantage of a distributed database management system (DDBMS) .

A

interface

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

One of the advantages of a distributed database management system (DDBMS) is less danger of a single- _____failure.

A

point

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

One of the advantages of a distributed database management system (DDBMS) is processor____.

A

independence

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

In a basic distributed processing environment, the distributed processing system shares the database chores among three sites connected through a_____.

A

communications network

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

_____management ensures that data move from one consistent state to another.

A

Transaction

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

distributed database management system (DDBMS),_____occurs to determine the data location of local and remote fragments.

A

mapping

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

In a distributed database management system (DDBMS), query______is used to find the best access strategy.

A

optimization

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

In a distributed database management system (DDBMS),______control is used to manage simultaneous data access and ensure data consistency across database fragments.

A

concurrency

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

A transaction processor is also known as the______processor.

A

application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

____________is a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

A

_Master data management/ mdm /Master data management(MDM)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

______use web-based technologies to present key business performance indicators or information in a single integrated view, generally using graphics in a clear, concise, and easy to understand manner.

A

__Dashboards

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Data_______tools are tools that provide advanced statistical analysis to uncover problems and opportunities hidden within business data.

A

__mining

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

_______are quantifiable measurements (numeric or scale based) that assess a companys effectiveness or success in reaching its strategic and operational goals.

A

Key Performance Indicators, KPI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

To support a(n)_______adequately, the DBMS might be required to support advanced storage technologies, and even more importantly, to support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or a massively parallel processor (MPP).

A

VLDB, Very Large Database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

__________is a read-only database optimized for data analysis and query processing.

A

__Data warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

A data_______is a centralized, consolidated database that integrates data derived from the entire organization and from multiple sources with diverse formats.

A

__warehouse

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

A data_______is a small, single-subject data warehouse subset that provides decision support to a small group of people.

A

__mart

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

______are numeric measurements (values) that represent a specific business aspect or activity.

A

__Facts

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

_____are qualifying characteristics that provide additional perspectives to a given fact.

A

__Dimensions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

In multidimensional terms, the ability to focus on slices of the cube to perform a more detailed analysis is known as______.

A

__slice and dice

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

The___________hierarchy provides the capability to perform drill-down and roll-up searches in a data warehouse.

A

__attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

______makes a copy of a table and places it in a different location to improve access time.

A

__Replication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

The most distinctive characteristic of modern OLAP tools is their capacity for_______analysis.

A

__multidimensional

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

To deliver efficient decision support, OLAP tools must have advanced data_____features.

A

__access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

In the___ category, the cloud service provider offers the capability to build and deploy consumer-created applications using the providers cloud infrastructure.

A

Platform as a Service (PaaS)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

ODBC, OLE-DB, and_ADO.NET_form the backbone of the_______________ architecture.

A

_ UDA, Universal Data Access

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

Open Database Connectivity (ODBC), a superset of the SQL Access Group Call Level Interface (CLI), is implemented by_____________ .

A

_ Microsoft

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

A(n)______ is a unique name by which the data source will be known to ODBC, and therefore, to applications.

A

DSN, Data Source Name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

In the context of OLE-DB, a________ is an object (application or process) that requests and uses data.

A

_ consumer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q

In the OLE-DB model, the____________ acts like a data consumer of the data provider and as a data provider for the data consumer (end-user application).

A

_ service provider

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q

A(n) _____ is a program written in a programming language that is not compiled, but is interpreted and executed at run time.

A

_ script

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
33
Q

provides a unified interface to access data from any programming language that uses the underlying OLE- DB objects.

A

_ ActiveX Data Objects, ADO,

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
34
Q

The Microsoft___ framework is a component-based platform for developing distributed, heterogeneous, interoperable applications aimed at manipulating any type of data over any network under any operating system and any programming language.

A

_ .NET

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
35
Q

is an application programming interface that allows a Java program to interact with a wide range of data sources (relational databases, tabular data sources, spreadsheets, and text files).

A

_ Java Database Connectivity JDBC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
36
Q

webpages are at the heart of current generation websites.

A

_ Dynamic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
37
Q

APIs are faster than_______ scripts because the code resides in memory and there is no need to run an external program for each request.

A

Common Gateway Interface Common Gateway Interface (CGI)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
38
Q

Regardless of the type of web server interface used, a web-to-database_____________ program must be able to connect with a database.

A

_ middleware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
39
Q

A web__ server is a middleware application that expands the functionality of web servers by linking them to a wide range of services.

A

_ application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
40
Q

To prevent the server from performing all data validation,__________ data input validation is one of the most basic requirements for web applications.

A

_ client-side

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
41
Q

, or transactions done over the Internet, enables all types of organizations to sell products and services to a global market.

A

_ E-commerce

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
42
Q

XML is derived from the______________ , an international standard for the publication and distribution of highly complex technical documents.

A

Standard Generalized Markup Language (SGML)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

XML tags must be well formed, that is, each opening tag must have a corresponding____ __ tag.

A

_ closing

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
44
Q

A(n)_____ _ provides limited additional semantic value to XML, such as data type support or data validation rules.

A

document type definition (DTD)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
45
Q

A DBMS that supports__ exchanges can integrate with external systems such as the web, mobile data, and legacy systems, thus enabling the creation of new types of systems.

A

_ XML

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
46
Q

In the context of data quality management tools,_______software is one that gathers statistics, analyzes existing data sources and metadata to determine patterns, and compares the patterns against standards that the organization has defined.

A

__data-profiling

47
Q

In the context of an organization’s managerial structure,______decisions are short term and affect only daily operations; for example, deciding to change the price of a product to clear it from inventory.

A

__operational

48
Q

In the context of database administration,_______is the extent to which individuals and organizations have the right to determine the Ðwho, what, when, where, and howÓ of data usage.

A

__privacy

49
Q

The___________aspect of introducing a DBMS in an organization deals with hardware and software changes in the organization.

A

__technological

50
Q

in the context of the advancements in DBMS technology, the use of______data services can free the DBA from many lower-level technology-oriented tasks.

A

__cloud

51
Q

In case a company installs several incompatible databases and assigns a DBA for each of them, the general coordinator of all such DBAs is known as the_______administrator.

A

__systems

52
Q

The__________, also known as the information resource manager (IRM), usually reports directly to top management and is given a higher degree of responsibility and authority than the DBA, although the two roles can overlap.

A

data administrator

53
Q

Based on the type of decision-making support required, database users may be classified into: operational, tactical, or _____.

A

__strategic

54
Q

The requirement that a password must have a maximum of 12 characters is an example of a(n)___.

A

__standard

55
Q

The DSOs activities are often classified as_______management, which includes all DBA activities designed to ensure data availability following a physical calamity or a database integrity failure.

A

__disaster

56
Q

In the context of ensuring integrity of a database, a(n)______transaction is one that does not overload the DBMS.

A

__efficient

57
Q

The DBA must review the database application design to ensure that transactions are____, meaning that they mirror real-world events.

A

__correct

58
Q

Performance monitoring and________activities are designed to ensure that the DBMS, utilities, and applications maintain satisfactory performance levels.

A

__tuning

59
Q

Within the data security framework,________is concerned with keeping data consistent and free of errors or anomalies.

A

__integrity

60
Q

A security___________is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

A

__vulnerability

61
Q

Tools used to automate part or all of the Systems Development Life Cycle.

A

computer-aided systems engineering (CASE)

62
Q

The person responsible for planning, organizing, controlling, and monitoring the centralized and shared corporate database. The DBA is the general manager of the database administration department.

A

database administrator (DBA)

63
Q

Data that contain inaccuracies and/or inconsistencies.

A

dirty data

64
Q

The set of DBA activities dedicated to securing data availability following a physical disaster or a database integrity failure.

A

disaster management

65
Q

A complete copy of an entire database saved and periodically updated in a separate memory location. A full backup ensures a full recovery of all data after a physical disaster or database integrity failure.

A

full backup (database dump)

66
Q

The output of the information engineering process that serves as the basis for planning, developing, and controlling future information systems.

A

information systems architecture (ISA)

67
Q

In business intelligence, a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

A

master data management (MDM)

68
Q

In Oracle, a named collection of database access privileges that authorize a user to connect to a database and use its system resources.

A

role

69
Q

The person responsible for coordinating an organization’s data-processing activities.

A

systems administrator

70
Q

In a DBMS, a logical storage space used to group related data. Also known as a file group.

A

tablespace

71
Q

The data access component of Microsoft’s .NET application development framework, which is a component-based platform for developing distributed, heterogeneous, and interoperable applications aimed at manipulating any type of data over any network using any operating system and programming language.

A

ADO.NET

72
Q

A computing model that provides ubiquitous, on-demand access to a shared pool of configurable resources that can be rapidly provisioned.

A

cloud computing

73
Q

A Web server interface standard that uses script files to perform specific functions based on a client’s parameters.

A

Common Gateway Interface (CGI)

74
Q

A name that identifies and defines an ODBC data source.

A

data source name (DSN)

75
Q

An application programming interface that allows a Java program to interact with a wide range of data sources, including relational databases, tabular data sources, spreadsheets, and text files.

A

Java Database Connectivity (JDBC)

76
Q

Database middleware developed by Microsoft to provide a database access API to Windows applications.

A

Open Database Connectivity (ODBC)

77
Q

A programming language that is not compiled, but is interpreted and executed at run time.

A

script

78
Q

Within the Microsoft application framework, a collection of technologies used to access any type of data source and to manage the data through a common interface.

A

Universal Data Access (UDA)

79
Q

An advanced data definition language used to describe the elements, data types, relationship types, ranges, and default values of XML data documents. One of the main advantages of an XML schema is that it more closely maps to database terminology and features.

A

XML schema

80
Q

A file that contains the description of an XML document.

A

XML schema definition (XSD)

81
Q

A specification used to define the rules by which XML data are formatted and displayed. The XSL specification is divided into two parts: Extensible Style Language Transformations and XSL style sheets.

A

XSL (Extensible Style Language)

82
Q

The general mechanism used to extract and process data from one XML document and enable its transformation within another document.

A

XSLT (Extensible Style Language Transformations)

83
Q

A comprehensive, cohesive, and integrated set of tools and processes used to capture, collect, integrate, store, and analyze data with the purpose of generating and presenting information to support business decision making.

A

business intelligence (BI)

84
Q

In business intelligence, a Web-based system that presents key business performance indicators or information in a single, integrated view with clear and concise graphics.

A

dashboard

85
Q

The multidimensional data structure used to store and manipulate data in a multidimensional DBMS. The location of each data value in the data cube is based on its x-, y-, and z-axes. Data cubes are static, meaning they must be created before they are used, so they cannot be created by an ad hoc query.

A

data cube

86
Q

A small, single-subject data warehouse subset that provides decision support to a small group of people.

A

data mart

87
Q

A process that employs automated tools to analyze data in a data warehouse and other sources and to proactively identify possible relationships and anomalies.

A

data mining

88
Q

An integrated, subject-oriented, time-variant, nonvolatile collection of data that provides support for decision making, according to Bill Inmon, the acknowledged father of the data warehouse.

A

data warehouse

89
Q

In a star schema design, qualifying characteristics that provide additional perspectives to a given fact.

A

dimensions

90
Q

To decompose data into more atomic components that is, data at lower levels of aggregation. This approach is used primarily in a decision support system to focus on specific geographic areas, business types, and so on.

A

drill down

91
Q

In a data warehouse, the star schema table that contains facts linked and classified through their common dimensions. A fact table is in a one-to-many relationship with each associated dimension table.

A

fact table

92
Q

In business intelligence, quantifiable numeric or scale-based measurements that assess a company’s effectiveness or success in reaching strategic and operational goals. Examples of KPI are product turnovers, sales by promotion, sales by employee, and earnings per share.

A

key performance indicators (KPIs)

93
Q

In business intelligence, a collection of concepts, techniques, and processes for the proper identification, definition, and management of data elements within an organization.

A

master data management (MDM)

94
Q

An extension of online analytical processing to multidimensional database management systems.

A

multidimensional online analytical processing

95
Q

Decision support system tools that use multidimensional data analysis techniques. OLAP creates an advanced data analysis environment that supports decision making, business modeling, and operations research.

A

online analytical processing (OLAP)

96
Q

Data analytics that use advanced statistical and modeling techniques to predict future business outcomes with great accuracy.

A

predictive analytics

97
Q

In SQL, an OLAP extension used with the GROUP BY clause to aggregate data by different dimensions. Rolling up the data is the exact opposite of drilling down the data.

A

roll up

98
Q

The ability to cut slices off a data cube to perform a more detailed analysis.

A

slice and dice

99
Q

A type of star schema in which dimension tables can have their own dimension tables. The snowflake schema is usually the result of normalizing dimension tables.

A

snowflake schema

100
Q

A data modeling technique used to map multidimensional decision support data into a relational database. The star schema represents data using a central table known as a fact table in a 1:M relationship with one or more dimension tables.

A

star schema

101
Q

Databases that contain huge amounts of data gigabyte, terabyte, and petabyte ranges are not unusual.

A

very large databases (VLDBs)

102
Q

The arrangement of hardware and software components to form a system composed of clients, servers, and middleware. The client/server architecture features a user of resources, or a client, and a provider of resources, or a server.

A

client/server architecture

103
Q

A characteristic of a DDBMS that allows a single object to be broken into two or more segments or fragments. The object might be a user’s database, a system database, or a table. Each fragment can be stored at any site on a computer network.

A

data fragmentation

104
Q

A characteristic of a DDBMS that allows a single object to be broken into two or more segments or fragments. The object might be a user’s database, a system database, or a table. Each fragment can be stored at any site on a computer network.

A

data fragmentation

105
Q

The storage of duplicated database fragments at multiple sites on a DDBMS. Duplication of the fragments is transparent to the end user. Data replication provides fault tolerance and performance enhancements.

A

data replication

106
Q

A logically related database that is stored in two or more physically independent sites.

A

distributed database

107
Q

A DBMS that supports a database distributed across several different sites; a DDBMS governs the storage and processing of logically related data over interconnected computer systems in which both data and processing functions are distributed among several sites.

A

distributed database management system

108
Q

A DDBMS feature that allows a distributed database to look like a single logical database to an end user.

A

distribution transparency

109
Q

A system that integrates different types of centralized database management systems over a network.

A

heterogeneous DDBMS

110
Q

A system that integrates only one type of centralized database management system over a network.

A

homogeneous DDBMS

111
Q

In partitioned databases, one or more attributes in a table that determine the fragment in which a row will be stored.

A

partition key

112
Q

A DDBMS property that ensures database transactions will maintain the distributed database’s integrity and consistency, and that a transaction will be completed only when all database sites involved complete their part of the transaction.

A

transaction transparency

113
Q

In distributed database design, the process that breaks a table into a subset of columns from the original table. Fragments must share a common primary key.

A

vertical fragmentation

Sql Advanced DataBase (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions