Computer Awareness MCQs and Quiz for Banking, IBPS, RRB, RBI, SBI Exams
Computer Awareness Questions and Quiz for Banking, IBPS, RRB, RBI, SBI, NABARD examinations of 2020-2021. Computer Awareness MCQs for Competitive Exams. GKToday Computer Awareness for IBPS PO, IBPS Clerk, Bank PO, Bank Clerk and other entrance / competitive examinations.
51. Which of the following is used as an application programming interface with RDBMS?
[A] VB
[B] COBOL
[C] SQL
[D] All of the Above
Show Answer
Correct Answer: C [SQL]
Notes:
With relational DBMSs known as RDBMSs, the Application programming interface is SQL.SQL a standard programming language for defining, protecting and accessing data in a RDBMS.
52. Which of the following form is based on the concept of functional dependency?
[A] 1NF
[B] 2NF
[C] 3NF
[D] All of the Above
Show Answer
Correct Answer: C [3NF]
Notes:
The table is in 3NF if every non-prime attribute of R is non-transitively dependent or directly dependent on every super key of R.
53. Which of the following is the most commonly used operation in relational algebra for projecting a collection of records from a relation?
[A] Join
[B] Union
[C] Select
[D] All of the Above
Show Answer
Correct Answer: C [Select]
Notes:
Select is used to view the tuples of the relation with or without some constraints. This operation is used to select rows from a table that specifies a given logic, which is called as a predicate. The predicate is a user defined condition to select rows of user’s choice.
54. Which of the following networking hardware can operate at anyone of the seven layers of the open systems interconnection model?
[A] Router
[B] Gateway
[C] Switch
[D] Modem
Show Answer
Correct Answer: B [Gateway]
Notes:
Gateways are distinct from routers or switches in that they communicate using more than one protocolh6k and can operate at any of the seven layers of the open systems interconnection model .
55. In the OSI model, Bridging is performed in which of the following layers?
[A] Layer 7
[B] Data Link Layer
[C] Session Layer
[D] Transport Layer
Show Answer
Correct Answer: B [Data Link Layer]
Notes:
In the OSI model, bridging is performed in the data link layer. A network bridge is a computer networking device that creates a single aggregate network from multiple communication networks or network segments.
56. 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
57. Which one of the below is known as the Multi-Port Repeater?
[A] Firewall
[B] HIDS
[C] Hub
[D] Switch
Show Answer
Correct Answer: C [Hub]
Notes:
A hub, in the context of networking, is a hardware device that relays communication data. A hub sends data packets to all devices on a network.
58. Which of the following represents Latency?
[A] propagation time +transmission time +queuing time + processing delay
[B] propagation time – transmission time +queuing time + processing delay
[C] propagation time +transmission time +queuing time – processing delay
[D] (propagation time +transmission time) – (queuing time + processing delay)
Show Answer
Correct Answer: A [propagation time +transmission time +queuing time + processing delay]
Notes:
It can be said that the Latency is made of four components: propagation time, transmission time, queuing time and processing delay. Latency =propagation time +transmission time +queuing time + processing delay
59. What is the length of each character in ASCII code?
[A] 2-bit
[B] 8-bit
[C] 4-bit
[D] 7-bit
Show Answer
Correct Answer: D [7-bit]
Notes:
ASCII code is used to represent digital data. In ASCII code, each character is represented by a 7-bit code.
60. What is the number of bit interval per second known as?
[A] Bit period
[B] Bit lag
[C] Bit capacity
[D] Bit rate
Show Answer
Correct Answer: D [Bit rate]
Notes:
The bit rate is the number of bit interval per second. This mean that the bit rate is the number of bits send in one second, usually expressed in bits per second.
[contact-form-7 id="141158" title="Contact form 1"]
