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

990

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?

1154

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

1026

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

965

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?

1020

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?

1046

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?

913

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

1053

What is the exact numeric data type in sql?

1010

How can you list all the columns in a database?

940

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?

991

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

1085

What is the primary use of the model database?

1101

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?

1147

how you can list all the tables in a database?

1037