This test is available in both the Average Skill level and the Advanced Skill level. The Average Skill level test will have at least 25 questions and will take approximately 30 minutes to complete. The Advanced Skill level test will have at least 40 questions and will take approximately 45 to 60 minutes to complete. These tests may also be combined with other tests to present a Combined Test of any length.

These are Multiple Choice type tests with at least four possible answers, only one of which is correct. We constantly change, revise and upgrade our test and really value your opinion. Please send us any suggestions or additions so that we may consider them.

Among the areas covered by this test are the following:

  • Basic Block Structures,
  • Assignments, and Operators,
  • Control Structures,
  • Transaction Scope, Database Triggers,
  • Large Objects (LOBs),
  • Composite Data types,
  • System Reference Cursors,
  • Functions and Procedures
  • and much more

We have included a sample question below to give you the style and essence of the test To take a demo of our tests please click the Try a Test Demo button above.

Which one of the following in PL/SQL is a VALID trigger type?

  • UPDATE row trigger
  • INSERT row trigger
  • AFTER statement trigger
  • DELETE row trigger