Interview Questions

Q:

Define PL/SQL. Explain its purpose

Answer

PL/SQL is Procedural Language SQL that is an extension of SQL that results in a more structural language composed of blocks. It is mainly used in writing applications that needs to be structured and has error handling.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2290
Q:

What is separation in HRM?

Answer

Separation of an employee exists when the service of an employee comes to an end because of one reason or other. "Separation of employment" refers broadly to the process of managing the termination of employment. It is a sensitive issue for any organization. 


 


Types of separation:


 


1) Volunntary:


a) Resignation
b) Job abandonment
c) Retirement


 


2) Involuntary:


a) Layoff
b) Dismissal
c) Plant closure
d) Death or Disability.

Report Error

View answer Workspace Report Error Discuss

1 2288
Q:

What is the self-referencing constraint?

Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Report Error

View answer Workspace Report Error Discuss

0 2288
Q:

What is the difference between a primary key and a unique key?

Answer

By default, primary key creates a clustered index on the column, whereas a unique key creates a non clustered index by default.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2288
Q:

Why Do You Want to Work Here?

Answer

The interviewer is listening for an answer that indicates you've given this some thought and are not sending out resumes just because there is an opening. For example, "I've selected key companies whose mission statements are in line with my values, where I know I could be excited about what the company does, and this company is very high on my list of desirable choices."

Report Error

View answer Workspace Report Error Discuss

Subject: About Yourself

10 2288
Q:

Which investment type typically carries the least risk?

A) Mutual funds B) Treasury bonds
C) Savings account D) Individual stocks
 
Answer & Explanation Answer: C) Savings account

Explanation:

Different types of risk exist in ivesting schemes depending on what you've invested in.

 

Savings accounts are generally regarded as the least risky investments as in this we just save our wealth for future expenses.

Report Error

View Answer Report Error Discuss

Filed Under: Bank Interview
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

0 2287
Q:

Are arrays primitive data types?

Answer In Java, Arrays are objects.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2287
Q:

You can use Keyword Planner to identify

A) Determine which Google Ads experience you're using. B) Which text ads are performing best based on your keywords
C) Webpages where ad can appear based on your keywords D) The amount of traffic potential keywords might get
 
Answer & Explanation Answer: D) The amount of traffic potential keywords might get

Explanation:

You_can_use_Keyword_Planner_to_identify1554271615.jpg image

Report Error

View Answer Report Error Discuss

4 2285