29. One of the following critical resources needs to be considered in system infrastructure design plan for any system development:
A) Procedure
B) Time requirement
C) Network and Hardware resources
D) Performance of user
30. Among the following, which one is used for communication between the web server and the database server?
A) Native support
B) Common Gateway Interface (CGI) script
C) Middleware
D) Java Database Connectivity (JDBC)
31. Assume that you are asked to design the logical view of the database for ABC PLC. As a database expert which one clearly shows the skeleton structure that defines how the data is organized and how the relationships are associated?
A) Database Manipulation
B) Database Schema
C) Database Retrieval
D) Database Architecture
32. Which process involves developing an approximation of the cost of resources needed to complete a project?
A) Finalizing the cost baseline
B) Estimating costs
C) Controlling costs
D) Determining the budget
33. Which one of the following is the feature of the database?
A) Lack of authentication
B) Store data in multiple locations
C) User interface provided
D) No backup for the data stored
34. Commercial Bank of Ethiopia would like to distribute to all branches about business applications across multiple locations and computer systems, reserving the data center for web server, database, and telecommunications function. This is example of:
A) Technology Architecture Planning
B) Enterprise Resource Planning (ERP)
C) Applications Architecture Planning
D) Strategic Planning
35. Which two features of OOP are the same?
A) Encapsulation and Polymorphism
B) Inheritance and Encapsulation
C) Encapsulation and Abstraction
D) Abstraction and Polymorphism
36. The process finding the defect and suggesting improvements about the system quality is:
A) Prevent and Recovery
B) Total Quality Management
C) Quality Planning
D) Process Management
37. From computer maintenance procedures which one is the process of recognizing the data stored on the hard drive so that related pieces of data are put back together, all lined up in a continuous fashion:
A) Defragmenter
B) Disk formatter
C) Antivirus
D) Memory Partitioning
38. Mr. Alemu was ICT technician for ABC PLC. He is responsible for interpreting system requests and specifications, site preparation and user training, and contact point for customers. This skill is:
A) Team management
B) Customer relations
C) Leadership
D) Conflict Management
39. You are a database developer for an insurance company. One and only one product manager manage every insurance policy. One product manager can manage many policies. How can you represent that information in the database?
A) Create another entity, which contains policy ID and the manager ID
B) Include the manager ID in the Policies entity
C) Include the manager ID in the policies entity and the policy ID in the manager's entity
D) Include the policy ID in the Managers entity
40. The horizontal bar chart that depicts project task against the calendar:
A) Manning
B) Functional break down
C) Budget breaks down
D) Schedule
41. The last step of the analyst's approach to problem solving is:
A) Decide which solution is best, and make a recommendation
B) Verify that the benefits of solving the problem outweigh the costs
C) Monitor to make sure that you obtain the desired results
D) Implement the solution
42. Which one of the following is included in web and database need strategy?
A) Evaluate current financial requirement
B) Evaluate the impact of changes
C) Business benefit
D) People involvement
Answer (2)
The answers to the questions focus on various aspects of computers and technology, including system design resources, database communication, project costing, and OOP principles. The selected choices reflect best practices and fundamental concepts in technology management and database organization. Overall, understanding these concepts is essential for effective IT project management and database development.
;
C) Network and Hardware resources Critical resources in system infrastructure design include network and hardware resources, essential for ensuring the system can meet performance and connectivity requirements.
C) Middleware Middleware acts as an intermediary that facilitates communication between the web server and the database server.
B) Database Schema A database schema defines the logical layout of the database elements, organizing data and specifying relationships.
B) Estimating costs This process involves predicting the cost of resources necessary for a project's completion.
C) User interface provided A key feature of databases is the provision of a user interface for data access and manipulation.
A) Technology Architecture Planning This scenario exemplifies designing technology architecture for distributing applications across various locations.
C) Encapsulation and Abstraction Both encapsulation and abstraction are fundamental concepts in object-oriented programming aimed at hiding complexity.
B) Total Quality Management The process of finding defects and suggesting system quality improvements is part of total quality management.
A) Defragmenter This process reorganizes fragmented data to improve hard drive efficiency.
B) Customer relations Mr. Alemu's roles signify skills in customer relations, crucial for interpreting requests and bridging communication.
B) Include the manager ID in the Policies entity Since one manager can oversee many policies, the manager ID is stored in the Policies table to represent the relationship.
D) Schedule The horizontal bar chart indicating project tasks against the calendar is a Gantt chart, used for scheduling.
C) Monitor to make sure that you obtain the desired results The final step involves monitoring the outcomes to ensure the solution is effective.
C) Business benefit Web and database strategy consider the business benefits, crucial for aligning with organizational objectives.
