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

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

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

36 74412

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,

2223

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 5924

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

iFlex,

1970

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 5800

how to retrive only second row from table?

IBM,

31 53472

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

Cognizant, CTS,

15 26811

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 20480

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

5 10716

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

Infosys,

2528

What is pseudo column ?

ABB,

6 30859

Wat is SGA ?

ABB,

3 8171

What is TABLE SPACE?

ABB, TCS,

4 12302

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 12083

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

EDC,

2152

Un-Answered Questions { Databases }

What is data store? How to create data store?

661

How many rows can postgresql handle?

947

Explain the difference between procedure and function in mysql?

1005

How exceptions can be handled in sql server programming?

1025

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

938

Why normalisation is required?

959

How to create hyperlink from returned sql query ?

1140

What is the difference between MyISAM Static and MyISAM Dynamic?

1062

How to create a Master database in SQL server ?

1104

What are the differences between innodb and myisam engines?

991

How to use online Backups?

2217

What are the two different parts of the pl/sql packages?

1107

What do you mean by stored procedures?

1027

How do you structure an access database?

985

What does varchar include?

964

For More Un-Answered { Databases } Questions Click Here