Interview Questions

Q:

How will you find the 3rd max salary in the employment table?

Answer

SELECT DISTINCT(salary) FROM emp as e1 


WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2  WHERE e1.salary <= e2.salary)

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

1 2761
Q:

what is flat aggregation?

Answer

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

Report Error

View answer Workspace Report Error Discuss

0 2759
Q:

What can you do for us that others can't?

Answer

This will take an assessment of your experiences, skills and traits. Summarize concisely: "I have a unique combination of strong technical skills, and the ability to build strong customer relationships. This allows me to use my knowledge and break down information to be more user-friendly."

Report Error

View answer Workspace Report Error Discuss

Subject: About Yourself

11 2758
Q:

What divisions, sections and paragraphs are mandatory for a COBOL program?

Answer

IDENTIFICATION DIVISION and PROGRAM-ID paragraph are mandatory for a compilation error free COBOL program.

Report Error

View answer Workspace Report Error Discuss

0 2756
Q:

Why interface method is always public?

Answer

To make this method available to every implementation class

Report Error

View answer Workspace Report Error Discuss

Subject: Java
Job Role: IT Trainer

0 2756
Q:

Describe a time when your workload was heavy and how you handled it?

Answer

When I was working on a software employment team at XYZ Company, we took over one more company and had to turn many clients to a new product in a short period of time. It took a lot of planning, hard work, time and effort, but we were able to finish the project in a timely manner.


 

Report Error

View answer Workspace Report Error Discuss

1 2755
Q:

How can we call DDL statements like CREATE, DROP, TRUNCATE, etc. from PL/SQL?

Answer

EXECUTE IMMEDIATE command can be used to call DDL statements. 


Example:


BEGIN


EXECUTE IMMEDIATE  'TRUNCATE TABLE employee';


END;

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2755
Q:

What procedure you will follow when taking a customer’s call?

Answer

Answer this question around the following steps :


1. Greet customer.


2. Tell your name to the customer.


3. Ask customer how you can be of any assistance to him/her.


4. Listen carefully and patiently to the customers query or requirement.


5. Provide the customer with the best solution or assistance without making him/her wait for long.


6. Inquire if customer is satisfied with the assistance or help provided.


7. Ask the customer if he needs any further assistance.

Report Error

View answer Workspace Report Error Discuss

Subject: Call Center

2 2755