Good questions for interviews - should be open-ended with a number of possible answers, of which the best (or least-worst) depending on the situation, available resources, project requirements, etc, is the best one.

learn more… | top users | synonyms

1
vote
0answers
28 views

Retrieve data from without causing any data loss or service interruption [closed]

I have a question I need to answer about how to retrieve data from a production database without being able to mess up up the data. The question (from an interview) is: For your daily work you ...
2
votes
1answer
78 views

Troubleshoot corruption in SQL Server Database [closed]

I have been asked by my interviewer "How do you troubleshoot corrupted data in SQL in SQL Server 2012?"
0
votes
2answers
250 views

Efficient way to join two tables with one to many relationship

This is interview question asked to me in interview and i was not able to answer. Please help.. What is the most efficient way to join two table with one to many relationship between them
1
vote
0answers
39 views

Disable the Task action button

How can I disable the "Tasks ->" button in SQL Server Management Studio? I need to prevent users scripting objects.
17
votes
2answers
2k views

Interview SQL question

Given a table 'employees' employee_id | salary | department_id -------------+--------+--------------- Only using SQL find all the variants of employee-transfers from one department to another, so ...
13
votes
3answers
42k views

I Want to Become a Database Administrator - How Can I Start? [closed]

I just took a database course in my college and found it fascinating. I want to learn more in this field, but I feel a bit lost with how to start. How do I become a database administrator? What are ...
2
votes
2answers
4k views

Recovering a lost datafile with no backup available

How do you recover a lost datafile if: the database is running in archivelog mode there is no backup is available
2
votes
1answer
2k views

Recovering from the loss of datafile in NOARCHIVELOG mode?

How do you recover from the loss of datafile if the database is running in NOARCHIVELOG mode?
-1
votes
2answers
617 views

How to gauge knowledge of a SQL Server DBA? [closed]

Not being familiar with SQL Server, I need to evaluate the knowledge of an SQL Server DBA applicant. The job is mostly about increasing performance and finetuning an existing system. Do you have any ...
6
votes
4answers
5k views

What should I ask at a MySQL DBA interview?

I am a software developer and am helping my team hire a MySQL DBA. The core challenges that we are facing are: Slower queries and performance due to Hibernate. Database management (backups, tuning, ...
4
votes
5answers
15k views

What is Atomic Relation in First Normal Form

I have read the definition of 1NF which is, "If each attribute of relation is atomic". Please tell me what is Atomic.
2
votes
1answer
566 views

Recover Oracle database after drive loss Interview Question

How would you answer this as an interview question? The database crashed and you lost a drive containing one of your control files and another drive containing an entire redo log group. You ...
14
votes
2answers
8k views

What is a Clustered Index?

I need a short explaining of clustered index. What is a clustered index? What are best practices for using the clustered index?