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 14219

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

Allianz,

2 6437

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 6016

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

6 28683

Which institute is best for SQL Server 2005 Training?

6 7408

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 14729

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 17553

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,

3050

structural difference between bitmap and btree index ?

Infosys,

1 12134

How MySQL is different from SQL?

HCL, IBM,

17 23236

What is format trigger?

2070

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

3 30437

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

3 7342

Un-Answered Questions { Databases }

What is field size access?

743

What is an oracle?

1018

What is datadir?

876

What is storage engine in mongodb?

A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?

689

What is the difference between mysql and mysqli?

1203

What is primary key secondary key alternate key candidate key?

1037

what is the syntax used for partition in tsql? : Transact sql

1014

What is sharded cluster?

1015

How many types of indexes are there in mysql?

914

How to update a field in SQL after ALTERING a row?

1232

Is it mandatory for the primary key to be given a value when a new record is inserted?

1198

How many fields can you have in an access table?

727

How many types of users in dbms?

899

What is 19 null in sql?

965

For More Un-Answered { Databases } Questions Click Here