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 can we Update a table with out using UPDATE command?

1 6089

What is user stored procedure & it purpose?

Wipro,

4 8641

wHAT IS THE difference between foreign key and reference key

1 4424

How do we rollback the table data in SQL Server

3 17222

write a qurey for finding the length of the sting.

Infosys, TCS,

6 15256

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? Belgian Waffles $5.95 two of our famous Belgian Waffles with plenty of real maple syrup 650 Strawberry Belgian Waffles $7.95 light Belgian waffles covered with strawberries and whipped cream 900 Berry-Berry Belgian Waffles $8.95 light Belgian waffles covered with an assortment of fresh berries and whipped cream 900 French Toast $4.50 thick slices made from our homemade sourdough bread 600 Homestyle Breakfast $6.95 two eggs, bacon or sausage, toast, and our ever-popular hash browns 950

1 2211

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

IBM,

5 32801

What is the differnce between Order by and Group by

1 4482

where do you use Isolations?give me some exmpale?

1 5373

In which year relase the 7.0& 2000 & 2005?

1 3894

wht r the base tables & primary key for BOM& WIP modules

Satyam,

1 6027

what is exact difference between drop and truncate table.

3 7470

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

10 15867

Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply

Covansys,

1 6310

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 8001

Un-Answered Questions { Databases }

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

1110

How to provide default values to function parameters?

1252

How did mongodb get its name?

What is clustered index

1083

Why use identity in sql server?

1194

Is inner join faster than left join?

1273

Can we rollback truncate?

1073

What is the current version of sql?

1091

what are aggregate and scalar functions? : Sql dba

1125

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1954

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

2569

List out the different types of locks available in sql server?

1047

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

1240

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?

1210

How to start an oracle instance?

1103

For More Un-Answered { Databases } Questions Click Here