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 ...
How do you recover a lost datafile if: the database is running in archivelog mode there is no backup is available
How do you recover from the loss of datafile if the database is running in NOARCHIVELOG mode?
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 ...
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, ...
I have read the definition of 1NF which is, "If each attribute of relation is atomic". Please tell me what is Atomic.
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 ...
I need a short explaining of clustered index. What is a clustered index? What are best practices for using the clustered index?