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,

2930

where do i find oracle interview questions.

1 4100

real time applications of nullif?

3 6076

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

TCL, Wipro,

2075

what is data independence exactly? give an example

6 42140

waht is the difference between primary key and super key?

9 32013

what is the difference between Delete and Truncate

CarrizalSoft Technologies, Geo Research Centre,

4 8716

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

8 10409

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

4 14318

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 10368

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 7186

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

TCS,

2082

what is normalization

NIC,

2 5776

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

Satyam,

2 5708

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

2 6087

Un-Answered Questions { Databases }

how can we repair a mysql table? : Sql dba

983

Why do we write stored procedures?

929

Differentiate between a local and a global temporary table?

957

can you instantiate a com object by using t-sql? : Sql server database administration

1004

Explain logical database components? : sql server architect

765

Explain the use of owner option in exp command.

1048

How can we solve sql error: ora-00904: invalid identifier?

1248

Can you get microsoft access for free?

864

What is mysql shell?

988

Which table is left in left join?

1018

How would you check the long running transaction?

914

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2341

Is Mysql query is case sensitive?

1025

What are the functions of a database?

994

Explain what is a column in a table?

1108

For More Un-Answered { Databases } Questions Click Here