Database Administrator Interview Questions in New York City, NY | Glassdoor

Database Administrator Interview Questions in New York City, NY

"Database administrators specialize in ensuring the safety of the client's data. Candidates should be well-versed in database design, security, and backup. Expect a technical-based interview that will test your ability to restore or find a file, manage databases, and increase the efficiency of a backup. Excellent organizational and communication skills will show that you are the right fit for maintaining the company's database."

Top Interview Questions

Sort: RelevancePopular Date

Write an efficient stored procedure to allocate unique integer ids.

1 Answer

CREATEPROCEDURE [dbo].[AllocateUniqueIntIds] AS BEGIN SelectABS(CAST(CAST(NEWID()ASVARBINARY(5))ASBigint))as UniqueIntegerId END Go /* Test the store proc */ Exec [dbo].[AllocateUniqueIntIds] //Not sure if this is the correct answer

explain a mistake you made and how you dealt with it

1 Answer

what view can be used to look back at a past performance problem? They also want to know recovery techniques and RAC. All Oracle unless it's a SQL Server position.

1 Answer

If you have a small project that uses a shared server how do you insure the data cannot be compromised by other users. Some may be DBA's

1 Answer

Describe for me what PCP is in E-Business suite and tell me what processes spawn to allow this to function

1 Answer

Write the sql for deleting duplicate rows from a table without using temporary space.

1 Answer

You have 10 tables that are truncated at the end of every day. They all grow simultaneously throughout the day. How do you avoid fragmentation problems?

1 Answer

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

1 Answer

Provide a code sample from a program you wrote to automate a database related task.

1 Answer

Given your experience, do you expect to take on a lead / management position? because this is not a lead or management position.

1 Answer