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

2 5580

How reterive duplicate value in SQL?

6 10747

What is Transaction?

2 5805

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 4305

How to see the database architecture in MySQL??

3 5934

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

IBM,

2 6732

What is the use of MOVE keyword in restore command

IBM,

3 6153

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

CarrizalSoft Technologies, IBM,

4 6920

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 4410

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 7791

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

1 7663

how to pass 2 variables from one form to other form

1 3958

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 4285

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 3807

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

Baidu,

1 6457

Un-Answered Questions { Databases }

what are the advantages a stored procedure? : Sql dba

987

How do I change directories in mysql?

918

What is a scheduled job or what is a scheduled task?

962

Can we use having clause without group by?

995

How do I clean up sql server transaction log?

1080

Why do we need normalization?

939

I have applied the following commands: now what will happen, will the database will give an error / it will work?

552

How to use linked server?

1209

What is cold data?

968

Is storing images in a database a good idea?

1015

What is the trigger in sql?

968

Why we need sql server?

977

Is it good to store images in database?

1015

What is the command or the option available in postgresql that can be used to retrieve the next SERIAL value from the sequence object?

1475

What is auto invoicing? : oracle accounts receivable

1180

For More Un-Answered { Databases } Questions Click Here