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

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1076

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? : Sql server administration

956

if no size is defined while creating the database, what size will the database have? : Sql server administration

1019

what information is maintained within the msdb database? : Sql server administration

983

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? : Sql server administration

989

how you can move data or databases between servers and databases in sql server? : Sql server administration

984

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1265

A trigger can reference objects outside the current database? State true or false.

1017

How can you list all the table constraints in a database?

952

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

1022

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1002

What does it mean to normalize a database and why would you do it?

991

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

960

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

947

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?

1039