I was asked about the Oracle DBA technical skills
Database Administrator Interview Questions
3,074 database administrator interview questions shared by candidates
How would you identify a long running query? How would would find out the execution plan of that query? If you have a SPID how could you see what query that spid was executing? Name the types of waits in SQL-Server? What do they mean? Is there another way besides SQL Server Profiler, Extended Events and Performance Monitor to see waits, I/O, etc? What is the difference between an Implicit and Explicit query in SQL? With a large database using Blobs what sort of configuration changes do you have to make? How do you setup indexing specifically? What steps do you take to tune SQL queries? How would you go about rewriting a poorly performing query? How could you tell where indexes were missing? Why would you choose SQL-Server over Oracle?
Totally on Real application clusters
Where do you see yourself in 5 years?
General DB questions + drill down in performance tunnning question + they have one short coding like test where you need to execute queries
Tell about yourself and
How I prefer to get paid
Write the logic for Fibonacci series. Write code for the pyramid pattern.
Do you know Rami Reddy
describe what happenes when there is update to rows (in terms of database internals)
Viewing 711 - 720 interview questions
See Interview Questions for Similar Jobs
Data EngineerDatabase AnalystDatabase ManagerDatabase AdminData Warehouse ArchitectDatabase ArchitectAb Initio DeveloperDba ManagerMining EngineerData AnalystData Warehouse ManagerMachine Learning ScientistOracle DbaSystem AdministratorDatabase EngineerNetwork AdministratorDatabase DeveloperSql DeveloperBusiness Intelligence Consultant