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

What is the difference between the 2 operating modes of database mirroring?

1 1183

Is it possible in sql table to have more than one foreign key?

1 1116

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1 1175

What are number line correlation administrators will use while working with a subquery?

1 1246

What is view in sql?

1 963

What purpose does the model database server?

1 1164

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

1 1037

What is a primary key?

1 1028

What is the difference function and stored procedure?

1 1140

How do you trace the traffic hitting a sql server?

1 1233

What is an identity?

1 1096

What do we have to check in database testing?

1 1076

Why would you call update statistics?

1 1095

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

1 1079

How many types of triggers are there?

1 1145

Un-Answered Questions { Databases }

what is the difference between openrowset and openquery?

1186

How to provide default values to function parameters?

1247

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2088

Why use identity in sql server?

1191

How do I find the sql server version?

1099

How can we solve concurrency problems?

1120

Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

2308

1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?

1844

Why we use the openxml clause?

1072

Does group by remove duplicates?

1112

Can we use distinct and group by together?

1131

What is a concurrency problem in dbms?

1049

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8225

Do we need to rebuild index after truncate?

1128

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

2557

For More Un-Answered { Databases } Questions Click Here