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 74213

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,

2211

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 5888

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

iFlex,

1945

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 5786

how to retrive only second row from table?

IBM,

31 53253

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

Cognizant, CTS,

15 26697

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 20371

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

5 10687

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

Infosys,

2515

What is pseudo column ?

ABB,

6 30824

Wat is SGA ?

ABB,

3 8153

What is TABLE SPACE?

ABB, TCS,

4 12276

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 12029

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

EDC,

2143

Un-Answered Questions { Databases }

What is default port number for sql server 2000?

1058

Do you know nested transaction?

964

What is PL/SQL ?

2080

If we delete pack Spec what will be the status of pack Body ?

1479

What is sql basics?

1046

What is optimistic concurrency?

1043

What are sql commands?

1017

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2155

Is json a nosql?

985

What are stored-procedures? And what are the advantages of using them.

982

What is the use of lockboxes? : oracle accounts receivable

1209

Where is mongodb stored?

What is a clustered database?

908

How data can be copied from one table to another table?

954

What is index in an assignment?

960

For More Un-Answered { Databases } Questions Click Here