CIS 3352 - Database Management - Final Study
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
