Database Interview Questions and Answers
Ques:- give a simple example of physical and logical data independence
Ques:- Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you’d like to do a diagram that will be great.please answer it
Ques:- What is the difference between specialization and generalization?
Ques:- What is a sequence? Explain it with one example?
Ques:- What is the candidate key used for?
Ques:- What is the difference between primary and candidate key?
Ques:- What does specialization in DBMS mean?
Ques:- What is the function of cluster index?
Ques:- How concurrency problems effect the database?
Ques:- How does non-cluster index functions?
Ques:- What are the tools used for backup and ticketing?
Ques:- What is the difference between oracle and MS Access?
Ques:- how can we view column head in first page but not in remaining pages?
Ques:- if i want to display the name of students such that to which city they belong must have count greaer than two
Ques:- Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
Ques:- Which three commands cause a transaction to end?
Ques:- You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
Ques:- how to implement dense rank in rank transformation in Informatica? so that output should be like 1,1,2,3 and not like 1,2,3,4
Ques:- Datatypes are unlimited,true or false?
Ques:- in informatica workflow has 5 sessions and running seqentially and 3rd session has been failed how can we run again from only 3rd to 5th session
Recent Answer : :
use the start workflowfromtask command. this will start the
work flow from a selected task
Ques:- What is sqlcode -923 ?
Recent Answer : :
The connection for the DB2 failed for the reason indicated
by condition,which can be any of the following:
* DB2 not up
* DB2 not operational
* DB2 shutdown in progress
* DB2 restricted access mode
* Allocation error
Ques:- can u combine pipeline parallelism and partition parallalism? how and whan?
Ques:- what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
Ques:- how node connect with cpu?
Ques:- sparse lookup and where its options we find in OCI and db2?
Ques:- what are wrappers and build ups and what it’s use?
Ques:- diff b/w inter process and in process
Ques:- how do you do sql tuning?
Ques:- CLI stands for?
Recent Answer : :
Command Line Interface
Ques:- how can you perform lookup range in lookup stage expalin in detail?
1) Data should be sorted in the order we are expecting the
ranks to be
2)At expression level manipulating variable using the
iteration logic to generate the ranks comparing the current
record with the previous record