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

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

IBM, Oracle,

1 4615

which is the best training centre for learning oracle?

13 19558

what is the difference between unique and primary key

5 6118

Please let me know if UNION ALL and Natural Join does the same operation and are same...

iGate,

7 14942

what are the differences of where and if in SAS?

2214

how to generate XML out of QUERY?

McAfee,

1 5207

How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

Infosys, McAfee,

5 10983

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

Intelenet,

8 32916

hi i gone though satyam interview. what is Acid Properties?

Satyam,

2 5993

what are batch in sql server?

Satyam,

2 10102

Difference Between varchar and nvarchar datatype?

Satyam,

3 14278

Difference between sql server 2000 and sql server 2005?

Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,

11 53251

what is normalization? what is denormalization?

Satyam,

9 35165

what is extended StoreProcedure ?

Satyam,

3 6864

Different Types of Functions ?

Satyam,

2 12767

Un-Answered Questions { Databases }

What is sql server query analyzer?

1046

when is the use of update_statistics command? : Sql dba

1060

What is the best database software for small businesses?

940

Which database is best to learn?

576

What is partition by in sql?

1084

You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?

626

Why use mysql procedures?

996

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1174

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2038

How do I install mysql?

921

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2299

What is tns name?

996

What is correlated subquery in dbms?

1012

Are views faster than queries?

1013

What mysql -u john -p command does?

989

For More Un-Answered { Databases } Questions Click Here