Data Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

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

983

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?

1150

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

1024

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

964

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?

1018

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

1043

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

911

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1050

What is the exact numeric data type in sql?

1008

How can you list all the columns in a database?

938

When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?

987

Using the customer, and order table in northwind database, please write a query to produce xml?

1082

What is the primary use of the model database?

1095

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

1144

how you can list all the tables in a database?

1034