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 dbcc? : sql server DBA

1 1389

Why would you use sql agent? : sql server DBA

1 1178

What is replication? : sql server DBA

1 1271

What types of replication are supported in sql server? : sql server DBA

1 1387

Why would you call update statistics? : sql server DBA

1 1066

What are the different sql server versions you have worked on? : sql server DBA

1 1096

What is transparent data encryption? : sql server DBA

1 1279

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1 1216

What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA

1 1242

What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA

1 1116

What happens on checkpoint? : sql server DBA

1 1186

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1 1086

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

1 1099

What is fill factor? : sql server DBA

1 1345

What is the default port no on which sql server listens? : sql server DBA

1 1254

Un-Answered Questions { Databases }

how to start mysql server? : Sql dba

1265

Is there some bulk load or other way to import a lot of data fast?

931

Can we shrink data file in sql server?

1124

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

2090

How to rebuild the master database?

1161

What are the properties of the transaction?

1069

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

8227

what is the last version,the release date of that version and fix pack of ibm db2 udb?

2050

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2355

what is schema? : Sql dba

1143

How to convert character strings into numeric values?

1187

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2178

What is the current version of sql?

1091

how many tables will create when we create table, what are they? : Sql dba

1141

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

1903

For More Un-Answered { Databases } Questions Click Here