1) Write procedure based upon scenario. 2) Write function to count vowels of a string. 3) Index conceptual questions (data will be inserted faster on table with index or without index table, purpose of indexing) 4) Oracle Data Dictionary questions (oracle supplied packages, tables etc.)
What is scope_identity? What are analytical functions?
sql queries joins indexes views
Sql server job activity, profiler
Tell us about yourself and your experience as a Database Administrator. Why do you want to work for our company? What motivates you in your career as a DBA? Describe a challenging situation you faced as a DBA and how you resolved it. How do you handle stress or tight deadlines? How do you prioritize your tasks when managing multiple projects? How do you keep yourself updated with the latest developments in database technologies? Can you describe a time when you had to work as part of a team? How would your previous colleagues describe you? Where do you see yourself in the next 3-5 years in your DBA career?
About past experience and technologies I know
log shipping, mirroring, clustering, Always on
difference between udf and stored proc
Cursor and sub queries, trigger and many more
soft skills and multiple scenario based questions
Viewing 1541 - 1550 interview questions