Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

How can set the multipal database ?

CitiGroup,

1 3043

where do i find oracle interview questions.

1 4192

real time applications of nullif?

3 6252

Which is the best place or learning center for MS SQL?????In Bangladesh?????

TCL, Wipro,

1 2129

what is data independence exactly? give an example

6 42460

waht is the difference between primary key and super key?

9 32380

what is the difference between Delete and Truncate

CarrizalSoft Technologies, Geo Research Centre,

4 8962

from the table display the 2nd highest salary? and also the least 2nd salay?

8 10733

what is the output for this query select * from employee where 1=1;

4 14576

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 10691

Table student containing 2 columns,Join date,Employee name. Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar- 2008,4-feb-2008.Under Employee name 4 difeerent names jaison,robin,binoy,rahul Result set is, Table containing 4-column name=jan,feb,mar,april,,beneath these months count is given as 1,2,1,0 means these counts representing number of emplooyees joined in a month(january 1employee,february 2 employee,march 1 employee,april 0 employee) Can you give me the required sql query

RND Soft, Wipro,

3 7330

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

TCS,

1 2157

what is normalization

NIC,

2 5957

How can we know the exact updation date of a particular database?

Satyam,

2 5844

I have two sql database at different PC.how can link b/w database and database tables.

2 6231

Un-Answered Questions { Databases }

List the ways in which dynamic sql can be executed?

1083

Is inner join faster than left join?

1273

what is bcp? When does it used? : Sql dba

1053

Have you written applications to retrieve stored images in a table?

1083

How can I check that whether automatic statistic update is enabled or not?

1108

Can you index views?

952

What are the steps in creating a database?

1004

What are the kinds of subquery?

1100

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1901

Why use identity in sql server?

1191

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1127

How do I create a trace in sql server?

1112

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

Why we use the openxml clause?

1072

Can we do dml on views?

1032

For More Un-Answered { Databases } Questions Click Here