I have more than 5 years of experience and Ivy League degrees.

After a 10-minute phone screening, the recruiter emailed me a test. I wrote and tested my code before sending it for evaluation.

Overall, these guys are very unprofessional. Jerks!

Write an efficient stored procedure to allocate unique integer IDs.

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

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?

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:

And your program is invoked as follows: tasktree –t 1

It will produce this output:

Eat Lunch Choose restaurant Order food Call restaurant

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