PL/SQL Developer | How to hire | Resources for technical recruitment

Used for hiring

PL/SQL Developers
Oracle SQL Developers

Skills required

Understanding of the Oracle database, utilities, and tools

Knowledge of PL/SQL packages and triggers

Awareness of data analysis, data modeling, design, and implementation.

Knowledge of implementation and and design of ETL processes using ORACLE built-in functions

PL/SQL Developer Assessment

You can test a candidate on the following areas to assess their proficiency in PL/SQL

  • Knowledge of SQL
  • Basic understanding of .NET frameworks is helpful
  • Knowledge of SQL design skills
  • Knowledge of database modelling and RDBMS concepts

How this test helps with hiring PL/SQL candidates

Steps to assess PL/SQL Developers
Create a test
Create a test
Add questions to assess PL/SQL skills
Add questions to assess PL/SQL skills
Send invites to candidates
Send invites to candidates
Evaluate the report
Evaluate the report
Assess PL/SQL developers for free   
Common types of assessments used by our top customers

Programming questions to assess SQL skills

10 MCQs on
SQL skills

10 MCQs on
database management and .NET Framework

Sample questions

You have created a PL/SQL cursor that is declared in a package specification. Which of the following statements about this cursor is correct?

  • The cursor can be opened in one PL/SQL block and fetched in another block within the same schema session.Correct Answer
  • The cursor is automatically opened when any package construct is invoked.
  • The cursor name cannot be repeated because it is unique to a schema.
  • The cursor is never closed until the schema is disconnected.

What is the output of the following PL/SQL query:

"Create of Replace Function Tax-Amt Return Number is Place_wise_tot_tax : = 0; Begin Select sum(TaxAmt) from Tax where location = Place; Place_wise_tot_tax = TaxAmt; Return Place_wise_tot_tax End Tax-Amt; "

  • Returns the tax amount
  • Returns the place name
  • Error Correct Answer
  • None of these

What happens when you submit the following code to the SQL*PLUS client interface?

"CREATE OR REPLACE FUNCTION GET_TOTAL (student_id IN OUT NUMBER) RETURN NUMBER AS Total NUMBER(10); BEGIN SELECT COUNT(*) INTO total FROM STUDENTS_MARKS_TAB WHERE STUDENT_ID = student_id; END; "

  • Parsing error because the IN OUT parameter type is unacceptable in functions
  • Parsing error because there is no RETURN statement at the end of the function
  • Parsing error because the parameter student_id cannot have the same name as the column STUDENT_ID in the STUDENT_MARKS_TAB
  • Function will be created successfullyCorrect Answer

</Want us to help you create a PL/SQL Developer Assessment?>

Top customers using HackerEarth to hire developers

Barclays Logo
General Electrics Logo
Government of Canada Logo
Nokia Logo
Northern Trust Logo
Thoughtworks Logo
UBS Logo
Walmart Logo