</How to hire>
PL/SQL Developer
An extension to SQL, PL/SQL helps developers combine SQL with procedural statements. It provides the functionality of decision making, iterations, and many other features. Developers can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces.
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
Add questions to assess PL/SQL skills
Send invites to candidates
Evaluate the report
Common types of assessments used by our top customers
Programming questions to assess SQL skills
SQL skills
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
