# Category Archives: Computer Subject

In this article, Let’s discuss common types of questions in relational algebra which are asked in GATE. Before reading this article, you should have anâ€¦ Read More
To understand this topic, you should have a basic idea about Functional Dependency & Candidate keys and Normal forms . Steps to find the highest normal form ofâ€¦ Read More
For understanding the equivalence of Functional Dependencies Sets (FD sets), the basic idea about Attribute Closure is given in this article Given a Relation with differentâ€¦ Read More
Cache Memory is a special very high-speed memory. It is used to speed up and synchronize with high-speed CPU. Cache memory is costlier than mainâ€¦ Read More
Why security is Needed?  Blogging now a days has become a hobby of so many people and WordPress is the most opted platform for theâ€¦ Read More
This article is an extension of Commonly asked DBMS interview questions | Set 1.  Q. There is a table where only one row is fullyâ€¦ Read More
In computer networks, data is sent in small blocks known as packets. Each packet is transmitted individually and may also follow a different route toâ€¦ Read More
Addressing Modes– The term addressing modes refers to the way in which the operand of an instruction is specified. The addressing mode specifies a ruleâ€¦ Read More
Prerequisite – Representation of Negative Binary Numbers  1’s complement of a binary number is another binary number obtained by toggling all bits in it, i.e.,â€¦ Read More
What is Functional Dependency? A functional dependency X->Y in a relation holds if two tuples having same value for X also have same value forâ€¦ Read More
Both CPU Cache and TLB are hardware used in microprocessors but what’s the difference, especially when someone says that TLB is also a type ofâ€¦ Read More
Basics of Relational model: Relational Model  Relational Algebra is a procedural query language that takes relations as an input and returns relations as an output.â€¦ Read More
Basic idea about  relational model and basic operators in Relational Algebra: Relational Model Basic Operators in Relational Algebra Extended operators are those operators which canâ€¦ Read More
Consider a situation where we have a file shared between many people.   If one of the person tries editing the file, no other person shouldâ€¦ Read More
Machine Instructions are commands or programs written in machine code of a machine (computer) that it can recognize and execute. A machine instruction consists ofâ€¦ Read More