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 3495

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

2171

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2705

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

1 6230

How can I sum column wise in Oracle excel report?

1 5706

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 8217

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

6 8483

is it possible to assign two primary key in a table

IBM,

8 12103

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

Broadridge,

2 7656

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

HP,

2334

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 5748

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

1958

what is diffrent between store procedure and trigger

2 5159

What is the main difference between DBMS and RDBMS?

3 5475

select Nth highest salary by using rownum

Ford, TCS, Tech Mahindra,

4 21551

Un-Answered Questions { Databases }

What do you understand by fragmentation?

853

What is the difference between inner join and natural join?

954

Why is the need for data conversion transformations?

978

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2744

what are the type of locks ? : Sql dba

898

what is meant by magic query

2136

How to delete multiple rows from a table in oracle?

1003

Is mysql still relevant?

859

How to drop an existing table in mysql?

962

What does database administrator do?

504

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

115

What is extended stored procedures?

901

What is database join?

842

What is the most important ddl statements in sql are?

946

How to configure odbc dsn with different port numbers?

1023

For More Un-Answered { Databases } Questions Click Here