Interview task - what can I expect?
-
Hi, I have a interview next week and I have been told there is a test to: "The technical test will involve creating a SQL server database, importing data into the database and writing a programme to extract data using SQL and C# and ASP.NET." Can anybody who has set or taken something similar please advise what I can expect here? I am thinking the data may be in a flat file or excel spreadsheet and I would need to use DTS or import it via the SQL Server wizard? The extract bit, I would guess is either displaying the results on a web page or writing code to extract it to an excel file? Thanks in advance! :)
-
Hi, I have a interview next week and I have been told there is a test to: "The technical test will involve creating a SQL server database, importing data into the database and writing a programme to extract data using SQL and C# and ASP.NET." Can anybody who has set or taken something similar please advise what I can expect here? I am thinking the data may be in a flat file or excel spreadsheet and I would need to use DTS or import it via the SQL Server wizard? The extract bit, I would guess is either displaying the results on a web page or writing code to extract it to an excel file? Thanks in advance! :)
Well you haven't told for what post you're going to attend interview and with how much experiance. If the interview having purely dependency on SQL Db and IMPORT and EXPORT with it, Then It could be of SSRS ( Reporting service ),SSIS ( Integration service) or It could be of data synchronization services.
Regards, Hiren. "The more we give of anything, the more we shall get back." - Grace Speare (you can consider this quote while giving vote also) Microsoft Dynamics CRM
-
Well you haven't told for what post you're going to attend interview and with how much experiance. If the interview having purely dependency on SQL Db and IMPORT and EXPORT with it, Then It could be of SSRS ( Reporting service ),SSIS ( Integration service) or It could be of data synchronization services.
Regards, Hiren. "The more we give of anything, the more we shall get back." - Grace Speare (you can consider this quote while giving vote also) Microsoft Dynamics CRM
-
Sorry, it's for 1 to 2 years experience of C# ASP.NET, an element of Sharepoint is involved in the job but not in the test
They it will be quite simple Q&A's, Please make your ADO.Net fundamental very clear for that. And All the best for Interview. :thumbsup:
Regards, Hiren. "The more we give of anything, the more we shall get back." - Grace Speare (you can consider this quote while giving vote also) Microsoft Dynamics CRM
-
They it will be quite simple Q&A's, Please make your ADO.Net fundamental very clear for that. And All the best for Interview. :thumbsup:
Regards, Hiren. "The more we give of anything, the more we shall get back." - Grace Speare (you can consider this quote while giving vote also) Microsoft Dynamics CRM
-
It is not really easy to tell that what questions will be asked in the interview. This completely depends on the person who is taking the interview. You can get some idea if you know that what kind applications that organization is building. Normally you can expect questions on the basic concepts of oops and their implementation and other stuffs. Besides they also give you some scenario and ask you to give your opinion on it. This is just to know your approach on the problem.
Apurva Kaushal
-
Hi, I have a interview next week and I have been told there is a test to: "The technical test will involve creating a SQL server database, importing data into the database and writing a programme to extract data using SQL and C# and ASP.NET." Can anybody who has set or taken something similar please advise what I can expect here? I am thinking the data may be in a flat file or excel spreadsheet and I would need to use DTS or import it via the SQL Server wizard? The extract bit, I would guess is either displaying the results on a web page or writing code to extract it to an excel file? Thanks in advance! :)
Don't use outdated terms like DTS. The current tool would be SSIS. If you don't plan on using entity framework in your sample or something else other than straight ADO.Net in the page, make sure you let them know that a real application would probably use some framework like nHibernate in a real data access layer and not just simple ADO.Net directly in the pages themselves. Unless of course you personally would normally use ADO.Net directly in the pages. If so, slap yourself with a trout hourly until you learn all about separation of concerns and proper object oriented design.