Quiz2 Flashcards
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.
a. programmer
b. manager
c. database administrator
d. systems administrator
c. database administrator
__ is the process that establishes the need for an information system and its extent.
a. Information system
b. Database development
c. Systems analysis
d. Systems development
c. Systems analysis
As a database designer, which of the options below would you not include in the implementation phase of a database design?
a. Loading data into the database
b. Designing the database
c. Creating the database storage structure
d. Providing for data management
b. Designing the database
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
b. analysis
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.
a. Advantages
b. Profitability
c. Benefits
d. Limitations
d. Limitations
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.
a. DBMS hardware requirements
b. DBMS features and tools
c. The original purchase price
d. Underlying model
b. DBMS features and tools
The first stage in the database design process is __?
a. Physical design
b. Conceptual design
c. Logical design
d. Linear design
b. Conceptual design
The first step of the conceptual design is __?
a. Data analysis and requirements
b. Distributed database design
c. Entity relationship modeling and normalization
d. Data model verification
a. Data analysis and requirements
The logical systems design is created during the _____ phase of the Systems Development Life Cycle (SDLC).
a. planning
b. analysis
c. implementation
d. maintenance
b. analysis
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 __.
a. Systems analysis
b. Database analysis
c. Systems development.
d. Information system
c. Systems development.
As a database designer, the first step that you would take in creating the logical design is to ___ the conceptual model.
a. Split
b. Map
c. Adopt
d. Approve
b. Map
Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC).
a. database design
b. database initial study
c. implementation and loading
d. testing and evaluation
a. database design
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
d. installing the DBMS
The Systems Development Life Cycle (SDLC) is divided into __ phases.
a. Four
b. Two
c. Six
d. Five
d. Five
Which of the following is a hardware-induced database failure?
a. Memory chip errors
b. Viruses
c. Malware
d. Abortion due to deadlock
a. Memory chip errors
