1. Systems analysis establishes the need for an information system and its extent.
True
2. The term “database development” is used to describe the process of database design and implementation.
True
3. The Systems Development Life Cycle (SDLC) traces the history of an organization’s system.
False
4. . The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging.
False
5. The overall purpose of the database initial study is to create the conceptual design.
False
6. . In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.
True
7. . Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.
True
8. Logical design is the first stage in the database design process.
False
9. The designer does not need to have a thorough understanding of the company’s data types, their extent, and uses to be able to develop an accurate data model.
False
10. The selection of DBMS software is critical to the information system’s smooth operation.
True
11. The first step in creating the logical design is to map the conceptual model to the chosen
database constructs.
True
12. Josh is a database designer, which of the options below is not one of the primary objectives that he should consider in designing a database?
Create illogical database models
13. As a database designer, which of the options below would you not include in the implementation phase of a database design?
Designing the database
14. The process of creating an information system is known as _____.
Systems development
15. Which of the answers below is part of the composition of an information system?
Hardware
16. __ is the process that establishes the need for an information system and its extent.
Systems analysis
17. Jody is designing a new database for a client; she would like to let the client know that the performance of an information system depends on the following factors except:
Database software and implementation
18. __ is the process of creating an information system.
Systems development
19. As a database developer, you could interpret that the term database development describes the process of __?
Database design and implementation.
20. Joe is a database designer; his team is designing a database for a client. They should not consider ___ as one of the considerations to be taken as they design and implement the database.
Impenetrability over time
21. As a database architect, you usually explain that applications transform data into the information that forms the basis for decision making within the framework of __.
Systems development.
22. ___ provides object-oriented tools to support the tasks associated with the development of information systems.
Unified Modeling Language (UML)
23. Anna leads a team of database designers and developers, she uses ___ because it is an iterative and incremental methodology that focuses on continuing improvement toward priority deliverables.
SCRUM
24. In the detailed systems design phase, the designer __?
Completes the design of the system’s processes
25. Jude is an experienced systems developer; Jude wants to make the system that they are developing a more efficient information generator during the detailed systems design phase of the Systems Development Life Cycle (SDLC). Which of the options below is not included in the necessary technical specification to help Jude achieve this?
Keyboard
26. Jose wants to load his organization’s database content; he can load the content interactively or in batch mode using a variety of methods and devices including the options below except?
Network interface programs
27. The options below are advantages of the computer-aided software engineering(CASE)-produced applications except?
CASE incurs unreasonable cost
28. Callie is an end-user. Callie might request the types of generated system maintenance activities below except:
Standardized maintenance
29. The Systems Development Life Cycle (SDLC) is divided into __ phases.
Five
30. Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC).
analysis
31. “Should the existing system be replaced?” is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC).
planning
32. “What are the requirements of the current system’s end users?” is a question you ask during the _____ phase of the Systems Development Life Cycle (SDLC).
analysis
33. The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).
analysis
34. As a systems developer, you load the database contents during the _____ phase of the Systems Development Life Cycle (SDLC).
implementation
35. Evaluation, maintenance, and enhancement are done during the __ phase of the Systems Development Life Cycle (SDLC).
maintenance
36. Rick’s team is creating a new database for a client. what is the next phase for his team in DBLC, after the database initial study is done?
database design
37. The maintenance and evolution phase of the Database Life Cycle (DBLC) involves _____.
introducing changes
38. Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).
database design
39. . Producing the required information flow is part of the _____ phase of the Database Life Cycle (DBLC).
operation
40. . As a database analyst, what technique would you use to create logical representations of computing resources that are independent of the underlying physical computing resources.
Virtualization
41. The implementation and loading phase of the Database Life Cycle (DBLC) involves _____.
installing the DBMS
42. . In the context of the database design process, Angie, the database designer, could use the ____ as the conceptual design step to define the fragmentation and allocation strategy.
distributed database design
43. .In the context of the database design process, Jasmine, the database designer could use ____ as the conceptual design step that determines end-user views, outputs, and transaction-processing requirements.
data analysis and requirements
44. Julie is a database administrator, she can use _____ to render data useless to unauthorized users who might have violated some of the database security layers.
Data encryption
45. . In a situation whereby the data has been loaded into the database, John, the _____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.
database administrator
46. In a(n) _____, only the objects that have been updated or modified since the last full backup are backed up.
differential backup
47. Which of the following is a hardware-induced database failure?
Memory chip errors
48. During the kickoff meeting for a new database project, the project lead might explain that the database design will consist of __ stages.
Three
49. The first stage in the database design process is __?
Conceptual design
50. The first step of the conceptual design is __?
Data analysis and requirements
51. Below are some of the efforts that the designer focuses on during the data analysis and requirement step of the conceptual design except __?
Information design
52. The designer must identify the company’s business rules and analyze their impact on the nature, role, and __ of data.
Scope
53. The database designer is working on creating the Entity Relationship model, but before doing so, the designer must ___ and enforce appropriate standards to be used in the documentation of the design.
Communicate
54. Communications failures often lead to __ work.
Poor design
55. Well-defined and enforced standards make design work __?
Easier
56. A module is an information system component that handles __business function.
A specific
57. The term __ describes the strength of the relationships found among the module’s entities.
Module cohesivity
58. The term __ describes the extent to which modules are independent of one another.
Module coupling
59. A __ is a subset of a database that is stored at a given location.
Database fragment
60. One of the factors that affect purchasing decisions is __. This means considering if a DBMS can be portable across platforms, systems, and languages.
Portability
61. Pete is database consultant, in considering ___ as part of the factors that will affect the purchasing decision of a DBMS, items to consider include processor(s), RAM, and disk space.
Portability
62. As one of the stakeholders of a company, which of the factors below will affect your company’s purchasing decision of a DBMS?
Cost
63. Jerry is a stakeholder in ABC company, he is considering ___ as one of the factors that will affect ABC company’s purchasing decision of a DBMS, the items that he should consider include: some database software’s variety of tools that facilitate application development.
DBMS features and tools
64. During the kickoff meeting for a new database project, which of the models below can John, the team lead indicate that the database can be based on?
Graph data model
65. For Jared, a database consultant, to avoid false expectations, he must make the end user aware of the ___ of both the DBMS and the database.
Limitations
66. In a scenario during decentralized design, after the _____ has been completed, all modules are integrated into one conceptual model.
verification process
67. Tony is a database designer; in what stage of the database design process will he implement the logical design?
Second
68. As a database designer, the first step that you would take in creating the logical design is to ___ the conceptual model.
Map
69. As a database designer, you would use the logical design to translate the software-independent conceptual model into a ___ model.
Software-dependent
70. Siddarth is rounding up the logical design process, his final step is to ___ all logical model definitions against all end-user data, transaction, and security requirements.
Validate
71. As a database designer, you should ensure that the logical design contains only properly normalized ___.
Tables
Other Links:
See other websites for quiz:
Check on QUIZLET