Computers and IT MCQs
Computer Awareness Questions and Quiz for Banking, IBPS, RRB, RBI, SBI, NABARD examinations of 2024-2025. Computer Awareness MCQs for Competitive Exams. GKToday Computer Awareness for IBPS PO, IBPS Clerk, Bank PO, Bank Clerk and other entrance / competitive examinations.
21. What is the full form of a PCI bus?
[A] Peripheral Computer Interconnect
[B] Peripheral Component Interconnect
[C] Passed Component Interconnect
[D] Phased Computer Interconnect
Show Answer
Correct Answer: B [Peripheral Component Interconnect]
Notes:
PCI stands for Peripheral Component Interconnect. It is a local computer bus for attaching hardware devices in a computer. The first version of conventional PCI found in consumer desktop computers was a 32-bit bus using a 33 MHz bus clock .
22. An assembler is a program that converts assembly language into machine code. Which of the following is not a type of assembler ?
[A] One pass
[B] Two pass
[C] Load and Go
[D] Three pass
Show Answer
Correct Answer: D [Three pass]
Notes:
An assembler is a program that translates assembly language into machine language. There are many types of assemblers .Some of them are one pass assembler, two pass assemble, laod and go assembler etc.
23. Which of the following are the features of a Spreadsheet?
[A] Layers and Lines
[B] Rows and Columns
[C] Layers and Planes
[D] Height and Width
Show Answer
Correct Answer: B [Rows and Columns]
Notes:
A spreadsheet is an interactive computer application for organization, analysis and storage of data in tabular form. The program operates on data entered in cells of a table.
24. Which of the following is the location information application software?
[A] MATLAB
[B] Google
[C] ArcGIS
[D] Win
Show Answer
Correct Answer: C [ArcGIS]
Notes:
ArcGIS is a geographic information system. It is used for working with maps and geographic information. It is used for creating and using maps, compiling geographic data, analyzing mapped information etc.
25. What is the name given to the malicious software that is considered to fall between normal software and a virus?
[A] Spyware
[B] Greyware
[C] Malware
[D] Spam
Show Answer
Correct Answer: B [Greyware]
Notes:
Greyware is a term for which all other malicious software such as adware, spyware, trackware, and other malicious code and malicious shareware fall under.
26. Which of the following programming languages is designed to connect simple HTML pages to a database?
[A] FORTRAN
[B] Cold Fusion
[C] Phython
[D] ASP
Show Answer
Correct Answer: B [Cold Fusion]
Notes:
ColdFusion Markup Language is commonly known as CFML. It is a scripting language for web development.CFML augments standard HTML files with database commands, conditional operators, high-level formatting functions, and other elements to produce web applications.
27. Which of the following DBMS is well-suited for data warehouses that have a large number of similar data items?
[A] Columnar database management system
[B] In-memory database management system
[C] RDBMS
[D] NoSQL DBMS
Show Answer
Correct Answer: A [Columnar database management system]
Notes:
CDBMS stands for Columnar database management system. It well-suited for data warehouses that have a large number of similar data items.
28. What is the name given to the skilled and trained professional who directs all activities related to an organization’s database?
[A] System Administrator
[B] System Manager
[C] Database administrator
[D] Database Manager
Show Answer
Correct Answer: C [Database administrator]
Notes:
A database administrator is a specialized computer systems administrator who maintains a successful database environment by directing or performing all related activities to keep the data secure.
29. The CAP Theorem concludes that it is not possible for a distributed computer system to provide three guarantees at the same time. Which of the following are among these three guarantees?
[A] Consistency
[B] Availability
[C] Partition Tolerance
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
The CAP Theorem consists three following terms: Consistency states that each computer node contain all of the same data at the same time. Availability states that each database request is responded to as either successful or failure. Partition tolerance states that the database system continues operating even when not all nodes are connected to one another and suffer communication issues.
30. System Area Network is used to provide high-speed connection in which of the following environments?
[A] Server-to-server application
[B] Storage Area Network
[C] Processor-to-Processor application
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
System Area Network is used to explain a relatively local network that is designed to provide high-speed connection in server-to-server applications, storage area network and processor-to-processor applications. The computers connected on a SAN operate as a single system at very high speeds.
