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 73650

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 7392

scope of exception handling in plsql

Wipro,

4 13122

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 7742

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

KH, Thermotech,

3 23027

What is different bet native dynamic sql and Dbms_Sql?

Thermotech,

4 16586

What is TNS File

Thermotech,

7 31985

What is flashback Query ? And Use ?

Thermotech,

4 9400

What is Trace File ?

Thermotech,

4 26201

What is forall Statement ?

Thermotech,

2 5960

Tell me New Feature of Oracle 10g?

Thermotech,

5 11033

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 7426

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 368425

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 14879

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

1 4564

Un-Answered Questions { Databases }

Where is pg_hba conf file?

770

What is implicit mode in sql server?

1109

How to disconnect the user connection?

889

Is sql a oracle?

982

What is meant by query optimization?

860

How to create nested stored procedure?

1024

Explain the properties of the relational tables?

996

Explain about builtinadministrator?

1061

Is mysql is a programming language?

998

Is it important for a database administrator to understand the operating system and file access?

1001

What is sqlyog?

1031

What is the difference between unique and primary key constraints?

1072

Difference between report and query parameter. Why do we need different type of parameter?

963

What is the benefit of foreign key?

1022

Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

2037

For More Un-Answered { Databases } Questions Click Here