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 to retrieve daily sal from emp table in oracle 10g

Infosys,

2 7224

What is SQL Profiler and the use of it?

247Customer,

2 5174

What are SQL Jobs, please mention the use of it and how to create them.

247Customer,

1 4811

What are steps required to ENTER DATA INTO DWH?

2 7973

define primary key & secondary key?

2 17562

Write a query to find second highest salary of an employee.

27 29202

which language is used to develop the oracle........?

Infosys,

4 13500

What are the different types of joins and explain them briefly.

3 12007

what is the output of this query selet * from employee where 1=2 ??

11 18970

What is the difference between truncate and delete statement?

CarrizalSoft Technologies, CTS,

6 9196

What is the difference between UNION and UNIONALL?

CarrizalSoft Technologies, CTS,

5 14236

WHAT OPERATOR PERFORMS PATTERN MATCHING?

CarrizalSoft Technologies, CTS,

2 7548

What is the order in which the SQL query is executed? list them in order.

CarrizalSoft Technologies, CTS, Oracle,

5 12106

Can Having clause be used without Group by clause?

CarrizalSoft Technologies, CSC, CTS,

6 43716

difference between truncate and delete ,drop?

3 7545

Un-Answered Questions { Databases }

what is collation? : Sql dba

1224

How to connect php with different port numbers?

1177

What is an indexed view?

1018

Why and when do stored procedure recompile?

1052

Which statement is used in a select query for partial matching?

1239

What is subquery? Explain the properties of a subquery?

1056

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1041

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2046

define sql insert statement ? : Sql dba

1094

What are the advantages of database?

1009

what is schema? : Sql dba

1135

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

2099

When should you use an instead of trigger?

1042

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1841

What is current version of mysql?

1069

For More Un-Answered { Databases } Questions Click Here