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 11522

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 10607

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 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,

2230

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

2531

define sql

Zensar,

3 6447

wat new abt truncate in sql server

HCL, HP,

2 6835

Un-Answered Questions { Databases }

How do I add another column in postgresql?

840

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2109

what is update statistics in sybase?

1161

What is record in a database?

864

What is the difference between a database and a table?

1009

what are database files and filegroups? : Sql server database administration

945

What is the limit of mysql database?

958

Why is access important for business?

888

How to monitor firebird server activity?

969

Can sub procedure/function be called recursively?

1003

What are the properties of a primary key in DBMS?

953

Explain about sql server login?

1086

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

884

Does postgres support json?

859

What is a common use of group by in sql?

1051

For More Un-Answered { Databases } Questions Click Here