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?
Database Interview Questions
5,240 database interview questions shared by candidates
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
What is your past experience?
previous company role Processes errors regular issues faced
About my prior experience and work related basic knowledge.
Viewing 771 - 780 interview questions
See Interview Questions for Similar Jobs
Sql DatabaseDelphi DeveloperJunior Database DeveloperJunior Database AdministratorSql Database DeveloperSenior Database DeveloperEntry Level Database DeveloperProgrammer Analyst Sql Server DeveloperJunior Programmer AnalystVba Excel DeveloperMis Reporting AnalystSql Server Database DeveloperDatabase SpecialistTrading Systems Support AnalystSql Server DatabaseFilenetSql ServerSql