DBMS
Setting environment using SET command
1. SET APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO pa…
1. SET APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO pa…
SQL JOIN We need tables to implement join query, So, first of all, create table and insert records as per …
Index SQL INDEX is used to quickly find data without searching every row in a database table. SQL INDEX …
Sequence Sequence is a sequential list of unique numbers. It is useful for table's column without max…
Schema & its objects What is Schema? It is a collection of logical structure, units of data or sche…
Set Operations SQL supports few Set operations which can be performed on the table data. These are us…
SORTING DATA IN A TABLE: The select commands allows user to arrange data in ascending or descending …
VIEW ALL ROWS AND COLUMNS: The select commands used to view all columns and rows. Syntax select * fro…
DUMP Function The DUMP function returns a varchar2 value that includes the datatype code, the length in…
View: It is a database object. It is a virtual or logical representation of table. It has no physical…
Recovery and Atomicity When a system crashes, it may have several transactions being executed and various …
Two-Phase Commit Protocol In a local database system, for committing a transaction, the transaction manag…
System Recovery There can be any case in database system like any computer system when database failure ha…
Testing for serializability Serialization Graph is used to test the Serializability of a schedule. Assume…
Serializability of transactions When multiple transactions are running concurrently then there is a p…
Schedule and its types The order in which the operations of multiple transactions appear for execution is …
Concurrency Problems in DBMS When multiple transactions execute concurrently in an uncontrolled or unrestr…