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 5817

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 12469

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

Broadridge,

2 7817

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 5845

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 5291

What is the main difference between DBMS and RDBMS?

3 5638

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21764

Un-Answered Questions { Databases }

Who introduced dbms?

906

Mention what is the difference between instance recovery and crash recovery?

Explain about query and reporting.

2088

What is the maximum length of an alert name?

1001

Which is the correct statement about truncate and delete?

1111

What is a livelock?

966

Differentiate between pl/sql and sql?

1148

What are features of mysql?

890

What is the difference between clustered and a non-clustered index?

1028

What is cql? How to execute cql commands in neo4j?

What is %type in sql?

965

What is it’s similarity with sql server?

160

Advantages and disadvantages of stored procedure?

1122

Mention the uses of stored procedures.

970

What are the basic sql commands?

1091

For More Un-Answered { Databases } Questions Click Here