Header Ads Widget

Recent posts

View all
Module 04: Working with Packages PL/SQL Programming MCQ

Module 04: Working with Packages

dbskool July 31, 2025

Working with Packages 01. Examine this code: CRATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10 ; PROCEDURE reset_comm ( p_comm IN NUMBER…

Read more
Module 03: Creating Packages PL/SQL Programming MCQ

Module 03: Creating Packages

dbskool July 30, 2025

Creating Packages 01. Which two programming constructs can be grouped within a package? (Choose two) a. Cursor b. Constant c. Trigger d. Sequence e…

Read more
Module 02: Creating Functions PL/SQL Programming MCQ

Module 02: Creating Functions

dbskool July 29, 2025

Creating Functions 01. Which statement is true? a. Stored functions can be called from the SELECT and WHERE clauses only. b. Stored functions do no…

Read more
Module 01: Creating Procedures PL/SQL Programming MCQ

Module 01: Creating Procedures

dbskool March 25, 2024

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

Read more
Module 12: Managing Dependencies PL/SQL Programming

Module 12: Managing Dependencies

dbskool March 24, 2024

Managing Dependencies 01. What is local dependency? In the case of local dependencies, the objects are on the same node in the same database. The…

Read more
Module 11: Managing PL/SQL Code PL/SQL Programming

Module 11: Managing PL/SQL Code

dbskool March 24, 2024

Managing PL/SQL Code   01. What Is Conditional Compilation? Enables you to customize the functionality in a PL/SQL application without removing any…

Read more
Module 10: Using the PL/SQL Compiler PL/SQL Programming

Module 10: Using the PL/SQL Compiler

dbskool March 24, 2024

Using the PL/SQL Compiler  1. What Is a Compound Trigger? A single trigger on a table that allows you to specify actions for each of the followin…

Read more