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 5568

How reterive duplicate value in SQL?

6 10732

What is Transaction?

2 5803

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 4296

How to see the database architecture in MySQL??

3 5913

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

IBM,

2 6714

What is the use of MOVE keyword in restore command

IBM,

3 6137

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

CarrizalSoft Technologies, IBM,

4 6899

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 4405

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 7774

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

1 7652

how to pass 2 variables from one form to other form

1 3947

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 4269

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 3792

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

Baidu,

1 6442

Un-Answered Questions { Databases }

Explain the difference between numeric and decimal data types in sybase.

890

Explain how you can import data from other sources into access database?

840

How to call a stored function with parameters?

1049

What is a livelock?

973

Where is the multi connections are used in ORACLE DATA INTEGATOR?

629

What are the commands used in sql?

1085

How to create a stored procedure with a statement block in ms sql server?

1073

How to delete an existing row from a table in oracle?

1072

State the criteria which a trusted publisher should meet before adding him?

860

What is primary key in dbms?

914

How to define the name and server for a new dsn?

1124

How many types of table create in ms access?

820

What does the file extension accdb stand for?

976

What is SQL Azure Fabric?

110

What is server replication?

996

For More Un-Answered { Databases } Questions Click Here