GET SET STUDY

 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 mor...

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) Do...