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

Topic :: Data

Data Interview Questions

Questions Answers Views Company eMail

Describe a data warehouse.

998

describe middleware applications that ease the connection of databases to web?

944

How do I lock in my title row and keep it visible while I scroll down to see the rest of my data?

710

I am using excel, and want to create a line graph with the data on my spreadsheet, ranging from january to december. However, I don not want the empty cells to berepresented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?

657

I know I can use the fill handle (the small black box in the lower-right corner of the range) to copy data and formulas in excel, but is there a way to use it to clearranges in excel?

647

Upload data from excel into sap?

686

Please tell me how I can split combined data into separate columns in an excel spreadsheet. For example I have a spreadsheet that contains the city and state (i.e.kennett square, pa) in the same column and I would like to have them in two separate columns?

663

Why do my scrollbars go to row 500 -- my data ends in cell e50?

660

I download data which comes to me in a column. I want to use it in a complex sheet that needs data in a row. How can I convert the column data into row data?

520

How do I put password to protect my entire spreadsheet so data cannot be changed?

653

Ihave been working with downloaded data and pasting a years worth at a time into a "template" that I want all the resulting spreadsheets to look like. Each years datahas approximately the same amount of data in it. Seems each spreadsheet is taking more and more space as I work on them? Any ideas what I have done?

689

How do I format data in ms excel?

819

Tell me what are the three types of sql database server architecture?

1146

What happens if you no create privilege in a database?

1129

What are string data types?

1042