Sunday, November 30, 2014

Data Warehousing

1. 
Data scrubbing is which of the following?
A.A process to reject data from the data warehouse and to create the necessary indexes
B.A process to load the data in the data warehouse and to create the necessary indexes
C.A process to upgrade the quality of data after it is moved into a data warehouse
D.A process to upgrade the quality of data before it is moved into a data warehouse
2. 
The @active data warehouse architecture includes which of the following?
A.At least one data mart
B.Data that can extracted from numerous internal and external sources
C.Near real-time updates
D.All of the above.
3. 
A goal of data mining includes which of the following?
A.To explain some observed event or condition
B.To confirm that data exists
C.To analyze data for expected relationships
D.To create a new data warehouse
4. 
An operational system is which of the following?
A.A system that is used to run the business in real time and is based on historical data.
B.A system that is used to run the business in real time and is based on current data.
C.A system that is used to support decision making and is based on current data.
D.A system that is used to support decision making and is based on historical data.
5. 
A data warehouse is which of the following?
A.Can be updated by end users.
B.Contains numerous naming conventions and formats.
C.Organized around important subject areas.
D.Contains only current data.

Saturday, November 29, 2014

The Client-Server Database

1. 
Which of the following statements is true about symmetric multiprocessing?
A.A single copy of the operating system resides in each processor.
B.Useful for situations where data must remain in memory to process.
C.Bottlenecks increase with uniprocessor systems because tasks are not shared.
D.The problems of memory contention are unlikely.
2. 
Which of the following items are not necessary for client/server?
A.Assure that tools will connect with middleware.
B.Understand the requirements.
C.Determine network bandwidth capabilities.
D.Include the use of a file server.
3. 
A benefit of the three-tier architecture is which of the following?
A.New modules can be built to support specific business needs
B.Performance improves for compiled SQL statements
C.Results in a thinner client and database server
D.All of the above.
4. 
Which of the following statements is true concerning JDBC?
A.It is language independent.
B.It is similar in concept to ODBC.
C.It is useful for all object-oriented languages.
D.It consists of three main layers.
5. 
A characteristic of a file server is which of the following?
A.Manages file operations and is shared on a network.
B.Manages file operations and is limited to one PC.
C.Acts as a fat client and is shared on a network.
D.Acts as a fat client and is limited to one PC.

Friday, November 28, 2014

Physical Database Design

1. 
If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
A.All fields are stored in one relation.
B.All fields are stored in two relations.
C.All fields are stored in three relations.
D.All fields are stored in four relations.

2. 
Selecting a data type involves which of the following?
A.Maximize storage space
B.Represent most values
C.Improve data integrity
D.All of the above.
3. 
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
A.VARCHAR2B.CHAR
C.LONGD.NUMBER
4. 
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
A.All fields are stored in one relation.
B.All fields are stored in two relations.
C.All fields are stored in three relations.
D.All fields are stored in four relations.
5. 
Which of the following is an advantage of partitioning?
A.Complexity
B.Inconsistent access speed
C.Extra space
D.Security

Wednesday, November 26, 2014

ER Model and Business Rules

1. 
An action assertion must include which of the following?
A.Anchor object
B.Action
C.Corresponding object
D.All of the above
2. 
An oval represents which of the following in an EER?
A.Attribute
B.Entity
C.Optional One
D.Relationship
3. 
Inheritance is which of the following?
A.When a supertype entity inherits values of the subtype attribute
B.When a subtype entity inherits values of the supertype attribute
C.When a supertype entity inherits values of another supertype attribute
D.When a subtype entity inherits values of another subtype attribute
4. 
When an entity instance must be a member of only one subtype, it is which of the following?
A.Disjoint with total specialization
B.Disjoint with partial specialization
C.Overlap with total specialization
D.Overlap with partial specialization
5. 
A supertype/subtype hierarchy is which of the following?
A.Each subtype has only one attribute.
B.Each supertype has only one attribute.
C.Each subtype has only one supertype.
D.Each supertype has only one subtype.

Tuesday, November 25, 2014

The Database Development Process

1. 
Which of the following database activities allow for the actual retrieval and use of a database?
A.Enterprise modeling
B.Logical database design
C.Physical database design and definition
D.Database implementation
2. 
The three-schema components include all, but:
A.internal schema.
B.conceptual schema.
C.programming schema.
D.external schema.
3. 
Which is not a type of data management technology?
A.RelationalB.Rational
C.Object-orientedD.Dimensional
4. 
Which is not a relevant feature of CASE tools?
A.The ability to help draw data models using entity-relationship notations
B.The ability to generate code
C.An information repository
D.Access to a DB via the Internet
5. 
The first step in database development is which of the following?
A.Enterprise data modeling
B.Logical database design
C.Physical database design and definition
D.Database Implementation
6. 
Which of the following database activities determines the entities, attributes, and relationships of data?
A.Conceptual data modeling
B.Logical database design
C.Physical database design and definition
D.Database implementation
7. 
The use of packaged data models can offer which of the following benefits?
A.Reduce implementation time and costs
B.Higher quality models
C.Both A and B.
D.Neither A nor B.
8. 
The Enterprise tier of the three-tiered database architecture includes:
A.managing the data.
B.managing the User-system interface.
C.processing HTTP protocol.
D.processing scripting tasks.
9. 
An entity type is which of the following?
A.A major category of data about people, place, and things
B.The various departments of an organization
C.The application software
D.The business processes the support the mission of an organization
10. 
Strategic Planning factors do not include which of the following?
A.Organizational goals
B.Critical success factors
C.Information engineering
D.Problem areas