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

Oracle (3259)
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,

2937

where do i find oracle interview questions.

1 4111

real time applications of nullif?

3 6099

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

TCL, Wipro,

2086

what is data independence exactly? give an example

6 42179

waht is the difference between primary key and super key?

9 32063

what is the difference between Delete and Truncate

CarrizalSoft Technologies, Geo Research Centre,

4 8742

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

8 10445

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

4 14344

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 10396

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 7200

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

TCS,

2101

what is normalization

NIC,

2 5787

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

Satyam,

2 5726

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

2 6102

Un-Answered Questions { Databases }

How to use multiple database server in back end ?

1052

What is the syntax of update document?

What is the difference between null value, zero, and blank space?

1214

Why do we need database normalization?

1009

What is a schema? How is it useful in sql servers?

1139

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

121

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

2145

Define implicit and explicit cursors.

1150

What is rdbms data?

929

What is precedence constraint?

996

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2041

What is a full join?

1002

What is a foreign key constraint?

1030

How can I create database in mysql?

939

How is indexing done in search engines?

988

For More Un-Answered { Databases } Questions Click Here