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

Difference between Triggers and Stored Procedure

Claimat, HCL, Protech, Silgate,

23 73760

Hi Can any one tell me the Good institute to learn SQL esp for Data Base Testing or SQL from scratch to the proficiency level in Hyederabad and facult also. Thankyou well in advance

6 7430

scope of exception handling in plsql

Wipro,

4 13158

How to create a table using constraints... IF i change the PARENT KEY value ,then CHILD KEY table will also to change in the another table... plz reply ur answers @ mak2786@gmail.com Arunkumar

3 7760

Explain 1st, 2nd, 3rd normalization form of data base

KH, Thermotech,

3 23060

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16628

What is TNS File

Thermotech,

7 32027

What is flashback Query ? And Use ?

Thermotech,

4 9438

What is Trace File ?

Thermotech,

4 26222

What is forall Statement ?

Thermotech,

2 5981

Tell me New Feature of Oracle 10g?

Thermotech,

5 11069

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

Thermotech,

4 7461

how to find the second highest salary from emp table?

CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar,

211 369680

Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin

Deloitte, Ness Technologies,

5 14933

How to list all tables having unique constraints in any of the columns in a database.

1 4580

Un-Answered Questions { Databases }

Explain force logging feature in 9i.

616

What are some predefined exceptions in pl/sql?

1182

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1003

How do you create a db file?

1028

Which trace flags are enabled in sql server?

1033

What is a data dictionary and how can it be created?

1172

What happens if recursive calls get out of control?

1100

List five most important parameter in 9i affecting performance?

575

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2195

List few disadvantages of file processing system.

942

What does n tier mean?

743

What is resource db in sql server?

1038

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3215

Difference between report and query parameter.

1109

What is meant by dirty read?

1008

For More Un-Answered { Databases } Questions Click Here