Infosys Certified PL-SQL Associate
Practice with real exam-pattern questions for Infosys Certified PL-SQL Associate. Each question includes a detailed explanation to help you understand the concept, not just memorise the answer. Try 10 questions free — no login required.
Full question bank for this exam + 1,357+ others. Cancel anytime.
Join Premium10 Infosys Certified PL-SQL Associate practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified PL-SQL Associate certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
PL/SQL stands for -
- ✓
Programming Language/SQL
Correct - B
Portable Language/SQL
- C
Procedural Language/SQL
- D
None of the above
- ✓
- Question 2
Which of the following exception is raised implicitly at runtime?
A. User defined exceptions
B. Pre-defined exceptions
- ✓
Only A
Correct - B
Only B
- C
Both A & B
- D
Neither A nor B
- ✓
- Question 3
Which of the following value can be passed to a IN mode parameter?
1. Default
2. User Defined
- ✓
1
Correct - B
2
- C
Both 1 & 2
- D
Neither 1 nor 2
- ✓
- Question 4
Which of the following exception gets raised when an arithmetic, numeric, string, conversion, or constraint error occurred?
- ✓
VALUE_ERROR
Correct - B
TOO_MANY_ROWS
- C
NO_DATA_FOUND
- D
ZERO_DIVIDE
- ✓
- Question 5
Which of the following is a way of passing parameters to PL/SQL subprograms?
- ✓
Positional notation
Correct - B
Named notation
- C
Mixed notation
- D
All of the above.
- ✓
- Question 6
In a package there are three overloaded procedures. Which procedure will be executed for the below procedure call.
P1('variable 1','10')
- ✓
P1(v1 number, v2 varchar2)
Correct - B
P1(v1 varchar2, v2 varchar2)
- C
P1(v1 varchar2, v2 number)
- D
Procedure Call will not happen
- ✓
- Question 7
What will be the output of following code?
- ✓
Some Error Occurred
Correct - B
Some Error Occured
10 - C
Zero division is not possible
- D
10
Zero division is not possible
- ✓
- Question 8
The database contains a package named G_TROUBLESHOOT. You want to remove the package specification from the database while retaining the package body. Which of the following statements will you use to accomplish this?
- ✓
DROP Package G_TROUBLESHOOT;
Correct - B
DROP Package Specification G_TROUBLESHOOT;
- C
DROP Package Body G_TROUBLESHOOT;
- D
Dropping Package Specification deletes Package Body
- ✓
- Question 9
Which of the following statement is true about comments in PL/SQL?
- ✓
Comments are explanatory statements
Correct - B
The PL/SQL single-line comments start with the delimiter — (double hyphen)
- C
Multi-line comments are enclosed by /* and */.
- D
All of the above.
- ✓
- Question 10
Inside a PL/SQL execution block, how many rows can a SELECT query return into a scalar variable?
- ✓
One to Ten
Correct - B
Only one
- C
One or many
- D
One or Two
- ✓
More in Oracle Enterprise Applications
Infosys Certified Oracle B2B Service Cloud Consultant
Infosys Certified Oracle Financial Consolidation and Close Cloud Services Consultant
Infosys Certified Oracle Sales Cloud Consultant
Pay once. Clear every cert this year.
One subscription, full Telegram channel access, every PDF posted during your membership.
- Full access to all 1,357+ certifications
- Monthly updated question banks
- Telegram private channel access
- Cancel anytime
- Everything in Monthly
- Save ₹2,100 vs monthly billing
- Priority answer key requests
- Best for increasing DQ score fast
- Everything in Quarterly
- Lifetime channel access — no renewals
- All future certifications included
- Priority response from admin team
Common questions, straight answers.
A monthly-updated Telegram channel where we post real exam-pattern question banks and detailed answer keys for 1,357+ Infosys Lex certifications. You join once, you get every PDF posted during your membership.
Right after payment on our Graphy page, you'll receive a private invite link to the Telegram channel. Access is instant — usually under 30 seconds.
We compile question banks from the actual Lex test pattern, sourced and verified by 180K+ community members who've recently cleared these exams. Match rate is consistently 85–95%.
Every single month. When Infosys rolls out new versions of certifications, we post updated dumps within 7–10 days. You'll see channel activity weekly.
Clearing certifications is one of the highest-weighted DQ factors. Members typically clear 3–5 certifications in their first 3 months, which moves DQ scores up by a full band.