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

wirte a query to filter improper date format follwing table? date 20-apr 22-may-2010 26-jun-2010 feb-2009 i want the output date 22-may-2010 26-jun-2010

Accenture,

6 16121

1)How to check tablespace utilization? 2)what are the RMAN CLONING STEPS? 3)what is standby database? 4)what is difference between standalone database and target database? 5)How to backup the standalone database? 6)tell about the ubgrade steps? 7)How to apply the pathes?

Wipro,

2270

1)what is the difference between view and materilized view? 2)what is the difference between delete and truncate? 3)what is the difference between migration and upgration? 4)what is the difference between RMAN HOT BACKUP and normal hot backup?

3i Infotech,

2 6153

HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

BeBo Technologies,

8 17062

what is main def between plsql/table and array?

Oracle,

1 3967

Define the term DML, DDL and DTL?

1 31877

How to count the no of records of a table without using COUNT function?

TCS, Tesco,

11 29242

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

JDA,

4 8804

Creating Tables Using SELECT

1 3467

How can I create a table from another table without copying any values from the old table?

3 5854

CREATE a table from another table

2 5150

Get Current System Date Time

2 4860

What is a SQL Server Temporary Table?

Wipro,

1 6574

Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.

1 3551

what is the difference between delete,drop and truncate

Honeywell, Zomato,

2 6779

Un-Answered Questions { Databases }

Can you force a query to use a specific index?

993

Why do we need a foreign key?

1170

I assigned a primary key to my table in microsoft access, I was expecting my data to be sorted. Is that a right approach?

982

How does php communicate with mysql?

957

What are the advantages of database system?

987

Where is the mongodb database?

How to execute a function in postgresql?

973

Explain Reporting Life Cycle?

132

What is field with example?

978

How do I clean up sql server transaction log?

1129

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

4096

How to divide query output into groups in oracle?

1038

How do I limit the number of rows returned by an oracle query after ordering?

1228

Explain the difference between control flow and data flow?

1061

How to sort the query output with order by clauses in ms sql server?

1076

For More Un-Answered { Databases } Questions Click Here