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

Create a procedure to delete certain records from a table and display the total number of records deleted in this process. (Condition for deletion can be of ur choice, for instance delete all records where eid='')

2 7665

I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access

4 5926

I'm need to prepare Month Over Month Sales Growth report. Is there any function available in OBIEE to perform this task.

Infosys,

2134

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

Infosys,

1 4221

how to produce numbers from 1 to 10 using dual table

Genpact,

4 10770

I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2046

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 4873

how may join possible between (requisition with purchase order)

2178

I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????

1 4624

default triggers available for reports

2166

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2422

i want run a sql query query? which phases are run in a back ground? pls tell me the answer

1 5190

what is Equity join?

ADP,

2 7107

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8705

How can multiply values of a column? OR How can multiply value of a row of a column using a single query in SQL?

Pitney Bowes,

1 6043

Un-Answered Questions { Databases }

What is input buffer in sql*plus?

1153

what is the difference between where clause and having clause? : Sql dba

965

What do you understand by sub-queries in sql?

910

What is a canvas in oracle forms?

1033

While taking hot backup (begin end backup) what will happens back end?

528

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1989

What is blob and clob?

906

What is the purpose of the model database?

977

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

912

What is the purpose of access?

796

How to omit columns with default values in insert statement in oracle?

1011

What is cardinality in db?

953

Explain the types of database normalization?

884

State two functional blocks used in couchbase server?

How to configure odbc dsn with different port numbers?

1035

For More Un-Answered { Databases } Questions Click Here