questions related to the topics cursors,triggers,packages,sql functions,views and materialized views exceptions and other few questions
Junior Database Developer Interview Questions
5,218 junior database developer interview questions shared by candidates
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.
explain a mistake you made and how you dealt with it
How would you fix our database?
How would you design a resilient and scalable backend system to process financial transactions using event-driven architecture?
What are my career goals?
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 771 - 780 interview questions