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

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

2 4512

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

Value Labs,

8 13702

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 8075

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 7002

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

Satyam,

5 12016

How to copy a table in another table with datas?

9 14639

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 3993

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

1 2474

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

Logica CMG,

2 8256

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

1 4251

How to restrict the duplicate records in table valuesets

IBM,

2 7422

what are pl/sql collections?

JPMorgan Chase, Oracle,

4 32351

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

Logica CMG, TCS,

4 16395

how to count datewise data in sqlserver

CarrizalSoft Technologies, IndusInd Bank,

4 15429

how to pass 2 variables from one form to other form

Intelligroup,

2 8186

Un-Answered Questions { Databases }

how to start mysql server? : Sql dba

1258

Does view occupy space?

1005

How do I start sql server 2017?

1011

Have you written applications to retrieve stored images in a table?

1083

What are the steps in creating a database?

1004

How to start an oracle instance?

1096

what are aggregate and scalar functions? : Sql dba

1122

Can delete statement be rollbacked?

1050

what is the difference between openrowset and openquery?

1186

what is bcp? When does it used? : Sql dba

1053

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1947

Can one drop a column from a table?

1081

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1291

How to use values from other tables in update statements using oracle?

1147

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2291

For More Un-Answered { Databases } Questions Click Here