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 4376

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

Value Labs,

8 13301

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 7855

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 6814

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

Satyam,

5 11777

How to copy a table in another table with datas?

9 14336

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 3887

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

2401

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

Logica CMG,

2 8152

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

4178

How to restrict the duplicate records in table valuesets

IBM,

2 7301

what are pl/sql collections?

JPMorgan Chase, Oracle,

4 32146

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

Logica CMG, TCS,

4 16190

how to count datewise data in sqlserver

CarrizalSoft Technologies, IndusInd Bank,

4 15230

how to pass 2 variables from one form to other form

Intelligroup,

2 8053

Un-Answered Questions { Databases }

How to take user input in pl sql?

1168

How do I view a procedure in sql?

978

Is oracle an operator?

932

How many columns can a postgres table have?

798

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2048

what are different types of keys in sql?

1158

What type of database is access?

915

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1233

What is tableplus?

890

What is table join?

1127

What are the beneficial tools for administering the database?

543

explain how to create a new schema in a database? : Sql server database administration

1111

Explain what is lock escalation and what is its purpose?

933

Explain defncopy and it's usage?

978

How do I fix a crashed mysql database?

964

For More Un-Answered { Databases } Questions Click Here