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

1040

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?

1203

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

1077

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

1020

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?

1068

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?

1102

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?

961

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

1109

What is the exact numeric data type in sql?

1061

How can you list all the columns in a database?

977

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?

1038

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

1123

What is the primary use of the model database?

1139

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?

1198

how you can list all the tables in a database?

1075