3 things to avoid during Job Interviews By Questpond.

First and foremost avoid the below three things:-

Avoid saying negative about your previous organization because that would send wrong message to the interviewer. Do not create a pessimistic image before the interviewer.On the contrary if you start with positive things like :- “The current company has no issues and I am extremely happy with the current environment but it’s more of a personal problem etc etc…” that would create a very strong and positive image of yours.

Avoid complaining about your current work profile like “It’s a maintenance project, it’s in 1.1 version and I am not learning anything new etc.”. It’s very much possible that the interviewer has a maintenance job. So in such kind of situation’s I have seen the interviewer rejecting people irrespective even though if they have performed well in technical round.

Avoid saying you are jumping only because of salary. Some of the interviewer’s do not like people who just look at monetary benefits. When you are asked about salary expectation these things could be better discussed during that conversation. Do not make it explicit during the interview. Bet me nobody likes greedy professionals:).

Below are some of the good reasons for which the interviewer does not cross question back:-

  • For better prospects and growth.
  • Office is far away I spend lot of time travelling and would like minimize my travelling time.
  • They are telling me to relocate but in my current situation it’s not viable.
  • I am developer but due to project requirement I am in a testing role and so want to switch.
  • Project is getting closed and the company does not have projects.
  • Company is not paying salary on time.
Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on (SSIS, SSAS and SSRS)MSBI

What are partitions in SSAS?

SSAS let us create cube. Cube is a multi-dimensional database. Data will be stored inside cube as dimensions and Fact Tables.
By default in order to store Fact tables (measure group tables) partitions will be created inside cube.
Be default for one fact table one partition will be created. Partition is simply a physical storage unit inside cube.

Note: End user is nothing to do with partition. Her/she never say, I want data from this or that partition.
For him/her it is always going to be single partition.

Can we span single fact table across multiple partition?

Yes, we can. We can create more than one partition for a single fact table.

Is there anything we have to keep in mind while creating multiple partitions for single fact table?

Yes, we have to make sure that each partition contain unique records.

Advantages of having partition:

  • Each partition can be stored inside a separate physical drive bringing parallel data access into picture.
  • Each partition can have its own aggregation logic.
  • Different storage setting can be defined for each partition. Example – one partition supports MOLAP whereas one supports ROLAP
  • Each partition can be processed independently
  • By keeping historical data and a new data of a particular method in separate partitions processing speed can be improved.

Does partitions store only method group data?

No, in case of aggregating logic is defined, it also stores aggregated data.

Also refer our article on 8 important SQL Server (SSIS, SSAS and SSRS)MSBI Interview questions

For technical trainings on various topics like WCF (Windows Communication Foundation), MVC (Model View Controller), Business Intelligence, Design Patterns, WPF, TFS and Basic fundamentals feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com

For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla

See practical video on explaining SSIS, SSAS and SSRS (part 1) with sample demo: –

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on ASP.NET MVC (Model View Controller)

Why MVC (Model View Controller) is loosely coupled?

In order to answer this question, first let’s understand what’s the difference between loosely coupling and tightly coupling is.

Look at the following pic.

p1

When we talk about human body, body parts are tightly coupled to each other. We cannot simply replace hand with some other hand or a leg with some other leg. This is called tightly coupling.
When we talk about computer most of the parts are loosely coupled. Take the RAM out put a new one, same with display, keypad etc. This is called loosely coupling.

In Web Forms User interaction logic is handled inside CodeBehind where as in Asp.net MVC it’s handled inside Controller. Now if we compare Web form Codebehind with MVC Controller biggest difference is, CodeBehind is tightly coupled with view where as controller wont tightly connected to any view.
Single controller can work with more than one view and similarly one view may contain references for more than one controller in form or anchor tag.

p2

For technical trainings on various topics like WCF (Windows Communication Foundation), MVC (Model View Controller), Business Intelligence, Design Patterns, WPF, TFS and Basic fundamentals feel free to contact SukeshMarla@Gmail.com or visit www.sukesh-marla.com

For more stuff like this, click here. Subscribe to article updates or follow at twitter @SukeshMarla

See the following MVC (Model View Controller) video on viewdata, viewbag, tempdata & session:-

 

Click and see here for more step by step training in ASP.NET MVC

 

 

 

 

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on ADO.NET

What is the use of Command objects?

Command object helps to execute SQL statements. Following are the methods provided by command object:-

  • ExecuteNonQuery: – Executes insert, update and delete SQL commands. Returns an Integer indicating the number of rows affected by the query.
  • ExecuteReader: – Executes select SQL statements which can either be in your .NET code or in a stored procedure. Returns a “Datareader” object.
  • ExecuteScalar: – Executes SQL command and returns only a single value like count,sum , first record etc.

How can we fine-tune the command object when we are expecting a single row?

Again, CommandBehaviour enumeration provides two values Single Result and Single Row. If you are expecting a single value then pass “CommandBehaviour.SingleResult” and the query is optimized accordingly, if you are expecting single row then pass “CommandBehaviour.SingleRow” and query is optimized according to single row.

What are Dataset objects?

Dataset is an in memory object with data tables, rows and columns. You can visualize it as in-memory RDBMS.Dataset has the following features:-

  • The in memory RDBMS works in a disconnected manner. In other words even if the connection is closed the dataset is still there in memory.
  • You can do modification in the in-memory database object and send the final changes to the database.

Below is a simple code snippet which shows how to access a column value. You can see how the full dataset object hierarchy is accessed to get the column value.

objDataset.Tables[0].Rows[0]["CustCode"]

dataset

How can we force the connection object to close after my data reader is closed?

Command method Execute reader takes a parameter called as Command Behavior wherein we can specify saying close connection automatically after the Data reader is close.

PobjDataReader = pobjCommand.ExecuteReader (CommandBehavior.Close
Connection)

See the following video on ADO.NET connection pooling: –

 

Click and see here for more training on ADO.NET

Posted in Uncategorized | Tagged , , , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on .NET

What is a Class and structure’s?

Structures are value types and classes are reference types..

When to use Structures and When to use classes?

You will use structures when: –

Point 1:- If you want to represent a custom value type. This custom value type is derived from primitive data types (int, double). Some of the example’s of custom types are co-ordinates (which have X, Y), complex numbers (which have real and imaginary components). You can also term these things as value objects or technical objects. Technical objects do not represent real world objects like customer, supplier, invoice etc.

Point 2:- If you want to have low memory foot print. For instance let’s say you want to plot a graph. To plot a graph you need to have 100’s of objects created so that you can represent co-ordinates. Now if you create a class and generate those 100’s of objects you end up putting lot of load on your garbage collector. If you create a “struct” , it’s a value type. So they get created and destroyed immediately. Thus putting less load on memory.
For all other scenarios use a class.

datatype

 

What are similarities between Class and structure?

Following are the similarities between classes and structures:-

  • Both can have constructors, methods, properties, fields, constants, enumerations, events, and event handlers.
  • Structures and classes can implement interface.
  • Both of them can have constructors with and without parameter.
  • Both can have delegates and events.

What is the difference between Class and structure’s?

Following are the key differences between them:-

  • Structures are value types and classes are reference types. So structures use stack and classes use heap.
  • Structures members cannot be declared as protected, but class members can be. You cannot do inheritance in structures.
  • Structures do not require constructors while classes require.
  • Objects created from classes are terminated using Garbage collector. Structures are not destroyed using GC.

Click and see here for more basics training in .NET


 

Posted in Uncategorized | Tagged , , , , , , , | Leave a comment

QuestPond’s Interview Questions & Answers on ADO.NET

How is stored procedure different from functions?

  • Function cannot affect the state of the database which means we cannot perform CRUD operation on the database. Stored Procedure can affect the state of the database by using CRUD operations.
  • Store Procedure can return zero or n values whereas Function can return only one value.
  • Store Procedure can have input, output parameters for it whereas functions can have only input parameters.
  • Function can be called from Stored Procedure whereas Stored Procedure cannot be called from Function

How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?

ADO.NET provides the SqlCommand object, which provides the functionality of executing stored procedures. In the command type we need to provide the command type as stored procedure as shown in the below code snippet.

SqlCommand objCommand = new SqlCommand("sp_Insert", objConnection
;
objCommand.CommandType = CommandType.StoredProcedure;
objCommand.ExecuteNonQuery();

See following video on dataset is a disconnected while datareader is connected: –

 

Click and see here for more ADO.NET training.

Posted in Uncategorized | Tagged , , , , , , , , , | Leave a comment

ASP.NET Interview questions around Web.config

Can ASP.NET project run with out a Web.config file ?

Yes.

Can we have two Web.config file in a project ?

Yes we can , look at the below video which explain’s why we need two web.config files.

mockup

Differentiate between Web.config vs machine.config file

“Web.config” files apply settings to each web application, while “Machine.config” file apply settings for all ASP.NET applications running on that machine.

This question is taken from Shiv koirala’s ASP.NET Interview book. You can buy this book from http://www.flipkart.com/net-interview-questions-cd-rom-english-6th/p/itmdyuqzdqx8cvqx

Posted in Uncategorized | Tagged , , , , | Leave a comment