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. Data query languages are computer languages used to make queries in databases and information systems.Which among the following are the the Query Languages?
[A] Atomese
[B] Cypher
[C] Datalog
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
Atomese is the graph query language for the OpenCog graph database.Cypher is a query language for the Neo4j graph database.Datalog is a query language for deductive databases.
22. What is the name given to the library of related functions that are not loaded into memory until they are called by the application program?
[A] DML
[B] DLL
[C] DCL
[D] All of the Above
Show Answer
Correct Answer: B [DLL]
Notes:
Dynamic Link Library is the library of related functions that are not loaded into memory until they are called by the application program. All RDM APIs are contained in DLLs on those operating systems that support them.
23. Which of the following statements in SQL are considered as Data manipulation language?
[A] Update
[B] Insert
[C] Delete
[D] All of the Above
Show Answer
Correct Answer: D [All of the Above]
Notes:
In SQL, such statements as UPDATE, INSERT and DELETE are considered DML. Some people also lump the SELECT statement in the DML classification.
24. Which one of the following is a discontinued computer network operating system developed by Novell, Inc.?
[A] Netware
[B] Novellware
[C] IPX network
[D] None of the Above
Show Answer
Correct Answer: A [Netware]
Notes:
NetWare is a discontinued computer network operating system developed by Novell, Inc. It uses IPX network protocol.
25. Which one of the following is not an example of WAN?
[A] Ethernet
[B] ISDN
[C] Frame Relay
[D] ATM
Show Answer
Correct Answer: A [Ethernet]
Notes:
In MAN, various LANs are connected to each other through a telephone exchange line. The most widely used protocols in MAN are RS- 232, Frame Relay, ATM, ISDN, OC-3, ADSL, etc.
26. Which of the following device distributes network traffic across a number of servers?
[A] IDS
[B] Load Balancer
[C] Switch
[D] Hub
Show Answer
Correct Answer: B [Load Balancer]
Notes:
A load balancer is a device that acts as a reverse proxy and distributes network or application traffic across a number of servers. Load balancers are used to increase capacity and reliability of applications
27. Which of the following represents a sine wave?
[A] Non-periodic analog signal
[B] Periodic analog signal
[C] Periodic digital signal
[D] Non-periodic digital signal
Show Answer
Correct Answer: B [Periodic analog signal]
Notes:
The sine wave is the most fundamental form of a periodic analog signal. A periodic signal completes a pattern within a measurable time frame, called a period, and repeats that pattern over subsequent identical periods.
28. Which of these networks usually have all the computers connected to a hub?
[A] Ring
[B] Tree
[C] Star
[D] Bus
Show Answer
Correct Answer: C [Star]
Notes:
In Star topology, all the computers are connected to a single hub through a cable. This hub is the central node and all others nodes are connected to the central node.
29. What do we call the process of transferring a mobile station from one base station to another?
[A] Looping
[B] Hand off
[C] Forwarding
[D] Channeling
Show Answer
Correct Answer: B [Hand off]
Notes:
Hand off is the process of transferring an active call or data session from one cell in a cellular network to another or from one channel in a cell to another.
30. What do we call the handoff in which there is a break in the connection on the cellular network?
[A] Hard handoff
[B] Soft handoff
[C] Rigid handoff
[D] Variable handoff
Show Answer
Correct Answer: A [Hard handoff]
Notes:
Hard Handoff refers to an actual break in the connection while switching from one cell or base station to another. The switch takes place so quickly that it can hardly be noticed by the user.
