Mock tests, Interview questions, Tutorials and Tech news
 
 

Archive

Archive for January, 2010

Google launches Nexus One – iphone gets tough competition

January 5th, 2010 Vinay No comments

Google today launched much its much awaited phone Nexus One. Although it is very less on memory 4GB vs iPhone 16B, the TCO (total cost of ownership) is less than for 2 years.  One should also not over look the fact that this is 3rd generation iPhone which has improved a lot over its predecessor and this is Google’s first attempt into handset.

Apple has a huge community and fan base which are not going to give on it so it is to be seen who controls the market

Mashable has a very good comparison and difference between Nexus One , Droid and iPhone

Nexus One vs Droid vs iPhone

Categories: Tech news Tags: ,

ASP.NET Interview questions

January 5th, 2010 Vinay No comments

If you are going to appear for ASP.Net Interview , make sure you practice out the free tests at Skill-Guru

ASP .Net Interview questions

ASP.Net Chart Control Interview questions

C# Interview questions

And if you are looking for tutorials

ASP .net Tutorial – part 1

ASP .net Tutorial – part 2

Categories: Interview questions Tags: , ,

What is difference between normal view and materialzed view ?

January 4th, 2010 Vinay No comments

Normal Views

* A view is simply the representation of a SQL statement that is stored in memory so that it can easily be re-used.
* Views have been used to hide the base tables that actually contain the data you are querying
* Ease in query parsing

Materialized views

Materialized views are schema objects that can be used to summarize pre compute replicate and distribute data

Difference between normal view and materialzed view :

* No physical memory used for views as it is just a definition stored in data dictionary
* A view do no derive the change made to it master table after the view is created.
* In materialized view we can not perform DML operation but the reverse is true in case of simple view.

To find more about materialized views Understanding materialized view in Oracle

Categories: Programming / tutorials Tags: ,

State Management in ASP.NET

January 4th, 2010 Arunava 1 comment

Introduction

For any HTTP based protocol it is true that Web Forms are stateless and for each new request to the web server web pages are destroyed and recreated. As a result we do not get page information beyond the life cycle of a single page. State is the ability of a web application to retain user information and therefore state management becomes an important issue in developing web application.

Objectives

The main objective of this tutorial is to show how the state is managed in ASP.NET Web application. Through this tutorial we have tried to cover:
• State Management and different types of available options in ASP.NET
• Use of Session, Application and Cache variables to manage server state
• Use of Cookies, QueryString, Hidden Field and ViewState to manage client state Read more…

Categories: Programming / tutorials Tags: ,

Presentation on Spring Framework 3.0 and Spring tc Server Developer Edition

January 4th, 2010 Vinay No comments

For those who live in New England or in and around Boston , here is a chance to learn about Spring 3.0 and its Spring Tc Server. There is a presentation on Thursday Jan 14 organized by NEJUG (New engalnd Java Group) at Sun Microsystem in Burlington.

The presentation would be done by Tom McCuch who is a Sr. Sales Engineer at SpringSource

Presentation Overview

Spring Framework is the core of the Spring group of projects, the popular and ubiquitous open-source platform used by more than half of the organizations building and deploying Java applications. Spring adds value at development and runtime by providing a platform which allows programs to be coded using a “Plain-Java” programming model, with much increased portability, testability, and agility (ability to evolve) compared to traditional approaches. Read more…

Categories: Tech news Tags:

CCNA Certification Advantages

January 3rd, 2010 Vinay No comments

This is the question all the CCNA aspirants love to ask when the networking industry and related opportunities become a topic among their cronies. The CCNA exam was coined out by Cisco hiring team to illustrate (read filter) that you understand and can digest the topics relating to routing and switching. Putting simply, CCNA is the stepping stone for the IT organizations to acknowledge you as a serious candidate interested in pursuing a career in the networking industry. Of course there are other certifications, but Cisco has set a standard which this industry has got used to or should I say cannot live without.

It is true that Cisco products sells like hot cake. Though it can be debated that they might not be in the forefront in providing the cutting edge solutions to their clients, but they are known to provide the best output from whatever they have. One thing that sets them apart, is their aggressive sales and a well trained battery of TAC (Technical Assistance Center) engineers which would amount to around 5,000 engineers worldwide to support the products should the client need. I can say that with confidence since I was one among the TAC engineers couple of years ago and now I am working with Hewlett Packard. Only this time I get to play the role of a client interacting with the TAC to resolve complicated issues that are normally out of my reach. Every time, I am impressed. Read more…

Categories: Mock Exam / Certifications Tags:

Understanding materialized view in Oracle

January 3rd, 2010 amit No comments

A materialized view stores both definitions of view plus rows resulting from the execution of the view. It is more efficient to use materialized views if query involves summaries, large or multiple joins or both. It is a pre-computed table comprising aggregated or joined data from fact and possibly dimensions tables. Also known as a summary or aggregate table and mainly used for improving query performance or providing replicated data.
Oracle provides SQL Access Advisor, which is a set of advisory procedures in the DBMS_ADVISOR package to help in designing and evaluating materialized views for query rewrite

A materialized view stores both definitions of view plus rows resulting from the execution of the view. It is more efficient to use materialized views if query involves summaries, large or multiple joins or both. It is a pre-computed table comprising aggregated or joined data from fact and possibly dimensions tables. Also known as a summary or aggregate table and mainly used for improving query performance or providing replicated data.

Oracle provides SQL Access Advisor, which is a set of advisory procedures in the DBMS_ADVISOR package to help in designing and evaluating materialized views for query rewrite

Key Features

  • Can define independent tablespace, storage parameters to Materialized views.
  • Use Index & Partition
  • Use query re-write feature – Process of modifying a query to use the view rather than the base table is called query rewrite.

Types of materialized views

  • Materialized view with Aggregates – The valid aggregate functions are: SUM, COUNT(x), COUNT(*), AVG, VARIANCE, STDDEV, MIN, and MAX
  • Materialized views containing only joins
  • Nested Materialized views – materialized view whose definition is based on another materialized view Read more…

Categories: Programming / tutorials Tags:
Get Adobe Flash playerPlugin by wpburn.com wordpress themes