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

How to write query to select word java's from column employees and from emp table

CGI,

1 3576

What are the dis_advantages of stored procedures, triggers, indexes?

2226

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2785

what is difference between pass by value and eference by value in oracle plsql

1 6346

How can I sum column wise in Oracle excel report?

1 5823

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

CGI,

5 8387

how to retrieve 1st and last row of table without using group functions??

6 8731

is it possible to assign two primary key in a table

IBM,

8 12475

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

Broadridge,

2 7819

hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

HP,

2385

Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name, price 101, LED Lights,200 102, 20 watt CFL Lights, 145 103, 30 watt CFL lights,155 Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence flat file product list has two column pro_name, price 20 watt tube light ,45 30 watt tube light ,60

TCS,

1 5848

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2023

what is diffrent between store procedure and trigger

2 5292

What is the main difference between DBMS and RDBMS?

3 5638

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21768

Un-Answered Questions { Databases }

Can you index views?

895

What is procedures in mysql?

940

What is dbms and its application?

1003

What is reportserver and reportservertempdb ?

152

What is a Join and explain its types?

1103

What is the return type of mysqli_query?

869

What is informix sql?

975

what are date and time functions in mysql? : Sql dba

979

What is blob data type in oracle?

1123

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2720

How do I kill a mysql query?

903

What does the update command do?

1113

What are difference between Cluster index and Non-Cluster index?

1079

how to send file attachment from oracle forms

2551

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1083

For More Un-Answered { Databases } Questions Click Here