SQL: SELECT Statement Pulling first 500 records from massive query. Joins of tables
Database Administrator Interview Questions
3,442 database administrator interview questions shared by candidates
Technical UDB questions.
How to handle complex environments?
why you preferred our company?
As a technical candidate I was asked on some functional aspects of the skills I meant to serve with
Why JPMorgan Chase?
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?
During HR interview , one question asked was regarding the challenges I faced in my career.
Write a query using HAVING clause.
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 531 - 540 interview questions
See Interview Questions for Similar Jobs
Database AnalystDatabase ManagerData EngineerOracle DbaData AnalystDatabase EngineerDatabase AdminBusiness Intelligence ConsultantSql DeveloperNetwork AdministratorData Warehouse ArchitectMachine Learning ScientistDatabase DeveloperSystem AdministratorMining EngineerData Warehouse ManagerDba ManagerAb Initio DeveloperDatabase Architect