- Home-icon
- Computer Fundamental
- _Descriptive
- _Multiple Choice
- _Practices
- BDD
- _Des. Fundamental
- _MCQ Fundamental
- _Prac. Fundamental
- PPT
- _Descriptive
- _Multiple Choice
- _Practices
- SQL
- _Descriptive
- _Multiple Choice
- _Practices
- PL/SQL
- _Des. Fundamental
- _Des. Programming
- _MCQ Fundamental
- _Prac. Fundamental
- Forms
- _Descriptive
- _Multiple Choice
- _Practices
- Reports
- _Descriptive
- _Multiple Choice
- _Practices
- DBA
- _Descriptive
- _Multiple Choice
- _Practices
- APEX
- _Descriptive
- _Multiple Choice
- _Practices
- Vendor Exam
- _Vendor Preparation
- _Vendor Test
- Products
- _Products List
PL/SQL Programming
Module 09: Creating Compound, DDL, and Event Database Triggers
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
PL/SQL Programming
Module 08: Creating Triggers
Creating Triggers 01. What are Autonomous Transactions? Autonomous Transactions: a. Are independent transactions started by another main transac…
Read more
PL/SQL Programming
Module 07: Design Considerations for PL/SQL Code
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
PL/SQL Programming
Module 06: Using Dynamic SQL
Using Dynamic SQL 01. Write down the Execution Flow of SQL. All SQL statements go through some or all of the following stages: a. Parse. b. Bi…
Read more
PL/SQL Programming
Module 05: Using Oracle-Supplied Packages in Application
Using Oracle-Supplied Packages in Application 01. What are The Oracle-supplied packages? The Oracle-supplied packages: a. Are provided with the…
Read more
PL/SQL Programming
Module 04: Working with Packages
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
PL/SQL Programming
Module 03: Creating Packages
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
PL/SQL Programming
Module 02: Creating Functions
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
PL/SQL Programming
Module 01: Creating Procedures
Creating Procedures 01. Write down the process of creating a Layered Subprogram Design. Create subprogram layers for your application. a. Data a…
Read more
PL/SQL Fundamental MCQ
Module 09: Creating Stored Procedures and Functions
Creating Stored Procedures and Functions 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_dspt_name VARCHAR2 DEFAULT ‘Placeholder’, …
Read more
PL/SQL Fundamental MCQ
Module 08: Handling Exceptions
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
PL/SQL Fundamental MCQ
Module 07: Using Explicit Cursors
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
PL/SQL Fundamental MCQ
Module 06: Working with Composite Data Types
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
PL/SQL Fundamental MCQ
Module 05: Writing Control Structures
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
PL/SQL Fundamental MCQ
Module 04: Interacting with the Oracle Database Server
Interacting with the Oracle Database Server 01. Written a PL/SQL loop, you need to test if the current FETCH was successful. Which SQL cursor attr…
Read more
PL/SQL Fundamental MCQ
Module 03: Writing Executable Statements
Writing Executable Statements 01. Which statement is true about nesting blocks? a. Variable name must be unique between blocks. b. A variable d…
Read more
PL/SQL Fundamental MCQ
Module 02: Declaring PL/SQL Variables
Declaring PL/SQL Variables 01. Examine the code: SET SERVER OUTPUT ON DECLARE v_char_val varchar2(100); BEGIN v_char_val:= ‘Hello World’, DBMS_OUT…
Read more
- dbskool
- DBSkool is a website that provides tutorials, articles, and online courses related to database technologies such as Oracle, SQL Server, PL/SQL,FORMS, REPORTS, DBA, Oracle APEX and other relational databases. As the name suggests, DBSkool primarily focuses on educating individuals and professionals in the field of database management.
Follow Us