Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: interview-question

Recover Oracle database after drive loss Interview Question

By adminPosted on November 25, 2022

Question : How would you answer this as an interview question? The database crashed and you lost a drive containing […]

Performing SQL string manipulations on a single column

By adminPosted on November 17, 2022

Question : I recently came across a problem at an interview which I wasn’t able to answer. The ask was […]

SQL Login cannot connect to Database

By adminPosted on August 10, 2021

Question : Recently I attended one interview and this was the question: Many Users reported that they are not able […]

Efficient way to join two tables with one to many relationship

By adminPosted on July 19, 2021

Question : This is interview question asked to me in interview and i was not able to answer. Please help.. […]

List population of provices (SQL Query)

By adminPosted on March 7, 2021

Question : I was asked this question in an interview and I could not get my mind around it, and […]

Recovering from the loss of datafile in NOARCHIVELOG mode?

By adminPosted on October 24, 2020

Question : How do you recover from the loss of datafile if the database is running in NOARCHIVELOG mode? Answer […]

Recent Posts

  • how to find out the log backups that I need to restore in order to bring log shipping from standby to online?
  • Embedding JSON in a string
  • SQL Server – Identical query on near identical database takes 20 seconds on sql2012 but does not complete after 50+ hours on sql2014
  • RMAN list archivelogs that are needed for to recover specified backup
  • Minimizing SELECT latency in PostgreSQL
  • Replication from EC2 Master to RDS Slave – Connecting to master
  • How to index range condition and ordering by a different colum?
  • Bi-directional synchronization between local SQL Server 2005 and a SQL Azure using SQL Data Sync
  • What queries are supported by MySQL but not PostgreSQL?
  • MYSQL: What is the benefit of compound indexes, over separate ones?
  • Help with relational database design
  • Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
  • How to prevent memory optimized tables from blowing out OPT_MEMORY_OPTIMIZED$HKv2
  • MySQL Workbench connect to MS Access
  • Remove duplicate values from query result
  • Primary key guarantees: duplicates and nullity
  • Postgresql Vacuum and replication
  • Is the overhead of frequent query cache invalidation ever worth it?
  • MongoDB deleted logs
  • TSQL Copy an existing database

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding