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 the difference between Procedure and Function

Accenture, Nagarro, TCS,

4 11521

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2220

Their are two tables 'A' and'B'.Table 'A' contains 3 columns named 'eid','ename','dept'. Table 'B'contains 3 columns named'sid','designation','salary'. We have to retrieve the names of employees working in the same department,same designation and same salary. Its urgent can anyone help me out in this problem.

Tech Mahindra,

6 10603

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2502

how can we view column head in first page but not in remaining pages?

TCS,

2041

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

1 3693

What is the sql query to find the employee who has Nth maximum salary?

2 5329

how can we store any pdf file in oracle

2164

ow to bring suspect mode datbase online from scratch

1806

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2105

When do we create bitmap indexes

CTS,

2 9959

if i want to display the name of students such that to which city they belong must have count greaer than two

Atos Origin,

2228

How to read and create .LDC data files which are used by linguatic dictionary.

2529

define sql

Zensar,

3 6443

wat new abt truncate in sql server

HCL, HP,

2 6832

Un-Answered Questions { Databases }

What is difference between pl and sql?

1058

State at least four kinds of indexing?

1034

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1198

What is full join?

951

What are instead of triggers?

1044

How to experiment a data lock in oracle?

1056

Explain what a database is?

1044

What is purpose of normalization?

949

How does cross join work?

953

How do I start mysql database?

973

How do I quit sql?

956

What is the purpose of update statistics and scope_identity() function?

1100

What are the possible ways to gain information regarding the control file?

568

what is unique and xaml nonclustered index

1049

What does plv msg allows you to do?

1139

For More Un-Answered { Databases } Questions Click Here