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 difference between Triggers and store procedure?

2 5742

How reterive duplicate value in SQL?

6 10973

What is Transaction?

2 5931

I am using ms access and am stumped trying to determine the last three entries ( by date ) for each name in the database. Any help would be appreciated.

1 4419

How to see the database architecture in MySQL??

3 6096

What do u mean by orphan users, how will u list them in the DB

IBM,

2 6858

What is the use of MOVE keyword in restore command

IBM,

3 6324

How will u find the query which is running in some other machine

CarrizalSoft Technologies, IBM,

4 7127

What is the role that is required for killing a process What is the role that is required for creating a linked server

CarrizalSoft Technologies, IBM,

1 4509

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

CarrizalSoft Technologies, IBM,

3 7929

how to pass 2 parameters from one form to other in oracle applications?

1 7740

how to pass 2 variables from one form to other form

1 4042

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 4406

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 3934

1.Explain the three levels with the help og a diagram.

Baidu,

1 6540

Un-Answered Questions { Databases }

What is the current version of postgresql?

1167

What is in place upgrade in sql server?

1123

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1207

Do we need to rebuild index after truncate?

1128

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1064

What are the different subsets of sql?

1646

List the ways in which dynamic sql can be executed?

1083

What versions of clipper does netlib support?

1086

Can we shrink data file in sql server?

1123

What is a coalesce function?

1275

Can delete statement be rollbacked?

1050

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

1947

What is a concurrency problem in dbms?

1049

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

1239

For More Un-Answered { Databases } Questions Click Here