Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3253)
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 14552

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

Allianz,

2 6625

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 6209

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

6 29036

Which institute is best for SQL Server 2005 Training?

6 7689

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

Tech Mahindra,

1 10931

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

4 14958

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 17910

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

Polaris,

1 5418

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

Virtusa,

1 3136

structural difference between bitmap and btree index ?

Infosys,

1 12252

How MySQL is different from SQL?

HCL, IBM,

17 24063

What is format trigger?

1 2146

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

3 30656

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

3 7539

Un-Answered Questions { Databases }

please send me oracle pl/sql exp resume. and also faqs...

2567

What is normalization and what are the advantages of it?

1054

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1129

define sql insert statement ? : Sql dba

1095

What is acid mean in sql server?

1240

Does view occupy space?

1007

Which statement is used in a select query for partial matching?

1239

Can we use distinct and group by together?

1133

How can I check that whether automatic statistic update is enabled or not?

1109

What is the latest version of postgresql?

951

When should you use an instead of trigger?

1045

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1208

what is sql server agent? : Sql dba

1179

What is oracle latest version?

1171

Have you used lexical parameters in reports?

For More Un-Answered { Databases } Questions Click Here