Header Ads Widget

Module 04: Working with Packages PL/SQL Programming

Module 04: Working with Packages

dbskool November 12, 2023

Working with Packages 01. What is Overloading Subprograms in PL/SQL? Overloading: a. Enables you to create two or more subprograms with the same …

Read more
Module 03: Creating Packages PL/SQL Programming

Module 03: Creating Packages

dbskool November 12, 2023

Creating Packages 01. What Are PL/SQL Packages?  A package is a schema object that groups logically related PL/SQL types, variables, and subprogram…

Read more
Module 02: Creating Functions PL/SQL Programming

Module 02: Creating Functions

dbskool November 12, 2023

Creating Functions 01. What is Function? Function: a. Is a named PL/SQL block that returns a value. b. Can be stored in the database as a schem…

Read more
Module 01: Creating Procedures PL/SQL Programming

Module 01: Creating Procedures

dbskool November 12, 2023

Creating Procedures 01. Write down the process of creating a Layered Subprogram Design. Create subprogram layers for your application.  a. Data a…

Read more
Module 09: Creating Stored Procedures and Functions PL/SQL Fundamental MCQ

Module 09: Creating Stored Procedures and Functions

dbskool November 12, 2023

Creating Stored Procedures and Functions 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_dspt_name VARCHAR2 DEFAULT ‘Placeholder’, …

Read more
Module 08: Handling Exceptions PL/SQL Fundamental MCQ

Module 08: Handling Exceptions

dbskool November 12, 2023

Handling Exceptions 01. Which two conditions in a PL/SQL block cause an exception error to occur? (Choose two) a. Select statement does not retur…

Read more
Module 07: Using Explicit Cursors PL/SQL Fundamental MCQ

Module 07: Using Explicit Cursors

dbskool November 12, 2023

Using Explicit Cursors 01. You want to create a cursor that can be used several times in a block. Selecting a different active set each time that i…

Read more