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,

2215

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 16823

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 28850

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 8673

Creating Tables Using SELECT

1 3400

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

3 5734

CREATE a table from another table

2 5058

Get Current System Date Time

2 4757

What is a SQL Server Temporary Table?

Wipro,

1 6476

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 3466

what is the difference between delete,drop and truncate

Honeywell, Zomato,

2 6655

Un-Answered Questions { Databases }

How to get a list of columns in an existing table?

883

How does sybase replication work?

893

How to get the current date in mysql?

1060

How do I get Report Builder to generate a parameter that can be set by users viewing the report?

151

What is a production dba?

606

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

1007

When should I execute an sp_recompile in sybase?

898

What happens if null values are involved in boolean operations?

987

What is nosql database and why you use nosql database?

What is the difference between ddl,dml and dcl commands?

1114

What is a tinyint?

964

What is a trigger what are the advantages of trigger?

1002

Mention where does the clusterware write when there is a network or storage issue?

whats new about truncate in sql server 2008?

2502

How many types of databases are there in ms access?

859

For More Un-Answered { Databases } Questions Click Here