Infosys Certified Oracle PL/SQL Technical Consultant
Practice with real exam-pattern questions for Infosys Certified Oracle PL/SQL Technical Consultant. 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 Oracle PL/SQL Technical Consultant practice questions with answers
Real Lex exam-pattern multiple-choice questions for the Infosys Certified Oracle PL/SQL Technical Consultant certification. Each question includes the correct answer. The full question bank is available to Premium members.
- Question 1
In which scenario, below query will return an error message? SELECT * FROM EMPLOYEES WHERE department = (SELECT department from employees where first_name = 'JANE';
- ✓ When there are multiple records with first_name 'JANE' Correct
- B It will never return an error
- C When there is no record with first_name='JANE'
- D When there is only one record with first_name 'JANE'
- Question 2
CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER) RETURN number IS v_yearly_budget NUMBER; Begin SELECT yearly_budget INTO v_yearly_budget FROM studio WHERE id = v_studio_id; RETURN v_yearly_budget; end; Which invokers-rights clause must you use to ensure that this function uses the security of the executing user when it is invoked?
- ✓ AUTHID CURRENT_USER Correct
- B AUTHID DEFINER
- C AUTHID DETERMINISTIC
- D AUTHID PARALLEL_ENABLE
- Question 3
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint?
- ✓ Yes Correct
- B No
- Question 4
You want to delete all records from table employee, but want to keep table structure and also can rollback the command
- ✓ delete from emp Correct
- B select from emp for update
- C Alter table emp
- D truncate table emp
- Question 5
User Jim issues SELECT nextval from the sequence and receives 10. Another user Tim does the same and receives value as 11. User Tim issues a rollback. Now user Jim selects CURVAL from the sequence. What value Tim will receive?
- ✓ 10 Correct
- B 11
- C 12
- D 1
- Question 6
Look into the below given trigger CREATE TRIGGER my_trigger AFTER CREATE OR DROP ON schema Begin insert into my_log(username,ddl_event) values (user,ora_sysevent); end; What type of trigger is this?
- ✓ DML Row trigger Correct
- B DML Statement trigger
- C Instead of trigger
- D DDL trigger
- Question 7
Which SQL keyword is used to sort the result-set?
- ✓ SORT Correct
- B SORT BY
- C ORDER
- D ORDER BY
- Question 8
Database has tables with static data, that are used for queries only. What is the recommended pctfree size ?
- ✓ 10 Correct
- B 0
- C 25
- D 100
- Question 9
Which section of a PL/SQL block contains the keyword BEGIN?
- ✓ declaration Correct
- B header
- C executable
- D exception
- Question 10
Pick out the correct clause that needs to be used, to modify the definition of an existing trigger without dropping it.
- ✓ After Correct
- B Replace
- C Before
- D Rebuild
More in Oracle Enterprise Applications
Infosys Certified PL-SQL Associate
Infosys Certified Oracle B2B Service Cloud Consultant
Infosys Certified Oracle Financial Consolidation and Close Cloud Services 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.