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

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

CGI,

1 3651

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

2273

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2855

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

1 6437

How can I sum column wise in Oracle excel report?

1 5885

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 8565

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

6 8911

is it possible to assign two primary key in a table

IBM,

8 12741

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

Broadridge,

2 7921

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

HP,

2442

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 5919

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

2067

what is diffrent between store procedure and trigger

2 5368

What is the main difference between DBMS and RDBMS?

3 5772

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21918

Un-Answered Questions { Databases }

What is a data directory?

1003

Can mysql and mariadb coexist?

1167

Can we use trigger new in before insert?

962

What is filestream?

1049

What do you understand by recursive stored procedure?

986

What is rac and what are the various benefits of using rac architecture?

how to invoke a trigger on demand? : Sql server database administration

1152

Can you assign multiple query result rows to a variable?

1035

Is microsoft access like excel?

856

How to show all tables with 'mysql'?

1061

Which software is used for mysql?

1017

What is oracle data type?

1006

How can you change to get the decimal separator as comma instead of the decimal point (.)?

910

State the acid rules?

1181

What is the sql server agent?

1146

For More Un-Answered { Databases } Questions Click Here