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

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 15849

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,

2216

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 6063

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

BeBo Technologies,

8 16826

what is main def between plsql/table and array?

Oracle,

1 3874

Define the term DML, DDL and DTL?

1 31762

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

TCS, Tesco,

11 28854

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 8674

Creating Tables Using SELECT

1 3400

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

3 5735

CREATE a table from another table

2 5059

Get Current System Date Time

2 4758

What is a SQL Server Temporary Table?

Wipro,

1 6478

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 3468

what is the difference between delete,drop and truncate

Honeywell, Zomato,

2 6656

Un-Answered Questions { Databases }

When a primary key constraint is included in a table, what other constraints does this imply?

989

What is sql profiler in oracle?

1099

how to dump a table to a file with 'mysqldump'? : Sql dba

1038

what are the types of indexes? : Sql server database administration

1127

How do you set up tablespaces during an oracle installation?

607

What is spid in sql server profiler?

1112

You want to implement the many-to-many relationship while designing tables. How would you do it?

999

Sql technical questions

1285

What is 2nf in database?

1010

How do I determine how many instances of sql server are installed on a computer?

1008

How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

2196

What is the data type of dual table?

996

Can you do multiple joins in sql?

1055

Is postgresql a virus?

888

What are character string data types in ms sql server?

1259

For More Un-Answered { Databases } Questions Click Here