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.
-1
votes
2answers
265 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 ...
5
votes
4answers
2k 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, ...
2
votes
4answers
2k 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
417 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 ...
9
votes
2answers
5k 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?