Week11 - Packages / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a package named "staff_package&…
DBMS - Unit V
Week11 - Packages / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a package named "dept_package&q…
Week10 - Triggers / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a trigger named 'trigger_travel_…
Week10 - Triggers / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a trigger named 'trigger_slab_in…
Week10 - Exception Handling / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a procedure named "insert_route…
Week10 - Exception Handling / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Please go through the below Function and Ex…
Week9 - Stored Functions / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a function named 'findRoute'…
Week9 - Stored Functions / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a function named 'findTotalUnit&…
Week9 - Cursors / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. Create a procedure named 'select_booking&#…
Week9 - Cursors / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Write a PL/SQL simple procedure named incre…
Week9 - Stored Procedures / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a procedure named 'findAmount…
Week9 - Stored Procedures / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Create a procedure named 'insertConnect…
Week9 - Introduction to PL/SQL, Control Statements / Assess
The questions can come in any order, so make sure you are selecting right option for all questions. PL/SQL Simple Blocks Write a PL/SQL simple pr…
Week9 - Introduction to PL/SQL, Control Statements / Design
The questions can come in any order, so make sure you are selecting right option for all questions. 1. SB - Date Operations Write a PL/SQL anonym…
Week9 - Introduction to PL/SQL, Control Statements / Analyze
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Which of the following statements is true?…
Week9 - Introduction to PL/SQL, Control Statements / Explore
The questions can come in any order, so make sure you are selecting right option for all questions. 1. Which of the following is true about comme…