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

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

Microsoft,

2 5897

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2583

what is sequence of execution of following triggers 1.when-validate-item 2.post-change 3.key-next-item 4.post-text-item

2 11315

wat is global index and local indes

Oracle,

1 5477

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

Wipro,

2559

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 7044

What is the main difference b/w Teradata and Oracle?

TCS,

1 5857

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

TCS,

9 11362

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 9071

What is the differnce between view and materialized view

TCS,

4 9352

What is dynamic SQl and how you will create and execute dynamic sql?

TCS,

2 7569

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2589

how to get count of tables in particular database in Oracle?

3 5919

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 38790

hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

2089

Un-Answered Questions { Databases }

What are the steps you will take to improve performance of a poor performing query?

2902

What is ole activation style property?

What is the maximum row of a size?

1072

Can you tell me how to add new column in existing views?how?How is possible?

1519

Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

1230

What is the difference between Stored Procedures and triggers?

1135

what is storage manager?

984

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1321

How to create a temporary table in oracle?

1337

what are the sql joins available in informix?

How does rowid help in running a query faster?

1478

How to turn on or off recycle bin for the session?

1178

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2189

where are cookies actually stored on the hard disk? : Sql dba

1082

How to create new tables with "create table" statements in ms sql server?

1111

For More Un-Answered { Databases } Questions Click Here