Questão 1
Questão
1. The process of creating an information system is known as ____ development.
Responda
-
A) systems
-
B) database
-
C) network
-
D) transformation
Questão 2
Questão
2. The process of database design and implementation is ____ development.
Responda
-
A) systems
-
B) databse
-
C) network
-
D) transformation
Questão 3
Questão
3. The primary objective of database design is ____
Responda
-
A) to create the most efficient database possible
-
B) to create complete, normalized, non-redundant, and fully integrated conceptual, logical, and physical database models.
-
C) to create the fastest queries
-
D) to be able to add data quickly
Questão 4
Questão
4. The traditional SDLC is divided into ____ phases.
Responda
-
A) two
-
B) three
-
C) four
-
D) five
Questão 5
Questão
5. The initial assessment and the feasibility study are part of the SDLC's ____ phase
Questão 6
Questão
6. User requirements, existing system evaluation, and logical system design are part of the ____ phase of the SDLC.
Questão 7
Questão
7. A detailed system specification is part of the ____ phase of the SDLC.
Questão 8
Questão
8. Coding, testing, and debugging are part of the ____ phase of the SDLC.
Questão 9
Questão
9. Installation and fine tuning are part of the ____ phase of the SDLC.
Questão 10
Questão
10. Evaluation, maintenance, and enhancement are part of the ____ phase of the SDLC.
Questão 11
Questão
11. The SDLC is most important to the ____.
Questão 12
Questão
12. “Should the existing system be replaced?” is a question that is asked during the ____ stage of the SDLC.
Responda
-
A) planning
-
B) analysis
-
C) implementation
-
D) maintenance
Questão 13
Questão
13. “What are the requirements of the current system’s end users?” is a question asked during the ____phase of the SDLC.
Responda
-
A) planning
-
B) analysis
-
C) implementation
-
D) maintenance
Questão 14
Questão
14. The logical systems design is created during the ____ phase of the SDLC.
Responda
-
A) planning
-
B) analysis
-
C) implementation
-
D) maintenance
Questão 15
Questão
15. The design of the system’s processes is completed during the ____ phase of the SDLC.
Questão 16
Questão
16. The database is loaded during the ____ phase of the SDLC.
Questão 17
Questão
17. There are ____ stages in the DBLC.
Responda
-
A) four
-
B) five
-
C) six
-
D) seven
Questão 18
Questão
18. The implementation of ____-produced applications tends to prolong the operational life of systems by making them easier to update and maintain.
Responda
-
A) database
-
B) network
-
C) CASE
-
D) design
Questão 19
Questão
19. Analyzing the company situation is part of the ____ phase of the DBLC.
Responda
-
A) database initial study
-
B) database design
-
C) implementation and loading, testing, and evaluation
-
D) operation
Questão 20
Questão
20. Creating the conceptual design and selecting DBMS software are part of the ____ phase of the DBLC.
Responda
-
A) database initial study
-
B) database design
-
C) implementation and loading
-
D) testing and evaluation
Questão 21
Questão
21. Installing the DBMS, creating the database, and loading or converting the data are part of the ____phase of the DBLC.
Responda
-
A) database initial study
-
B) database design
-
C) implementation and loading
-
D) testing and evaluation
Questão 22
Questão
22. Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.
Responda
-
A) database initial study
-
B) database design
-
C) implementation and loading
-
D) testing and evaluation
Questão 23
Questão
23. Producing the required information flow is part of the ____ phase of the DBLC.
Questão 24
Questão
24. The last step in the DBLC is ____.
Responda
-
A) maintenance and evolution
-
B) operation
-
C) testing and evaluation
-
D) implementation and loading
Questão 25
Questão
25. The first step in the DBLC is ____
Questão 26
Questão
26. The database initial study phase of the DBLC involves ____.
Responda
-
A) defining objectives
-
B) introducing changes
-
C) testing the database
-
D) installing the DBMS
Questão 27
Questão
27. The implementation and loading phase of the DBLC involves ____.
Responda
-
A) defining objective
-
B) introducing changes
-
C) testing the database
-
D) installing the DBMS
Questão 28
Questão
28. The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____.
Responda
-
A) data analysis and requirements
-
B) entity relationship modeling and normalization
-
C) data model verification
-
D) distributed database design
Questão 29
Questão
29. The conceptual design step that defines entities, attributes, and relationships is ____.
Responda
-
A) database analysis and requirements
-
B) entity relationship modeling and normalization
-
C) data model verification
-
D) distributed database design
Questão 30
Questão
30. The conceptual design step that identifies ER modules and validates insert, update, and delete rules is____.
Responda
-
A) database analysis and requirements
-
B) ER modeling and normalization
-
C) data-model verification
-
D) distributed database design
Questão 31
Questão
31. The conceptual design step that defines the DBMS and data model to use is ____.
Responda
-
A) database analysis and reuiqrements
-
B) ER modeling and normalization
-
C) data-model verifiction
-
D) distributed database design
Questão 32
Questão
32. ____ allow(s) physical access to areas by authorized personnel only.
Responda
-
A) physical security
-
B) password security
-
C) access rights
-
D) data encryption
Questão 33
Questão
33. Once the data has been loaded into the database, the ____ tests and fine-tunes the database for performance, integrity, concurrent access, and security constraints.
Questão 34
Questão
34. The maintenance and evolution phase of the DBLC involves ____.
Responda
-
A) defining objectives
-
B) introducing changes
-
C) testing the database
-
D) installing the DBMS
Questão 35
Questão
35. The first step in developing the conceptual model using ER diagrams is to ____.
Responda
-
A) normalize the entities
-
B) complete the initial ER diagram
-
C) identify, analyze, and refine the business rules
-
D) define the attributes, primary keys, and foreign keys for each of the entities
Questão 36
Questão
36. The first step in the ER model verification process is to ____.
Responda
-
A) identify each module and its components
-
B) identify the ER model's central entity
-
C) verify all processes against the ER model
-
D) identify each module's internal transaction requirements
Questão 37
Questão
37. ____ coupling describes the extent to which modules are independent of one another.
Responda
-
A) verification
-
B) process
-
C) module
-
D) cohesive
Questão 38
Questão
38. The ____ design is the process of selecting the data storage and data access characteristics of the database.
Responda
-
A) time
-
B) network
-
C) logical
-
D) physical
Questão 39
Questão
39. There are ____ classical approaches to database design.
Responda
-
A) two
-
B) three
-
C) four
-
D) five
Questão 40
Questão
40. During decentralized design, after the ____ process has been completed, all modules are integrated into one conceptual model.
Responda
-
A) initial
-
B) verification
-
C) conceptual
-
D) logical