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

at first i'm using datediff('d', a.due_date, current_date); but it takes too long to get the result but how can i subtract the current_date - a.due_date and still get the same result like when i use datediff? thank you

1 3652

how to pass values from one table to another by using Bulk collect?

Oracle, Wipro,

3 11108

what are the components of database architecture?

Wipro,

6 13364

Is index a datbase objects in sql server?

2 5034

What is Dedicated Administrator Connection in sql server 2005?

2 5586

why SQL server is more used to store database rather than Access

2 4735

how to find the second highest salary in a given table????

5 8921

How many types of Joins in SQL Server 2005?

CarrizalSoft Technologies, HCL,

9 12290

What is Inner Join?

2 5289

What is Outter Join?

1 4073

How many types of Outer Joins?What are they?

1 3850

What is Left Outer Join?

2 4602

What is Right Outer Join?

2 4664

What is Full Outer Join?

3 6247

What is Cross Join

3 6714

Un-Answered Questions { Databases }

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

1118

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?

2545

What is the latest version of postgresql?

941

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?

1841

Disadvantages of the indexes?

1205

what is collation? : Sql dba

1211

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1891

How do I find the sql server version?

1096

How to rebuild the master database?

1148

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2691

what is bcp? When does it used? : Sql dba

1040

Why and when do stored procedure recompile?

1042

what is schema? : Sql dba

1124

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

1930

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

8210

For More Un-Answered { Databases } Questions Click Here