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 75407

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,

2269

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 6024

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

iFlex,

2010

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 5863

how to retrive only second row from table?

IBM,

31 54226

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

Cognizant, CTS,

15 27126

a query to select maxmun 3 salaries of employee table

IBM, Polaris,

12 20819

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

5 10837

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

Infosys,

2574

What is pseudo column ?

ABB,

6 31038

Wat is SGA ?

ABB,

3 8296

What is TABLE SPACE?

ABB, TCS,

4 12495

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 12291

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

EDC,

2194

Un-Answered Questions { Databases }

What is the purpose of access?

923

How do I run a sql query?

1095

Explain prerequisites and post activities of oracle database installation

2192

Can you get second highest salary from the table?

1019

What is dbcc command in sql server?

1166

What is database users in dbms?

935

1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?

1831

What are the different types of database management systems?

1048

What does select count (*) mean in sql?

1080

Which type of object is used to organize and store data in microsoft access?

933

Explain force logging feature in 9i.

659

what are database files, control files and log files. How many of these files should a database have at least? Why?

919

What do you need to connect php to mysql?

1045

List the properties of a transaction.

1120

How can you manage sql azure security?

105

For More Un-Answered { Databases } Questions Click Here