• a) Explain difference between DBMS and RDBMS in detail. b) What is deadlock? Explain methods to prevent deadlock. c) What is exception handling? Explain predefined exceptions. d) Explain two-phase locking protocol […]

  • a) Explain RDBMS packages in detail. b) What is function? Explain with an example. c) List and explain properties of transaction. d) Explain % type and % row type with an example. e) Explain failure classification […]

  • a) Explain RDBMS packages in detail. b) What is function? Explain with an example. c) List and explain properties of transaction. d) Explain % type and % row type with an example. e) Explain failure classification […]

  • 1.1 Introduction to PLSQL 1.2 PL/PgSqL: Datatypes, Language structure   1.3 Controlling the program flow, conditional statements, loops   1.4 Stored Procedures   1.5 Stored Functions   1.6 Handling Errors and Exc […]

  • 1.1 Introduction to PLSQL 1.2 PL/PgSqL: Datatypes, Language structure   1.3 Controlling the program flow, conditional statements, loops   1.4 Stored Procedures   1.5 Stored Functions   1.6 Handling Errors and Exc […]

  • Load More