Interview Questions

Q:

Name any three PL/SQL exceptions?

Answer

Too_many_rows.


No_Data_Found.


Zero_Error.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 2256
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 2254
Q:

As a wholesaler what are the problems you would face in ensuring the commitment to your retail suppliers?

Answer

As a wholesaler, applicant should say that he/she would face production problem, growing consumption, not concentrating on important market segment, scale of operations not being proper, delivery to different stores and having some issues with suppliers and not a good relationship with suppliers. I would face these problems in reaching the target commitment to suppliers as a wholesaler.

Report Error

View answer Workspace Report Error Discuss

Subject: Retail

1 2248
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 2248
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 2248
Q:

What is the purpose of garbage collection in Java, and when is it used ?

Answer

The purpose of garbage collection is to identify and discard objects that are no longer needed by a program so that their resources can be reclaimed and reused. A Java object is subject to garbage collection when it becomes unreachable to the program in which it is used.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2248
Q:

What is the SimpleTimeZone class?

Answer

SimpleTimeZone is a concrete subclass of TimeZone class. The TimeZone class represents a time zone, that is to be used with Gregorian calendar.


The SimpleTimeZone is created by using the base time zone offset from GMT time zone ID and rules, for starting and ending the time of daylight.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2247
Q:

Tell me the importance of a flow chart?

Answer

The flow chart gives a clear graphical representation of an implemented process. This makes the system simple to understand for all persons involved in the project. 


 

Report Error

View answer Workspace Report Error Discuss

0 2247