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

1133

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

1006

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

1065

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

1021

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

1034

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

1032

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

1315

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

1073

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

990

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?

1059

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

1052

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

1032

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

997

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

995

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?

1082