CIS 3352 - Database Management - Final Study

Ace your homework & exams now with Quizwiz!

1. The process of creating an information system is known as . a. systems development b. database development c. network development d. enterprise development

ANSWER: a

10. In star schema representation, a fact table is related to each dimension table in a relationship. a. many-to-one (M:1) b. many-to-many (M:M) c. one-to many (1:M) d. one-to-one (1:1)

ANSWER: a

12. When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____. a. symbols b. attributes c. images d. tables

ANSWER: a

14. A schema is a type of star schema in which dimension tables can have their own dimension tables. a. snowflake b. starflake c. dimension d. matrix

ANSWER: a

14. An entity is said to be -dependent if it can exist in the database only when it is associated with another related entity occurrence. a. existence b. relationship c. business d. data

ANSWER: a

15. Analyzing the company situation is part of the phase of the Database Life Cycle (DBLC). a. database initial study b. database design c. testing, and evaluation d. operation

ANSWER: a

16. The reliance on as the design methodology for relational databases is seen as a stumbling block to its use in OLAP systems. a. normalization b. denormalization c. star schema d. multidimensional schema

ANSWER: a

17. A(n) plan is a set of instructions generated at application compilation time that predetermines how the application will connect to and communicate with the database at run time. a. access b. completion c. application d. communications

ANSWER: a

18. extends SQL so that it can differentiate between access requirements for data warehouse data and operational data. a. ROLAP b. OLAP c. DBMS d. BI

ANSWER: a

19. A relationship exists when an association is maintained within a single entity. a. unary b. ternary c. strong d. weak

ANSWER: a

19. The last step in the Database Life Cycle (DBLC) is . a. maintenance and evolution b. operation c. testing and evaluation d. implementation and loading

ANSWER: a

2. Operational data are commonly stored in many tables, and the stored data represent information about a given only. a. transaction b. database c. table d. concept

ANSWER: a

21. The database initial study phase of the Database Life Cycle (DBLC) involves . a. defining objectives b. introducing changes c. testing the database d. installing the DBMS

ANSWER: a

23. The entity relationship model uses the associative entity to represent a(n) relationship between two or more entities. a. M:N b. 1:M c. N:1 d. M:1

ANSWER: a

28. Complex requirements may dictate data transformations, and they may expand the number of entities and attributes within the design. a. information b. entity c. design d. processing

ANSWER: a

3. A(n) is the set of possible values for a given attribute. a. domain b. range c. identifier d. key

ANSWER: a

3. When introducing a database into an organization, the database approach creates a more controlled and structured information flow and thus affects people, functions, and interactions. This leads to a(n) impact of the new database system. a. cultural b. managerial c. technical d. operational

ANSWER: a

3. nt and the feasibility study are part of the Systems Development Life Cycle's (SDLC's) phase. a. planning b. analysis c. detailed systems design d. implementation

ANSWER: a

5. A attribute can be further subdivided to yield additional attributes. a. composite b. simple c. single-valued d. multivalued

ANSWER: a

6. Bill Inmon and Chuck Kelley created a set of 12 rules to define a(n) . a. data warehouse b. multidimensional cube c. OLAP tool d. star schema

ANSWER: a

7. "Should the existing system be replaced?" is a question that is asked during the stage of the Systems Development Life Cycle (SDLC).a. planning b. analysis c. implementation d. maintenance

ANSWER: a

9. The role of a DBA covers activities that involve evaluating, selecting, installing, and maintaining a DBMS and its related utilities and applications. a. technical b. administrative c. managerial d. interactive

ANSWER: a

In the context of the data-information-decision cycle, decisions made by high-level managers trigger actions in an organization's: a. lower levels. b. top levels. c. target markets. d. customer base.

ANSWER: a

1. From a data analyst's point of view, decision support data differ from operational data in three main areas: time span, granularity, and . a. usability b. dimensionality c. transaction processing d. sparsity

ANSWER: b

10. A relationship is an association between . a. objects b. entities c. databases d. fields

ANSWER: b

10. are general statements of direction or action that communicate and support DBA goals. a. Standards b. Policies c. Guidelines d. Procedures

ANSWER: b

11. are more detailed and specific than policies and describe the minimum requirements of a given DBA activity. a. Guidelines b. Standards c. Procedures d. Documentations

ANSWER: b

13. "All users must have passwords" is an example of a . a. rule b. policy c. standard d. procedure

ANSWER: b

13. In a typical star schema, each dimension record is related to thousands of records. a. attribute b. fact c. key d. primary

ANSWER: b

16. A entity has a primary key that is partially or totally derived from the parent entity in the relationship. a. strong b. weak c. business d. child

ANSWER: b

16. Selecting database management system (DBMS) software is part of the phase of the Database Life Cycle (DBLC). a. database initial study b. database design c. implementation and loading d. testing and evaluation

ANSWER: b

17. Decision support data tend to be non-normalized,_________, and pre-aggregated. a. unique b. duplicated c. optimized d. sorted

ANSWER: b

17. The existence of a(n) entity indicates that its minimum cardinality is zero. a. ternary b. optional c. strong d. weak

ANSWER: b

18. _____ activities cover all tasks directly related to the day-to-day operations of the DBMS and its applications. a. Backup and recovery b. System support c. Performance monitoring and tuning d. Security auditing and monitoring

ANSWER: b

2. At the level of middle management, the database must be able to . a. provide a framework for defining and enforcing organizational policies b. provide the data necessary for tactical decisions and planning c. provide feedback to monitor whether a company is achieving its goals d. provide access to external and internal data to identify growth opportunities

ANSWER: b

2. The notation of entity-relationship modelling can be used for both conceptual and implementation modelling. a. Bachman b. UML c. Chen d. Crow's Foot

ANSWER: b

20. In DBLC, the phase after the database initial study is . a. operation b. database design c. database initial study d. implementation and loading

ANSWER: b

20. User-access management is a subset of . a. password protection b. authorization management c. data integrity management d. managerial control

ANSWER: b

21. An multidimensional database management systems (MDBMS) uses proprietary techniques to store data in n-dimensional arrays. a. table-like b. matrix-like c. network-like d. cube-like

ANSWER: b

22. A _____ is a dynamic table that not only contains the SQL query command to generate the rows, but also stores the actual rows. a. SQL view b. materialized view c. star schema d. data cube

ANSWER: b

22. To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent relationships whenever possible. a. unary b. binary c. strong d. weak

ANSWER: b

22. is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources. a. Normalization b. Virtualization c. Specialization d. Generalization

ANSWER: b

25. The first step in building an entity-relationship diagram (ERD) is . a. developing the initial ERD b. creating a detailed narrative of the organization's description of operations c. identifying the attributes and primary keys that adequately describe the entities d. identifying the business rules based on the description of operations

ANSWER: b

4. Discovery of user requirements, existing system evaluation, and logical system design are part of the phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. detailed systems design d. implementation

ANSWER: b

4. Ideally, an entity identifier is composed of attribute(s). a. three b. one c. two d. six

ANSWER: b

4. The person responsible for the control of the centralized and shared database is the database . a. analyst b. administrator c. programmer d. user

ANSWER: b

5. Database administration operations are commonly defined and divided according to the phases of the . a. SLA b. DBLC c. SDLC d. MRA

ANSWER: b

5. can serve as a test vehicle for companies exploring the potential benefits of data warehouses. a. Data networks b. Data marts c. Data cubes d. OLAPs

ANSWER: b

6. A attribute is one that cannot be subdivided. a. composite b. simple c. single-valued d. multivalued

ANSWER: b

7. The administrator is responsible for strategic planning. a. system b. data c. database d. program

ANSWER: b

7. The conceptual model can handle relationships and multivalued attributes. a. 1:1 b. M:N c. 1:M d. 1:N

ANSWER: b

8. "What are the requirements of the current system's end users?" is a question asked during the phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. implementation d. maintenance

ANSWER: b

8. A derived attribute is indicated in the Chen notation by a that connects the attribute and an entity. a. single line b. dashed line c. double dashed line d. double line

ANSWER: b

9. The decision to store attributes in database tables depends on the processing requirements and the constraints placed on a particular application. a. multivalued b. derived c. single-valued d. composite

ANSWER: b

9. The logical systems design is created during the phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. implementation d. maintenance

ANSWER: b

11. The design of the system's processes is completed during the phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. detailed systems design d. implementation

ANSWER: c

12. Fact and dimension tables are related by keys. a. shared b. primary c. foreign d. linked

ANSWER: c

12. The database contents are loaded during the phase of the Systems Development Life Cycle (SDLC). a. analysis b. detailed systems design c. implementation d. maintenance

ANSWER: c

13. There are stages in the Database Life Cycle (DBLC). a. four b. five c. six d. seven

ANSWER: c

14. The implementation of applications tends to prolong the operational life of systems by making them easier to update and maintain. a. database-produced b. network-produced c. CASE-produced d. design-produced

ANSWER: c

16. Which of the following is a reason why a DBMS's daily operations must be clearly documented? a. Documentation of the daily operations help a company set its long-term goals. b. Documentation of the daily operations help manage the manual data resources of a company. c. Documentation of the daily operations help pinpoint causes and solutions of database problems. d. Documentation of the daily operations help free the DBA from many lower-level technology-oriented tasks.

ANSWER: c

17. Installing the DBMS, creating the database, and loading or converting the data are part of the phase of the Database Life Cycle (DBLC). a. database initial study b. database design c. implementation and loading d. testing and evaluation

ANSWER: c

18. Producing the required information flow is part of the phase of the Database Life Cycle (DBLC). a. database initial study b. database design c. operation d. testing and evaluation

ANSWER: c

18. The Crow's foot symbol with two vertical parallel lines indicates cardinality. a. (0,N) b. (1,N) c. (1,1) d. (0,1)

ANSWER: c

20. A relationship exists when three entities are associated. a. unary b. strong c. ternary d. weak

ANSWER: c

20. Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube known as a . a. multi-cube b. database cube c. data cube d. hyper cube

ANSWER: c

3. The schema must support complex (non-normalized) data representations. a. snowflake b. online analytical processing c. decision support database d. multidimensional database

ANSWER: c

6. A data administrator is also known as a(n) . a. data security officer b. systems administrator c. information resource manager d. information engineering officer

ANSWER: c

8. Computed or derived facts, at run time, are sometimes called to differentiate them from stored facts. a. schemas b. attributes c. metrics d. dimensions

ANSWER: c

9. In a star schema, attributes are often used to search, filter, or classify . a. tables b. sales c. facts d. dimensions

ANSWER: c

1. The entity relationship diagram (ERD) represents the database as viewed by the end user. a. condensed b. physical c. logical d. conceptual

ANSWER: d

10. The feasibility study during the planning phase of the Systems Development Life Cycle (SDLC) must address the: a. requirements of the current system's end users. b. problems and constraints related to the company situation. c. questions about modification and replacement of existing system. d. technical aspects of hardware and software requirements.

ANSWER: d

11. The attribute hierarchy provides a top-down data organization that is used for two main purposes: and drill-down/roll-up data analysis. a. decomposition b. de-normalization c. normalization d. aggregation

ANSWER: d

11. expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity. a. Connectivity b. Relationship c. Dependence d. Cardinality

ANSWER: d

12. are written instructions that describe a series of steps to be followed during the performance of a given activity. a. Policies b. Standards c. Guidelines d. Procedures

ANSWER: d

13. Knowing the minimum and maximum number of occurrences is very helpful at the application software level. a. object b. attribute c. data d. entity

ANSWER: d

14. Instructions to create a password are an example of a . a. rule b. policy c. standard d. procedure

ANSWER: d

15. "A password must have a minimum of five characters" is an example of a . a. policy b. rule c. procedure d. standard

ANSWER: d

15. If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n) entity. a. weak b. alone c. unary d. strong

ANSWER: d

15. _____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time. a. Normalization b. Meta modeling c. Replication d. Partitioning

ANSWER: d

19. A index is based on 0 and 1 bits to represent a given condition. a. logical b. multidimensional c. normal d. bitmapped

ANSWER: d

19. _____ 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. a. Integrity b. Compliance c. Availability d. Confidentiality

ANSWER: d

2. The traditional Systems Development Life Cycle (SDLC) is divided into phases. a. two b. three c. four d. five

ANSWER: d

21. If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a relationship. a. self b. self-referring c. looping d. recursive

ANSWER: d

21. In the context of database usage monitoring, a(n) is a file that automatically records a brief description of the database operations performed by all users. a. change tracker b. digital footprint c. paper trail d. audit log

ANSWER: d

23. The implementation and loading phase of the Database Life Cycle (DBLC) involves . a. defining objectives b. introducing changes c. testing the database d. installing the DBMS

ANSWER: d

24. When using the Crow's Foot notation, the associative entity is indicated by relationship lines between the parents and the associative entity. a. dotted b. double c. triple d. solid

ANSWER: d

26. If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be the DEPARTMENT entity. a. existence-dependent on b. independent of c. mandatory for d. optional to

ANSWER: d

27. In organizations that generate large number of transactions, are often a top priority in database design. a. relationships among entities b. logical design standards c. naming conventions d. high processing speeds

ANSWER: d

4. Data implies that all business entities, data elements, data characteristics, and business metrics are described in the same way throughout the enterprise. a. visualization b. analytics c. mining d. integration

ANSWER: d

5. Coding, testing, and debugging are part of the phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. detailed systems design d. implementation

ANSWER: d

6. Installation and fine tuning are part of the phase of the Systems Development Life Cycle (SDLC). a. planning b. analysis c. detailed systems design d. implementation

ANSWER: d

7. The basic star schema has four components: facts, , attributes, and attribute hierarchies. a. keys b. relationships c. cubes d. dimensions

ANSWER: d

8. Coordinating, monitoring, and allocating database administration resources is included in a DBA's role. a. operative b. arbitration c. technical d. managerial

ANSWER: d


Related study sets

High School Health Quiz 3 unit 1 - Body Essentials QUIZ'S

View Set

Post Test: Electric and Magnetic Forces

View Set

Chapter 8 Social Processes , Attitudes, and Behavior

View Set

Entreculturas 3 Unidad 4 ASD 6- 10 y expresiones útiles

View Set