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

How to Debug a Stored Procedure?

Allianz,

5 14215

How to link up the text file to a Database table?

Allianz,

2 6434

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?

3 6014

What is a REF CURSOR? Compare strong and week ref cursor types.

6 28678

Which institute is best for SQL Server 2005 Training?

6 7407

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

Tech Mahindra,

1 10821

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 14727

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

Polaris,

7 17550

How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example

Polaris,

1 5305

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

3048

structural difference between bitmap and btree index ?

Infosys,

1 12134

How MySQL is different from SQL?

HCL, IBM,

17 23225

What is format trigger?

2070

How do I take a backup of Stored Procedure in Oracle?

3 30436

Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3

3 7342

Un-Answered Questions { Databases }

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

1295

What do you mean by query optimization?

1002

How do I exclude a column in sybase?

891

Who developed mysql?

1013

What are numeric data types?

990

How will you find out if there are expensive SQL statements running or not?

1015

Where do you use decode and case statements?

993

What is mysql root?

952

What are the different types of data tables?

898

Why should I use postgresql?

1013

what is the different between now() and current_date()? : Sql dba

1021

What is data model in mongodb?

Difference between report and query parameter.

1094

How to write a query to show the details of a student from students table whose

999

How to copy data from one table to another table?

996

For More Un-Answered { Databases } Questions Click Here