Where do you see yourself in 5 years?
Database Administrator Dba Interview Questions
3,442 database administrator dba interview questions shared by candidates
It was good in terms of technical questions,
Pediria demissão?
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?
Describe the different DG Availability modes
Do you know Rami Reddy
Describe your biggest professional achievement.
describe what happenes when there is update to rows (in terms of database internals)
In addition to port 1433, what other port is open on a default MS SQL server instance (which can be used as a backup port in case of emergency)?
What kind of medical experience do you have?
Viewing 781 - 790 interview questions