When hiring Oracle DBAs and developers, a lot of questions are asked about Oracle view. Although view is only one of Oracle objects and it is not that significant in my opinion, for some reason managers and business users love views, therefore in interview they usually like to ask more questions on Oracle views. The following are some of questions and answers for you to prepare: (more…)
Be careful about this question. What the interviewers want to know it your knowledge and experience on OLAP DSS, but many candidates missed this point, they explained their DBA experience in general, but failed to answer what is asked. To answer this question correctly, you should provide your knowledge about the characters of OLAP and DSS systems, and how you configure the database to meet the requirements. (more…)
This is a technical interview question to getting your insight of detailed skill sets as an Oracle DBA or developer. Your answer could tell what level of experience in database server and SQL query performance tuning. Your answer could be: (more…)
When interviews want to find out if you do have hands-on experience, they usually ask tools related questions. If you can explain what tools you have used to do what tasks, they assume you have the skills supported by the tools.
As for database design tools, there are many. The most popular ones are: (more…)
Database design is one of the most common topics asked in interviews for application design/development positions. Your answer should mix your design skills with tool experience and cover the database design lifecycle. (more…)
Database design questions is always asked in job interviews for DBAs, database analysts, and database developers. To make interviewers happy, your answer must cover all phases of database design: analysis of business entities, data modeling, build ERD, logical database design, and physical database design. You may also mention the scope of the database, such as number of entities and tables, the size of database, etc. and tell what database design tools you have used.
Suggested answer: (more…)
If you have used any ETL tools, explain it; otherwise say you developed customized scripting process by yourself. (more…)
Database development is a broad term that can mean a lot of things – it could be SQL coding, database backend programming (stored procedures, etc.), database applications, database driven systems, basically building any software systems that use data could be considered database development. Make sure you read the job description carefully to get any clue about what the employer really want you to do.
In general, database development experience is focused on programming on the database server, – writing store procedures, triggers, and packages. In Oracle, you use PL/SQL; in Microsoft SQL Server and Sybase, you use T-SQL. If you can find out what database server they are using, we then can emphases your skill set on the corresponding SQL language. The following sample answer is to target Oracle database development: (more…)
Can you describe data warehousing lifecycle?
Tell us what you know about data warehousing lifecycle?
What are the processes and phases in data warehousing lifecycle?
These are fundamental questions to test your knowledge of data warehousing. To answer the questions, just briefly explain each phase of the lifecycle: (more…)