INF3703 - MCQ QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED
0 view 0 purchase
Course
INF3703
Institution
INF3703
INF3703 - MCQ QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED
One likely problem when operational data is integrated into the data warehouse includes variation in terms of different departmental recording of data, data type and structure. T status of an order may be indicated with text labels...
INF3703 - MCQ QUESTIONS AND ANSWERS LATEST
UPDATE A+ GRADED
One likely problem when operational data is integrated into the data warehouse
includes variation in terms of different departmental recording of data, data type
and structure. T status of an order may be indicated with text labels as "open",
"received", or "closed" in one department while another department has it as "1",
"2", or "4". Student status can be defined as "Freshman", "Sophomore" or
Senior" in the Accounting department and as "FR", "SO" or "SR" in the
Computing dept. An ID number field may be stored in one database as a string of
numbers and dashes (XXXXXXX-XXXX-XX-X), in another as a string of numbers
without the dashes (XXXXXXXXXXX).
These examples are indication that most of the data transformation problems are
related to all of the following EXCEPT______.
Select one:
a. Incompatible data formats
b. Use of synonyms and homonyms
c. Inconsistent modification
Inconsistent modification formats
_____ is a meta-language used to represent and manipulate data elements.
Select one:
a. XML
b. XHTML
c. XML Schemas
d. HTML
XML
_____ provides the semantics that facilitates the sharing, exchange, and
manipulation of structured documents over organisational boundaries.
Select one:
a. HTML
b. XHTML
c. XML
d. XML Schemas
XML
___ can be placed on any fields in the file that is unordered.
Select one:
a. The candidate index
b. The primary index
,c. The multi-level index
d. The secondary index
The secondary index
____ are places on unique fields and they are used to locate a specific record
pointed to by the index.
Select one:
a. Primary indexes
b. Single-level indexes
c. Secondary indexes
d. Multi-Level indexes
Primary indexes
____ can be placed on any field in the file that is unordered.
Select one:
a. Multi-Level indexes
b. Secondary indexes
c. Single-level indexes
d. Primary indexes
Secondary indexes
____ interleaves the execution of the database operations belonging to several
concurrent transactions to ensure the _____of transactions.
Select one:
a. Scheduler and isolation
b. Scheduler and consistency
c. Scheduler and Atomicity
d. Scheduler and serializability
Scheduler and serializability
____ stores a processed version of SQL that is ready for execution by the DBMS.
Select one:
a. Buffer cache
b. Data cache
c. Procedure cache
d. Extends cache
Procedure cache
_____ activities cover all tasks directly related to the day-to-day operations of the
DBMS and its applications.
Select one:
a. Security auditing and monitoring
b. System support
c. Performance monitoring and tuning
d. Backup and recovery
System support
,_____ allows the translation of the company's strategic goals into the data and
applications that will help the company achieve those goals.
Select one:
a. MOLAP
b. Access Management
c. Business Intelligence
d. Information engineering (IE)
Information engineering (IE)
_____ are in charge of presenting data to the end user in a variety of ways.
Select one:
a. Data stores
b. Data analysis tools
c. Data visualization tools
d. ETL tools
Data visualization tools
_____ are more detailed and specific than policies and describe the minimum
requirements of a given DBA activity.
Select one:
a. Documentations
b. Standards
c. Guidelines
d. Procedures
Standards
_____ CASE tools provide support for the coding and implementation phases.
Select one:
a. Vertical
b. Back-end
c. Front-end
d. Horizontal
Back-end
_____ CASE tools provide support for the planning, analysis, and design phases.
Select one:
a. Front-end
b. Vertical
c. Horizontal
d. Back-end
Front-end
_____ Code is embedded inside an HTML page and is activated by triggering
events such as clicking on a link.
Select one:
, a. SQL
b. VBScript
c. XML
d. Visual Basic
VBScript
_____ component of star schema allows the data warehouse and online
transaction processing (OLAP) systems to use a carefully defined path that will
govern how data are to be decomposed and aggregated for drill-down and roll-up
operations.
Select one:
a. Attribute hierarchy
b. Dimension
c. Attribute
d. Fact
Attribute hierarchy
_____ deals with ensuring that data is protected against unauthorized access,
and if the data are accessed by an authorized user, that the data are used only for
an authorized purpose.
Select one:
a. Integrity
b. Compliance
c. Confidentiality
d. Availability
Confidentiality
_____ describes the extent to which modules are independent of one another.
Select one:
a. Module coupling
b. Module collaboration
c. Module connectivity
d. Module cohesive
Module coupling
_____ distributed database management systems (DDBMS) integrate multiple
instances of the same DBMS over a network.
Select one:
a. Heterogeneous
b. Combination
c. Homogeneous
d. Fully heterogeneous
Homogeneous
_____ extends SQL so that it can differentiate between access requirements for
data warehouse data and operational data.
Select one:
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller SUPERGRADES01. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.99. You're not tied to anything after your purchase.
