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

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

Microsoft,

2 5769

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)?

2515

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

2 11225

wat is global index and local indes

Oracle,

1 5368

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,

2504

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 6940

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

TCS,

1 5785

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 11092

What is the difference between UNIQUE KEY and UNIQUE INDEX?

TCS,

3 8914

What is the differnce between view and materialized view

TCS,

4 9194

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

TCS,

2 7478

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

2556

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

3 5785

Query for second maximum salary in each in each department

DST Global Solutions, TCS,

15 38348

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

2036

Un-Answered Questions { Databases }

How do you kill a long running query in mysql?

903

Can you load data into multiple tables at once? : aql loader

1075

Can a table have multiple primary keys?

908

What triggers long term care?

1042

Is nosql faster than sql?

1031

What are reports usually used for?

1032

What do you mean by stored techniques? How would we use it?

1041

what is an informix instance?

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1963

How do you tell what your machine name is and what is its IP address?

2100

how can we know the count/number of elements of an array? : Sql dba

1067

Tell me about builtinadministrator?

1002

What are xml indexes?

955

What are five types of database models?

902

Which database is best to learn?

574

For More Un-Answered { Databases } Questions Click Here