Interview Questions

BDC ----> Batch Data Communication 

Methods of BDC-----> Direct Input method, Batch Input Session method, Call transaction method.

Sometimes it's best to talk about short-term and intermediate goals rather than locking yourself into the distant future. For example, "My immediate goal is to get a job in a growth-oriented company. My long-term goal will depend on where the company goes. I hope to eventually grow into a position of responsibility."

To use an iterator to traverse through the contents of a collection, follow these steps:

- Obtain an iterator to the start of the collection by calling the collections iterator() method.

- Set up a loop that makes a call to hasNext(). Have the loop iterate as long as hasNext() returns true.

- Within the loop, obtain each element by calling next().

A stored procedure is a segment of declarative SQL statements stored inside the database catalog. A stored procedure can be invoked by triggers, other stored procedures or applications such as Java, C#, PHP, etc.

Advantages 

- Typically stored procedures help increase the performance of the applications. Once created, stored procedures are compiled and stored in the database. However MySQL implements the stored procedures slightly different. MySQL stored procedures are compiled on demand. After compiling a stored procedure, MySQL puts it to a cache. And MySQL maintains its own stored procedure cache for every single connection. If an application uses a stored procedure multiple times in a single connection, the compiled version is used, otherwise the stored procedure works like a query.

- Stored procedures helps reduce the traffic between application and database server because instead of sending multiple lengthy SQL statements, the application has to send only name and parameters of the stored procedure.

- Stored procedures are reusable and transparent to any applications. Stored procedures expose the database interface to all applications so that developers don’t have to develop functions that are already supported in stored procedures.

- Stored procedures are secure. Database administrator can grant appropriate permissions to applications that access stored procedures in the database without giving any permission on the underlying database tables.

Disadvantages

- If you use a lot of stored procedures, the memory usage of every connection that is using those stored procedures will increase substantially. In addition, if you overuse a large number of logical operations inside store procedures, the CPU usage will also increase because database server is not well-designed for logical operations.

- A constructs of stored procedures make it more difficult to develop stored procedures that have complicated business logic.

- It is difficult to debug stored procedures. Only few database management systems allow you to debug stored procedures. Unfortunately, MySQL does not provide facilities for debugging stored procedures.

-It is not easy to develop and maintain stored procedures. Developing and maintaining stored procedures are often required specialized skill set that not all application developers possess. This may lead to problems in both application development and maintenance phases.

The main objectives of an Industrial relations system are: 

- To protect the interest of employees and employers by building up a congenial relationship. 

- To avoid the human conflicts which can harm the business, the employees and the economic growth of the country.

- To increase the productivity. 

- To improve the economic conditions of the workers

- To reduce the number of industrial disputes like strikes, lock outs etc.

All my bosses enchanted some skills worth learning. I have always used to learn something new from them along with my ex-boss.

First we need to create an instance of a JDBC driver or load JDBC drivers, then we need to register this driver with DriverManager class. Then we can open a connection. By using this connection , we can create a statement object and this object will help us to execute the query.

Why are they asking?

The interviewer wants to find out the following:

  -How committed are you to the career and the company
  -How much do you understand about the career path ahead of you
  -How passionate are you

Approach 
Research the job and the organization structure and relate your career plan and progression with the job posting and progression of the company.

Eg.
I would like to work hard and grow with the company to a respectable position with additional challenges and responsibilities and contributing to success of the company.

Please don't give these answers...
"Doing your Job"
"Working somewhere else"
"No idea"
"I haven’t thought that far ahead"
"Have a family"