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 16123

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,

2273

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 17068

what is main def between plsql/table and array?

Oracle,

1 3972

Define the term DML, DDL and DTL?

1 31882

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

TCS, Tesco,

11 29254

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 8808

Creating Tables Using SELECT

1 3476

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

3 5864

CREATE a table from another table

2 5151

Get Current System Date Time

2 4863

What is a SQL Server Temporary Table?

Wipro,

1 6583

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 6785

Un-Answered Questions { Databases }

What does := mean in pl sql?

1093

What are the 'mysql' command line options?

1055

Mention the different languages present in dbms

1008

How can I check that whether automatic statistic update is enabled or not?

1098

What is the syntax of mongodb collection?

What is a ddl command?

1162

How to convert comma separated string to array in pl/sql?

1246

Can't connect mysql server on localhost?

1128

What is 1nf 2nf?

1062

How does sybase replication work?

950

What is difference between clustered, non-clustered and unique index?

1131

What is the implicit cursor in oracle?

1175

How to return query output in html format?

986

How to create a new table from existing table in postgresql?

906

What is the “__v” field in mongoose?

For More Un-Answered { Databases } Questions Click Here