Skip to content

Category Archives: Computer Subject

Consider a situation when you are not able to access a website and can access other websites. You would want to know if this is… Read More
What is Forwarding? Forwarding is moving incoming packets to the appropriate interface. Routers use a forwarding table to decide which incoming packet should be forwarded to… Read More
Dependency Preservation A Decomposition D = { R1, R2, R3….Rn } of R is dependency preserving wrt a set F of Functional dependency if (F1… Read More
We strongly recommend to refer below post as a pre-requisite for this. Conditional Probability Bayes’s formula Below is Bayes’s formula. The formula provides the relationship… Read More
Conditional probability P(A | B) indicates the probability of event ‘A’ happening given that event B happened. We can easily understand the above formula using… Read More
What are Unicasting, Anycasting, Multicasting and Broadcasting? If the message is sent from a source to a single destination node, it is called Unicasting. This… Read More
In database management an aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form… Read More
Half Subtractor (HS): Half subtractor is a combination circuit with two inputs and two outputs which is difference and borrow. It produces the difference between… Read More
Half Adder (HA): Half adder is the simplest of all adder circuits. Half adder is a combinational arithmetic circuit that adds two numbers and produces… Read More
Consider below simple table:  Name Salary --------------- abc 100000 bcd 1000000 efg 40000 ghi 500000 How to find the employee whose salary is second highest.… Read More
Circuit Switching Packet Switching In-circuit switching has there are 3 phases: i) Connection Establishment. ii) Data Transfer. iii) Connection Released. In Packet switching directly data transfer takes place.… Read More
Which of the following is public IP address ? (A) 10.15.14.12 (B) 192.168.52.62 (C) 172.32.1.1 (D) None of the Above Answer: (C) Explanation: Range of… Read More
If subnet mask 255.255.255.224, which of the following will be Direct Broadcast address ? (A) 202.15.19.127 (B) 202.15.19.63 (C) Both a and b (D) None… Read More
The difference between the having and where clause in SQL is that the where clause cannot be used with aggregates, but the having clause can. The… Read More
Let us consider below table. Name Section abc CS1 bcd CS2 abc CS1 In the above table, we can find duplicate row using below query.… Read More

Start Your Coding Journey Now!