GET SET STUDY

  Most of the questions are already discussed on Get Set Study Channel. Some remaining few are as follows. Q Discuss SONET layered architecture and compare optical networking with electrical networking? SONET (Synchronous Optical Network) is a layered architecture that defines how digital optical telecommunications signals should be transported over fiber optic cables. It is designed to support high-speed data transfer rates for voice, video, and data traffic. The SONET layered architecture consists of four layers: Photonic Layer: This layer is responsible for transmitting the optical signals over the fiber optic cables. It converts electrical signals into optical signals and vice versa. Section Layer: This layer is responsible for providing error detection and correction mechanisms for the physical layer. It ensures that the data is transmitted error-free. Line Layer: This layer is responsible for providing error detection and correction mechanisms for the transmission of frame

 

ADVANCED COMPUTER NETWORK | END TERM 2017

 End Term Questions Q Differentiate between the following: (2017) (a) Procedures and functions in PL/SQL. Procedures and functions are both subprograms in PL/SQL that can be called by other PL/SQL blocks. However, they have some differences: A procedure is a subprogram that performs a specific action and does not return a value. It is executed using the CALL statement or as part of a larger block. A function is a subprogram that performs a specific action and returns a value. It can be called from other PL/SQL blocks or SQL statements. (b) Current database and temporal database. A current database is a traditional database that stores the current state of data at any given time. It is not designed to track changes over time and does not store historical versions of data. A temporal database is a type of database that stores historical versions of data. It tracks changes to data over time and allows users to query data as it existed at any point in the past. This allows for more ac

ETCS-423 Q Give Notes the following :  (a) PL/SQL Database Objects PL/SQL Database Objects: PL/SQL (Procedural Language/Structured Query Language) is a database programming language used to develop database applications. PL/SQL Database Objects are programmatic units that enable you to store and organize your code. Examples of PL/SQL Database Objects include procedures, functions, triggers, packages, and views. (b) Temporal Database Temporal Database: A temporal database is a type of database that stores time-varying data, or data that changes over time. Temporal databases can store historical data as well as current data, making them useful for applications that require time-based analysis, such as financial or medical applications. (c) Cursors Cursors: A cursor is a database object that enables you to traverse through the results of a SELECT statement and process each row individually. Cursors are often used in stored procedures and functions to process data row-by-row. (d) Docume