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 7817

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 6067

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

Infosys,

2171

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 4301

how to produce numbers from 1 to 10 using dual table

Genpact,

4 10914

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

2090

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

2 4969

how may join possible between (requisition with purchase order)

2253

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

1 4706

default triggers available for reports

2219

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

2475

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

1 5271

what is Equity join?

ADP,

2 7215

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

TCS,

1 8779

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 6125

Un-Answered Questions { Databases }

What are the types of user defined functions in sql server?

1053

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

955

Explain an exception and its types?

1078

How to delete multiple rows with one delete statement in ms sql server?

1028

What is the use of index in hive?

1007

does sql support programming? : Sql dba

1051

please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks

8502

Explain the concept of view and Types of views in SQL server?

994

What is pivot table in sql?

1115

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

794

What does the acronym acid stand for in database management?

1033

Explain phantom deadlock?

1242

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

580

What is the difference between a primary key & a unique key?

1091

explain pdq priority?

For More Un-Answered { Databases } Questions Click Here