Header Ads Widget

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
Module 06: Working with Composite Data Types PL/SQL Fundamental MCQ

Module 06: Working with Composite Data Types

dbskool November 06, 2023

Working with Composite Data Types 01. In the executable section of a PL/SQL block, you include this statement: inventory. inventory1 := 12; Which t…

Read more
Module 05: Writing Control Structures PL/SQL Fundamental MCQ

Module 05: Writing Control Structures

dbskool November 04, 2023

Writing Control Structures 01. Evaluate this PL/SQL block. BEGIN FOR i IN 1..10 LOOP IF I=4 OR I=6 THEN null; ELSE INSERT INTO test(result) VALUES …

Read more