Mekdella College Gambella

Security and Database Management IT Coc Model Exam test

IT COC out 30%
1. Commercial Bank of Ethiopia would like to distribute to all branches applications across
multiple locations and computer systems, reserving the data center for webserver, database,
and telecommunications functions. This example of:-
A. Technology Architecture planning
B. Applications Architecture planning
C. Enterprise resource planning
D. Strategic planning
2. The process finding the defect and suggesting improvements about the system quality
A. Total quality management
B. Prevent and recovery
C. Quality planning
D. Process Management
3. From computer maintenance procedures which one is the process of organizing the data
shared on hard drive so that related pieces of data are put together, all lined up in a sequences.
A. Fragmented
B. Disk Formatter
C. Antivirus
D. Memory partitioning
4. From computer maintenance procedures which one is the process of reorganizing the data
shared on hard drive so that related pieces of data are put back together, all lined up in a
continuous fashion.
A. Chemical
B. Malware
C. Defragmenter
D. Antivirus
5. You are a database developer for the insurance company. Every insurance policy is managed by
one and only product manager. One product 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 manager entity
6. 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
7. One of the following is included in web database need strategy
A. Evaluate current financial requirement
B. Evaluate impact of changes
C. Business Benefit
D. People involvement
8. Which of the following is a display unit that acts an interface between the user and the
computer?
A. Printer
B. Mother
C. Mouse
 D. Monitor
9. The step in developing a plan is _________________
A. Putting the plan into action
B. Situation Analysis
C. Prioritization of problems
D. Setting the organizational objectives
10. Which two features of object-oriented programming are the same?
A. Polymorphism and encapsulation features are the same
B. Encapsulation and Abstraction
C. Abstraction and polymorphism features are the same
D. Inheritance and Encapsulation
11. The horizontal bar chart that objects project task against the calendar
A. Schedule
B. Manning
C. Functional breakdown
D. Budget breakdown
12. Database regression test can be done
A. Occasionally
B. Sometimes
C. Not Required
D. Regular basis
13. Which of the following CSS selectors are used to specify a group of elements?
A. ID
B. Class
C. Tag
D. Collector
14. Which of the following is the correct syntax to link an external style sheet in the HTML files?
A. <linkrel=”stylesheet”scr=”style.css”>
B. <linkrel=”stlesheet”href=”style.css”/>
C. <stylerel=”stylesheet”scr=”style.css”/>
D. <style rel=”style sheet” link=style.css”/>
15. Which one of the following refer to the division of a system into processes or subsystems
A. Data management
B. System design
C. Functional decomposition
D. Programming
16. Which of the following is generally used for performing tasks like creating the structure of the
relations, deleting relation?
A. DML (Data Manipulation Language)
B. DCL (Data control Language)
C. DDL(Data Definition language)
D. Relational Schema
17. Which of the following is the Overall program of the computer system?
A. OS (Operating System)
B. Application Software
C. Database System
D. Hardware system
18. Unnecessary conveyance of products, from one location to another, or handoff from one
employee to another is?
A. Transport waste
B. Waiting-time waste
C. Over-production waste
 D. Processing waste
19. Which of the following is not common in conducting an applied research regarding the
improvement of an ICT infrastructure in an organization?
A. Maintain a positive attitude for your research area
B. Reporting your findings to an appropriate person
C. Organizational needs and selection criteria are taken for granted
D. Acknowledge others to communicate with you verbally and non-verbally
20. Mrs. Selamawit is a database manager at XYZ Company. He is required to plan and overall
works done in his respective responsibility. Then, which task is going to be executed at last by
Mrs. Selamawit?
A. Implementation of the work plan outlined
B. Setting the organizational objectives
C. Reviewing and evaluating work plans and activities as per the set plan
D. Escalation of problems
21. Over a period of time, a system failure may result in a program crash and/or loss of data. As an
IT expert, you are called to restore system files and to restart the system. Which of the following
best describes this activity?
A. System enhancement
B. Technical support
C. Program Maintenance
D. System recovery
22. A database user who maintains a database management and necessarily responsible for locking
after its overall usage and apply limitations to maintain isolation enforce security is
A. Database Administrators
B. Database Architects
C. Database designers
D. End Users
23. A security Mechanism used in data communication environment to filter the packets forwarded
to and from the network is referred to be:
A. Biological Biometrics
B. Firewall
C. Cryptography
D. Encryption
24. A person or organizational that has an interest in system or is impacted by the system?
A. Database Admin
B. Network Admin
C. System Analyst
D. Stakeholder
25. A copy of database is called
A. Instance
B. Mailbox
C. Alias
D. Sandbox
26. It is a video transmission interface that offers better resolution than the others and supports up to
8K (7680x4320) resolution at 60HZ with an increased bandwidth of 77.37Gbs.
A. VGA port
B. HDMI port
C. Display port
D. DVI port
27. What is the correct HTML for creating a hyperlink?
A. <a>https://w.w.w.gkseries.com</a>
B. <a url=”https://w.w.w.gkseries.com”>Gkseries.com</a>
 C. <a name=”https://w.w.w.gkseries.com”>Gkseries.com</a>
D. <a href=”https://www.gkseries.com”>Gkseries.com</a>
28. Which of the following is true about JavaScript?
A. Its client side scripting language
B. It’s a database
C. It’s a software
D. It’s a server side scripting language
29. Which one describes and explains anything to do with your software product, ranging from
internal documentation for teams to external documentation written for end users?
A. Technical Documentation
B. User documentation
C. Security tester
D. Development method
30. Which is the correct syntax to call an external JavaScript file in the current HTML document
A. <import scr=” jsfile.js”></import>
B. <script scr=”jsfile.js”></script>
C. <script link=” jsfile.js”></script>
D. <script href=”jsfile.js”></script>