- 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
- _MCQ Fundamental
- _Prac. Fundamental
- _Des. Programming
- _MCQ Programming
- 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
Showing posts from October, 2023Show all
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
PL/SQL Fundamental MCQ
Module 01: Introduction to PL/SQL
Introduction to PL/SQL 01. PL/SQL block consists of ____ sections. a. 1 b. 2 c. 3 d. 4 Show Answer Answer: d 02. The exce…
Read more
PL/SQL Fundamental 01
Module 09: Creating Stored Procedures and Functions
Creating Stored Procedures and Functions 01. What is Procedure and Functions? Procedures and functions are named PL/SQL blocks. They are also know…
Read more
PL/SQL Fundamental 01
Module 08: Handling Exceptions
Handling Exceptions 01. What is an Exception? An exception is a PL/SQL error that is raised duringprogram execution. 02. What are the Methods for…
Read more
PL/SQL Fundamental 01
Module 07: Using Explicit Cursors
Using Explicit Cursors 01. What are Explicit cursors? Declared and managed by the Programmer 02. Write down the explicit cursor functions. Explic…
Read more
PL/SQL Fundamental 01
Module 06: Working with Composite Data Types
Working with Composite Data Types 01. What is Composite Data Types? Can hold multiple values (unlike scalar types) 02. What are the types of Com…
Read more
PL/SQL Fundamental 01
Module 05: Writing Control Structures
Writing Control Structures 01. Write down about IF Statement. The structure of the PL/SQL IF statement is similar to the structure of IF statements…
Read more
PL/SQL Fundamental 01
Module 04: Interacting with the Oracle Database Server
Interacting with the Oracle Database Server 01. Write down the Guidelines for Retrieving Data in PL/SQL Guidelines: a. Terminate each SQL statem…
Read more
PL/SQL Fundamental 01
Module 03: Writing Executable Statements
Writing Executable Statements 01. What is Lexical Units in a PL/SQL Block? Lexical units: a. Are building blocks of any PL/SQL block. b. Are se…
Read more
PL/SQL Fundamental 01
Module 02: Declaring PL/SQL Variables
Declaring PL/SQL Variables 01. What is variable? In Oracle/PLSQL, a variable allows a programmer to store data temporarily during the execution of …
Read more
PL/SQL Fundamental 01
Module 01: Introduction to PL/SQL
Introduction to PL/SQL 01. What is PL/SQL? PL/SQL: a. Stands for Procedural Language extension to SQL b. Is Oracle Corporation’s standard data…
Read more
Forms MCQ
Module 25: Introducing Multiple Form Applications
Introducing Multiple Form Applications 01. The Department form is part of a multiform application that also includes the Customer and Orders forms. T…
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