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.)
sql queries joins indexes views
Introduction SSIS transformation Difference between union all and merge Difference between conditional split and multicast Scenario based questions Query to delete duplicate records
log shipping, mirroring, clustering, Always on
Basic Plsql interview questions
what are M views. How do you refresh them
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?
talk about ETL, textual operations, data warehouse knowledge
What you know about mongo db and how we take backup on mongodb
What is oracle form?
Viewing 1541 - 1550 interview questions