Describe the different DG Availability modes
Database Manager Interview Questions
5,609 database manager interview questions shared by candidates
Basic questions of Oracle Databases
I was asked about the Oracle DBA technical skills
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?
Can you describe a time when you had to explain or present a complex subject to a colleague or client in terms they could understand? To date, what was the most difficult data analysis problem you solved? What measures did you take to solve the problem and correct the bad data? \ When you joined your last company, what did you do to get up to speed quickly and be to make a positive contribution in a short time frame? What is important to you in your next position? Why are you interested in this role? Why PCC? Are you ok with working off hours? (2-3 times a month) What are your salary expectations?
General DB questions + drill down in performance tunnning question + they have one short coding like test where you need to execute queries
How do you know if data exists in one table and not in another.
Do you have any questions for us.
Viewing 1191 - 1200 interview questions