Add office photos
Filter interviews by
Delight HR Services Oracle SQL and PLSQL Developer Interview Questions and Answers
Delight HR Services Oracle SQL and PLSQL Developer Interview Experiences
1 interview found
(2 Questions)
- Q1. Tell me structure of log file in concurrent program
- Ans.
The log file structure in concurrent program
The log file is a text file that contains information about the execution of a concurrent program
It includes details like start and end time, parameters passed, and any errors encountered
The log file is stored in the $APPLCSF/$APPLLOG directory on the application server
The file name follows a specific naming convention:
_ .log
- Q2. Tell me full details of code of cp
- Ans.
Cannot answer without more context. Need to know what 'cp' refers to.
Need more information about what 'cp' is referring to in order to provide a full code explanation.
Without context, it is impossible to provide a meaningful answer.
Please provide more information about the specific code or program in question.
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
Vjkghijk K
(1 Question)
- Q1. What is joins with syntax
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Syntax for joins typically involves specifying the tables to join, the columns to join on, and any additional conditions
(1 Question)
- Q1. Questions majorly from joins, how to find max salary,max sales of a product, set operators, sub-query, procedure, functions and packages.
Selected
I applied via Naukri.com and was interviewed in Aug 2022. There were 2 interview rounds.
(1 Question)
- Q1. Initial screening from teamware and next level of round of techies discussion from client team.
(1 Question)
- Q1. SQL basic and moderate level questions
(2 Questions)
- Q1. WRITE A PROCEDURE WHICH U WRITTEN LAST?
- Ans.
I wrote a procedure to calculate the average salary of employees in a department.
Used cursor to fetch employee data
Calculated total salary using loop
Divided total salary by number of employees
Handled exceptions for zero employees in department
- Q2. MERGE CONCEPT RELATED
Interview Preparation Tips
SQL Server Database Administrator Interview Questions & Answers
Teamware Solutions
Anonymous
posted on 22 Mar 2022
(1 Question)
- Q1. Sql dba related questions
(1 Question)
- Q1. Package discussion and
Interview Preparation Tips
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
(1 Question)
- Q1. Technical Questions related to job role.
Interview Preparation Tips
Delight HR Services Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Plsql Developer Interview Questions
- Senior Plsql Developer Interview Questions
- SQL Developer Interview Questions
- SQL Database Administrator Interview Questions
- MS SQL DBA Interview Questions
- SQL and PL SQL Developer Interview Questions
- SQL Server Developer Interview Questions
- SQL Server Database Administrator Interview Questions
- Show more
Interview Questions from Similar Companies
|
HR Recruiter
3
salaries
|  ₹1 L/yr - ₹2 L/yr |
|
Senior Talent Acquisition Executive
3
salaries
| ₹2.4 L/yr - ₹4.8 L/yr |
Randstad
Team Lease
Innovsource Services
Evision Technoserve
- Home >
- Interviews >
- Delight HR Services Interview Questions >
- Delight HR Services Oracle SQL and PLSQL Developer Interview Questions
