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

write the query for find the top 2 highest salary in sql server

Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

36 75738

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

iFlex,

1 2291

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?

Allfon,

2 6070

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

iFlex,

1 2025

What is the purpose of init.ora. ? how many init.ora exist in oracle installation? suppose there are 3 database on one oracle server, how many init.ora do I have? what are various database objects? how will you identify memmory related performace issue in oralce? any idea about basic architure difference of oracle and db2? comment on which is better , with reasons? what is a fuction based index? is it recommended to use the same. ? what is global temporay table? what is teh signification of the parameter session_cached_cursor ?

HDFC,

1 5896

how to retrive only second row from table?

IBM,

31 54509

how to retrive only second row from table in sql server 2000?

Cognizant, CTS,

15 27306

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 21016

Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table

5 10903

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

Infosys,

1 2606

What is pseudo column ?

ABB,

6 31113

Wat is SGA ?

ABB,

3 8363

What is TABLE SPACE?

ABB, TCS,

4 12579

there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C

tdfc, vsworx,

9 12373

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

EDC,

1 2211

Un-Answered Questions { Databases }

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1954

What is temporary table in sql server? Why we use temp table?

1017

What are the steps in creating a database?

1009

Is inner join faster than left join?

1273

How raid can influence database performance?

1115

What is the difference between case version and decode version?

1104

How do I find query history in sql server?

1020

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1043

what is the difference between openrowset and openquery?

1189

How to define array in mongoose schema?

How to convert character strings into numeric values?

1187

Where can you add custom error messages to sql server?

1206

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2706

How to remove duplicate rows from table except one?

1085

Suppose database is running slow, what will you do?

2591

For More Un-Answered { Databases } Questions Click Here