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

Accenture, Nagarro, TCS,

4 11676

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?

2271

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 10806

whats new about truncate in sql server 2008?

MedSave Healthcare, Serco,

2561

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

TCS,

2083

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

1 3770

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

2 5439

how can we store any pdf file in oracle

2223

ow to bring suspect mode datbase online from scratch

1861

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?

2171

When do we create bitmap indexes

CTS,

2 10075

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

Atos Origin,

2308

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

2588

define sql

Zensar,

3 6598

wat new abt truncate in sql server

HCL, HP,

2 6956

Un-Answered Questions { Databases }

Can we use commit inside a trigger?

1149

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2264

Tell some of the most important uses of ms access?

879

How do I update access 2013?

806

What is procedure explain with program?

1070

Mention how can you determine what protocol is being used for interconnect traffic?

What is row level locking?

994

What is 'mysqlimport'?

985

What is the equivalent of oracle/db2 coalesce function in sybase?

936

How network traffic be reduced by using the stored procedure?

1182

What privilege is needed for a user to connect to oracle server?

1040

Explain isolation levels. : Transact sql

1114

If a cursor is open, how can we find in a pl/sql block?

1220

What is integrity in sql?

1109

What stored by the msdb? : sql server database administration

1055

For More Un-Answered { Databases } Questions Click Here