Interview questions

Database Administrator (dba) interview questions – page 8

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

  1. Difference between informatica 8.6 and 9

  2. Give me an example of your creativity (analytical skill?managing ability, etc.)

  3. How could we generate the sequence of key values without using sequence generator transformation in the target ?

  4. Can we create a clustered index on composite primary key.

  5. How can we add a column to a table without altering the same?

  6. What are the difference between clustered and a non-clustered index?

  7. What is the necessity to use update strategy?(except forupdates)

  8. I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01-JAN-2007 TO 01-JAN-2008?

  9. How to get the 2nd highest salary of an employee withoutusing any function (I mean without rownum etc.

  10. IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES?SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY?

  11. Difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

  12. What is a template?

  14. What are the Advantages of using CTE?

  15. Difference between temp table and table variable

  16. What is use of batch file in informatica? How many types of batch file in informatica?

  17. Diff bet.. Function and Trigger?

  18. What is a SQL expression?

  19. How many Sub Reports added in One MainReport?

  20. HOW TO PRINT ***************BY USING SQL QUERY? (MAY BE USING SCRIPT)

  21. How we can do session partition in informatica any one explain me clearly?.

  22. My source table having some records ,i want load 1st recordand last record into one target?

  23. Write a query to get 2nd maximum salary in an employee table ?

  24. How to get Top 10 Salaries from a Table

  25. There is a mapping with expression and mapping we createsome condition for insert and update and followed by updatestartegy ,can we update and insert on a single target basedon condition?

  27. Write a query row to column follwing source?quarter salesq1 5000q1 9000q1 7000q1 6000q2 5000q2 4000q2 3000q2 1000q3 4000q3 3000q3 1000q3 2000q4 5000q4 400 i want the output? q1 q2 q3 q4 sales

  28. Is SET a SQL Keyword?

  29. How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

  30. Difference between SET and SELECT

  31. What is the difference between GROUP BY and ORDER BY in Sql?

  32. What do you feel has been your greatest work-related accomplishment?

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