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

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

After removing a table from database, what other related objects have to be dropped explicitly?

1064

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1068

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

1043

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1107

Can a database be shrunk to 0 bytes, if not, why?

1111

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1120

What are the new data types are introduced in sql 2000?

908

Can a database be shrunk with users active?

1141

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

1074

Can a rule be bound to any column of any data type?

965

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

945

How can a user-defined datatype be created?

992

Explain timestamp datatype?

976

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

966

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1048