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

what is the diffrence between before parameter form triger & formate trigger

2 4380

How to get the count of distinct records. Please give me the query?

Value Labs,

8 13334

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

Value Labs,

4 7872

Please give me queries for the following 1. To get the count of duplicate records. 2. A query to delete the duplicate records.

247Customer,

3 6832

How to add Foreign key in a table after the creation of the table?

Satyam,

5 11801

How to copy a table in another table with datas?

9 14354

Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!

1 3896

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2408

How to get the 3rd column(i.e all the data along with the column name)in a table?

Logica CMG,

2 8163

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4185

How to restrict the duplicate records in table valuesets

IBM,

2 7316

what are pl/sql collections?

JPMorgan Chase, Oracle,

4 32155

can we use out parameter in a function?Give an example.

Logica CMG, TCS,

4 16201

how to count datewise data in sqlserver

CarrizalSoft Technologies, IndusInd Bank,

4 15242

how to pass 2 variables from one form to other form

Intelligroup,

2 8068

Un-Answered Questions { Databases }

What is the difference between now() and current_date()?

992

What are the sql aggregate functions?

1143

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1058

What is the primary use of normalization?

1023

What are dml commands?

1029

What is the max number of columns in an oracle table?

1012

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1009

What does the update command do?

1124

How can you add and remove any column of a table?

953

What are the database objects?

1070

How do you start a database?

907

What is a database lookup?

1107

Does postgres support clustering?

859

Explain correlated query work?

1061

what is 'mysqlcheck'? : Sql dba

1023

For More Un-Answered { Databases } Questions Click Here