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 does the automatic recovery do?

1 3068

What is the difference between writing data to mirrored drives versus raid5 drives

1 1008

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1 1095

Give an example of why you would want to denormalize a database

1 1055

How many full-text indexes can a table have?

1 1044

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1 1105

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1 1217

What is the importance of concurrency control?

1 1306

How you can get the list of largest tables in a database?

1 1093

When you should use a low fill factor?

1 1070

Define cursor locking

1 1067

What is database replication? What are the different types of replication you can set up in sql server?

1 1038

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1 1078

Explain the dbcc pintable command when would you use it?

1 986

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1 1130

Un-Answered Questions { Databases }

Are you familiar with user exits in reports?

What is the current version of sql?

1091

What is the current version of postgresql?

1163

How to export data from database and import into another?

989

What is acid mean in sql server?

1234

how to use regular expression in pattern match conditions? : Sql dba

1105

Is inner join faster than left join?

1273

How to remove duplicate rows from table except one?

1079

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

1947

Can we rollback truncate?

1072

What is sql server query analyzer?

1121

what is dbms? : Sql dba

1059

How to rebuild the master database?

1158

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

What are different types of constraints?

995

For More Un-Answered { Databases } Questions Click Here