He started out by saying this would be a conversation, not an interview. We spent about 40 minutes talking at a general level about bank, the job and him. Spent about 10 minutes discussing my background. We touched on the importance of prayer to him, and two other team leads that report to him and their roles ant outlook.
Why JPMorgan Chase?
How confident are you wrangling disparate data
Can you migrate Microsft Sql Server 2000 databases to Microsoft Sql Server 2005 server? Do you know how to build Sql Server Reporting services reports? Can you do Sql Server Integration services ETL?
questions related to the topics cursors,triggers,packages,sql functions,views and materialized views exceptions and other few questions
Plsql performane tuning techs
During HR interview , one question asked was regarding the challenges I faced in my career.
Write a query using HAVING clause.
Describe the mysql replication. How does the query speed up in MySQL how does the index works.
Assume a table, task, with the following columns: § task_id (int, Not NULL) § task_description (text, Not NULL) § parent_task_id (int, NULL) Write a stored procedure and program (in any language of your choosing) to produce a text based hierarchical tree of the tasks rooted at a given task, using tabs to show the hierarchy. For example, if these rows exist in the task table: task_idtask_descriptionparent_task_id 1Eat LunchNULL 2Choose restaurant1 3Order food1 4Call restaurant3 5Have staff meetingNULL 6Send agenda5 And your program in invoked as follows: tasktree –t 1 It will produce this output: Eat Lunch Choose restaurant Order food Call restaurant
Viewing 821 - 830 interview questions