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 11537

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?

2222

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 10608

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,

2043

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

1 3695

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

2 5335

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?

2111

When do we create bitmap indexes

CTS,

2 9966

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

Atos Origin,

2232

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

2531

define sql

Zensar,

3 6459

wat new abt truncate in sql server

HCL, HP,

2 6839

Un-Answered Questions { Databases }

What is fill factor and pad index?

1016

Can I call a procedure inside a function?

1016

What are the disadvantages of microsoft access?

911

What is full join?

961

Please illustrate physical database architecture? : SQL Server Architecture

990

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2231

How to create a menu in sqlplus or pl/sql?

1128

How to return multiple rows from the stored procedure?

971

What types of languages use to work with mongodb?

What do you understand by database triggers?

935

What is memo?

640

how to write customizations in po

1618

Does sql server 2000 full-text search support clustering?

870

What are rows and columns?

1022

what's the information that can be stored inside a bit column? : Sql server database administration

1037

For More Un-Answered { Databases } Questions Click Here