quescol Topology means the arrangement of nodes connected in a network by some physical medium such as optical fiber and cable. Network topology permits you to understand the dissimilar components of your network and the network’s connection. Topology in a computer network is like the plan of a city showing how all the houses (computers) are … Read more
(a) Error detection and correction: Data link layer performs the error detection and correction. The data link layer allows practical means to transmit data between the network and detect and correct the errors that may appear in the physical layer. (b) Routing: The network layer performs routing the data through the better physical path. (c) … Read more
TCP/IP stands for Transmission Control Protocol/Internet Protocol. It’s like the rule book for how computers talk to each other on the internet. Just like how we follow rules in a game to understand each other, computers use TCP/IP to share pictures, messages, and more. There are four layer in TCP/IP Protocol 1. Application Layer Job … Read more
The various layers of the OSI model are explained Below 1. Application layer The application layer is the uppermost layer of the OSI model. The application layer is used by network applications like computer applications like chrome, firefox, outlook, skype etc. This layer involves various protocols like HTTP, SMTP, HTTPs and FTP. That protocol allows … Read more
There are different uses of computer networks, and some uses are mentioned below: Computer networks are like the highways of the digital world, connecting us in ways that make our lives easier and more fun. They’re not just about computers talking to each other; they’re about connecting people, helping businesses grow, and even saving lives. … Read more
A Computer Network is a combination of devices (computers and laptops) that are connected together for the purpose of data or resource sharing. The devices use general connection protocols beyond digital interconnections to connect with more devices. A Computer Network is like a group of friends who can share their toys, games, and secrets easily and … Read more
A cursor is a working area where an SQL statement is executed. It is used to process individual rows returned by the database system for a query. Types of cursor Based on their scope and usage Based on their functionality and behavior Detailed Explanation 1. Explicit Cursors Explicit Cursors are declared by programmers in their … Read more
PL/SQL stands for procedural Structures query language which is an extension of the structural query language (SQL) and oracle relation database. It is independent of the operating system environment and tightly integrated with SQL. It provides extensive error checking, numerous data types, and a variety of programming structures. It also supports structural programming through the … Read more
Oracle stores the definition of data along with the data. This data definition meant the data about the data i.e. Information about the users, table, columns, concerns, and all objects created in the database. This information is stored in the form of a table which is called a data dictionary. The data dictionary is a … Read more
The various oracle processes are listed and explained below Log Writer Background Process (LGWR): This component writes the redo entries from redo log buffers when the user executes the commit statement or the buffer exceeds 1/3rd of the redo log buffers. Database Writer Background Process(DBWR): This component will write all the dirty blocks whenever checkpoints … Read more