Interview questions

Database Administrator (dba) interview questions – page 9

1,040 questions. Tap “Show answer” to check yourself.

  1. Which function is used to accesses the Properties fromRepository

  2. What r the type of indexes u generally used in informatica?

  3. WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.

  4. What are the output files that the informatica server creats during running a session?

  5. Ex: take one schema in that t1,t2,...tn tables and youdon't no the table name also.write a procedure if enter columns name then display themaching columns .otherwise display the unmatch columns.

  6. Have you consider starting your own business?

  7. I have n number of records in my source, i want first andlast record to my target. how can u implement this scenario .

  8. By seeing the parameter file how do u identify wheather itis a workflow parameter or mapping parameter?

  9. What is the difference between view and table ?

  10. What are the joins,types of joins and thier functions?

  11. Write s sql query following table some duplicate present i want unique one column duplicate another column display?name ida 1a 1b 2b 2c 3 i want the required output likeunique duplicatename id name ida 1 a 1b 2 b 2c 3

  12. How to know if there are expensive sql statementsrunning?what will you do then to improve the response time?

  14. I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

  15. What motivates your best work?

  16. In bankingdomain projects how many dimension tables are there?

  17. How can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

  18. Disply the dname wise maximum salary

  19. If i have records like these(source table)rowid name10001 gdgfj10002 dkdfh10003 fjfgdhgjk10001 gfhgdgh10002 hjkdghkfhthe target table should be like these by using expression tranformation.(Target table)rowid name10001 gdgfj10002 dkdfh10003 fjfgdhgjkxx001 gfhgdghxx002 hjkdghkfh(that means duplicated records should contain XX in there rowid)

  20. In SCD type 2 if we had select date range.then suppose we had inserted today's date(eq. date is 30 aug2010) then start date will be today's date(30 aug 2010)what will be the end date,we cant leave it blank?

  21. Can we use unconnected lookup as dynamic lookup?

  22. How can you load data into target table without leading zeor's

  23. How we can get unique records into one target table andduplicate records into another target table?

  24. What is the difference between a HAVING CLAUSE and a WHERECLAUSE?

  25. There are three tables :E : EID,ENAMED : DID,DNAMEempdept : eid, didselect the employees who doesn't belong to any dep

  27. What is global temporary tables and how use that tables inpl/sql packages

  28. If we have 1000 rows were loaded in to datawarehouse andnext day the source have 1010 rows so, how can we loadedonly updated rows into target.

  29. Difference between DELETE and TRUNCATE

  30. What are the table created when you created a infoobject

  31. How do you deal with stress?

  32. What is the difference between lookup override and souce qualifier override ?

Companies that ask Database Administrator (dba) questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide