Computer Operator Model Question Set - 7
1. The simplest approach to introducing redundancy to duplicate every disk is called
Correct Answer: a. Mirroring
Disk mirroring, often used in RAID 1, duplicates data across disks to ensure redundancy and fault tolerance.
2. Which of the following is not a recovery technique?
Correct Answer: c. Two-phase commit
Two-phase commit is a transaction protocol to ensure consistency, not a recovery technique like deferred or immediate updates.
3. There are ... types of indexes in SQL server.
Correct Answer: b. 2
SQL Server supports two main index types: clustered and non-clustered, which optimize data retrieval.
4. Which one of the following can not be a primary key in DBMS?
Correct Answer: c. City Name
A primary key must be unique and not null; city names can be duplicated and are not suitable as primary keys.
5. Which of the following is also called an Inner Join?
Correct Answer: b. Equi Join
An equi join uses equality comparisons in the join condition and is a type of inner join.
6. What do you mean by "ROLLBACK" in a database?
Correct Answer: d. TCL
ROLLBACK is a Transaction Control Language (TCL) command used to undo changes in a transaction.
7. ... forms are based on the concept of functional dependency.
Correct Answer: d. BCNF
BCNF (Boyce-Codd Normal Form) eliminates anomalies based on functional dependencies, stricter than 1NF, 2NF, and 3NF.
8. Who designs and implements database structures?
Correct Answer: c. Database designers
Database designers create and implement database structures, while administrators manage and maintain them.
9. Which of the following is the first step in SDLC framework?
Correct Answer: a. Feasibility study
The feasibility study assesses the viability of a project, making it the first step in the SDLC.
10. The agile software development model is built based on ...
Correct Answer: d. Both A and C
Agile relies on incremental (iterative) and interactive (collaborative) development for flexibility and rapid delivery.
11. Which of the following is the first step in the software development life cycle?
Correct Answer: b. Preliminary investigation and analysis
Preliminary investigation and analysis identify project goals and constraints, initiating the SDLC.
12. The entity relationship set is represented in E-R diagram as
Correct Answer: d. Diamond
In E-R diagrams, relationships are represented by diamond shapes connecting entities.
13. Graphical notation to describe the data flow between various processes of a system is called
Correct Answer: c. Data Flow Diagram
Data Flow Diagrams (DFDs) visually represent data movement between processes in a system.
14. Which of the following process improvement model?
Correct Answer: a. CMMI
CMMI (Capability Maturity Model Integration) is a process improvement framework, unlike Agile or V model, which are development methodologies.
15. A cost performance index (CPI) of 0.89 means
Correct Answer: d. The project is only getting 89 paisa out of every rupees invested
CPI of 0.89 indicates that for every rupee spent, the project earns 89 paisa of value, showing cost inefficiency.
16. Identify the sub-process of process improvement.
Correct Answer: b. Process analysis
Process analysis evaluates existing processes to identify areas for improvement, a key sub-process in process improvement.
17. A horizontal bar chart that shows project tasks against a calendar is called
Correct Answer: d. Gantt chart
A Gantt chart visually represents project tasks and their durations on a timeline using horizontal bars.
18. What is the first step in project planning?
Correct Answer: d. Establish the objectives and scope.
Defining objectives and scope sets the foundation for project planning, guiding all subsequent steps.
19. Software risk always involves two characteristics. What are those characteristics?
Correct Answer: a. Uncertainty and Loss
Software risks are characterized by uncertainty (likelihood of occurrence) and potential loss (impact).
20. Which of these is not one of the phase names defined by the Unified Process model for software development?
Correct Answer: d. Validation phase
The Unified Process includes Inception, Elaboration, Construction, and Transition phases, not Validation.
21. Framework that encompasses a process set of methods and an array of tools is termed as
Correct Answer: a. Software engineering
Software engineering integrates processes, methods, and tools to develop software systematically.
22. Which of the following is not one of the three components in a decision support system?
Correct Answer: b. Communication
A decision support system comprises data, model, and dialogue components, not communication.
23. ... should plan well and execute perfectly the implementation of ERP.
Correct Answer: c. Top management
Top management oversees ERP implementation, ensuring strategic alignment and resource allocation.
24. What are the four major areas that can be identified as being subjected to change in BPR?
Correct Answer: c. Organization, Technology, Strategy, People
Business Process Reengineering (BPR) focuses on transforming organization, technology, strategy, and people.
25. A human order taker can be bypassed when using
Correct Answer: d. a transaction processing system
Transaction processing systems automate routine tasks like order taking, bypassing human intervention.
26. Buying a cinema ticket on a mobile phone is an example of ...
Correct Answer: c. M-commerce
M-commerce (mobile commerce) involves transactions conducted via mobile devices, like buying tickets.
27. Processed data is called
Correct Answer: b. Information
Processed data becomes information, which is meaningful and useful for decision-making.
28. Which topology of LAN uses circuit switching?
Correct Answer: b. Star
Star topology can use circuit switching, where a dedicated path is established via a central switch.
29. Bluetooth is a type of radio wave information transmission system that is good for about
Tags:
PSC