Header Ads Widget

Recent posts

View all
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
Module 09: Creating Compound, DDL, and Event Database Triggers PL/SQL Programming

Module 09: Creating Compound, DDL, and Event Database Triggers

dbskool November 12, 2023

Creating Compound, DDL, and Event Database  Triggers 01. What Are Triggers? Triggers: a. A trigger is a PL/SQL block that is stored in the databa…

Read more
Module 08: Creating Triggers PL/SQL Programming

Module 08: Creating Triggers

dbskool November 12, 2023

Creating Triggers 01. What are Autonomous Transactions?  Autonomous Transactions: a. Are independent transactions started by another main transac…

Read more
Module 07: Design Considerations for PL/SQL Code PL/SQL Programming

Module 07: Design Considerations for PL/SQL Code

dbskool November 12, 2023

Design Considerations for PL/SQL Code 01. What is Local Subprogram? Ans: A local subprogram is a PROCEDURE or FUNCTION defined at the end of the de…

Read more