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 11682

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 10814

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,

2088

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

1 3771

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

2 5441

how can we store any pdf file in oracle

2228

ow to bring suspect mode datbase online from scratch

1864

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?

2174

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,

2310

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

2592

define sql

Zensar,

3 6600

wat new abt truncate in sql server

HCL, HP,

2 6959

Un-Answered Questions { Databases }

Is mysql a server?

962

How does mongodb store data?

Explain the difference between sql and couchdb?

how to pass a variable more than one values?

709

Why foreign key constraint is important?

860

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1262

What is columnar storage what is the advantage?

1130

What are the commands used in sql?

1144

What mysql -u john -p command does?

1032

Differentiate between syntax and runtime errors.

1242

What are the benefits of ordbms?

1141

What are the three levels of data abstraction?

1175

How would you open an ms access database that has been converted to a current version?

876

How we can refresh the view?

1167

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1061

For More Un-Answered { Databases } Questions Click Here