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 sql*loader and what is it used for?

1 1270

What are the triggers associated with image items?

1 1115

What is bind reference and how can it be created?

1 1095

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1 1173

What are the datatypes available in pl/sql ?

1 1180

What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

1 1169

How many clustered indexes can be created on a table?

1 1155

What is raid? How does it help storage of databases?

1 1167

Explain about recursive stored procedures?

1 872

Explain about the implementation of business logic in stored procedures?

1 805

Explain about the process which takes place to execute a stored routine?

1 814

What is the difference between a user defined function and a stored procedure?

1 942

Explain about the return statement?

1 965

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

1 925

What are external procedures ? Why and when they are used?

1 924

Un-Answered Questions { Databases }

How many concurrent programs you have customized, can you name some of them?

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1128

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

define sql insert statement ? : Sql dba

1094

How do I find query history in sql server?

1018

Can you index views?

953

How to select all columns of all rows from a table in oracle?

1124

Is it possible to have clustered index on separate drive from original table location?

1035

What is the best sql course?

1046

Can delete statement be rollbacked?

1050

How do I remove duplicates in two columns?

1178

what is sql server agent? : Sql dba

1179

what is the difference between openrowset and openquery?

1187

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2702

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

For More Un-Answered { Databases } Questions Click Here