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 14268

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

Allianz,

2 6463

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 6040

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

6 28746

Which institute is best for SQL Server 2005 Training?

6 7454

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

Tech Mahindra,

1 10841

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

4 14772

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 17593

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

Polaris,

1 5332

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

3063

structural difference between bitmap and btree index ?

Infosys,

1 12158

How MySQL is different from SQL?

HCL, IBM,

17 23354

What is format trigger?

2084

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

3 30475

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

3 7381

Un-Answered Questions { Databases }

in the physical file layout, where should the transaction log be stored in relation to the data file?

1010

List out the difference between neo4j graph database and mysql database?

How to drop an existing view in mysql?

934

What are the restrictions on external table columns?

1068

Can a View based on another View in Oracle?

1043

What are the methods of filing?

955

what is a package n what r the packages availbla in report

2112

Respected sir, Please send me technical questions related to oracle apps..

1828

Explain entity, entity type, and entity set in dbms?

843

How do I connect to a sybase database?

990

Differentiate between % rowtype and type record.

1320

What do I need to start working with sql studio? : sql server management studio

1124

How to rebuild master databse?

1096

Define entity.

958

What program will open a mdb file?

981

For More Un-Answered { Databases } Questions Click Here