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

Which tcp/ip port does sql server run on? How can it be changed?

1 1112

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1 1112

What is a file group?

1 1195

Does order by actually change the order of the data in the tables or does it just change the output?

1 1227

What is the definition for sql server 2000?

1 1168

What is identity?

1 1111

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

1 1049

What are synonyms?

1 1037

What is the default order of an order by clause?

1 1061

What are the authentication modes in sql server? How can it be changed?

1 1224

What is acid properties?

1 1224

Can we perform backup restore operation on tempdb?

1 1093

What is pivot and unpivot?

1 1096

What is dirty page?

1 1058

What is extent? Types of extents?

1 1316

Un-Answered Questions { Databases }

How do I find query history in sql server?

1020

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

1952

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

What is sql or structured query language?

1220

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?

1845

What is the current version of sql?

1091

What is a view in sql?

1035

What are the different types of subquery?

1232

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2209

How to define array in mongoose schema?

Can delete statement be rollbacked?

1050

What is the difference between case version and decode version?

1104

do you know how to configure db2 side of the application? : Sql server database administration

1119

What is sql server query analyzer?

1124

How do I create a trace in sql server?

1113

For More Un-Answered { Databases } Questions Click Here