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 73674

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 7402

scope of exception handling in plsql

Wipro,

4 13128

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 7747

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

KH, Thermotech,

3 23035

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16594

What is TNS File

Thermotech,

7 31992

What is flashback Query ? And Use ?

Thermotech,

4 9407

What is Trace File ?

Thermotech,

4 26205

What is forall Statement ?

Thermotech,

2 5966

Tell me New Feature of Oracle 10g?

Thermotech,

5 11038

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 7432

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 368593

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 14888

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

1 4565

Un-Answered Questions { Databases }

Mention some disadvantages of query?

965

What are the different types of columns types constraints in the sql server?

1081

What are functions in database?

956

How do I view a table in sql?

1013

What is difference between database and schema?

995

What is the function of DML Compiler?

1212

Can a Tablespace hold objects from different Schemes in Oracle?

1045

What area unit the various kinds of info compression introduced in sql server 2008?

1100

Can we commit in trigger?

982

How many sql statements are used?

1017

How do you communicate with an RDBMS?

943

I think I screwed up my onconfig file, and I do not have a backup of it. What should I do?

Can mongodb store structured data?

What is an expensive query?

934

What are the functions of administration?

558

For More Un-Answered { Databases } Questions Click Here