Sunday, November 18, 2007

GeekInterview Weekly Digest November 2007

 geekinterview.com

Weekly Digest

   

Hello itinterview

sridharrganesan Ganeshan Ramanathan working as Test team leader for reputed company from Chennai, India. His interests include Reading books. Ganeshan will have the responsibility to moderate Software Testing and all its sub-forums, along with existing moderators. His contributions and rich experience in software testing and development will help several learners and also our community members.

Ganeshan Ramanathan - New Moderator for Software Testing


We are happy to announce member of the month for October 2007. The award for member of the month October 2007 goes to sridharrganesan further, contributors for debasisdas, psuresh1982, susarlasireesha and sarathi trichy. Congratulations to winners, each of them will get surprise gift.

Ajax Latest Articles

DHTMLX Website Updated with Ajax Interface
Rapid7 NeXpose Updated
Project Insight Updated with Ajax
IBM Rational AppScan Launched
Aprino Enterprise Update Released
Create Ajax Based Mobile Phone Friendly Sites with MoFuse.Com
Glide Mobile for iPhone Released
Link Egypt Releases Link Commerce Version 2.0
Ajax Based Software of Day Released
Natural for Ajax Released
Book4Time Releases Updated Ajax Software
Dojo 1.0 Finally Released
Visual Studio 2008 to be Updated
Ajax vs. FLEX

GeekInterview.com Forums

SDLC process
by Rashmachittiappa on 12th November 2007 in Testing Issues
Hi all, Am 1.4 yrs experience in software testing..ve come across interviews asking if a bug fix sent to you from a developer reported by some other tester so how do you go about & u don t have a clue about the bug.i was really confused with this..can someone help me out

Sql query problem
by susarlasireesha on 10th November 2007 in SQL
Select pr_at_tokn,pr_at_dt14,sum(pr_at_loph) loph,pr_at_dt01 from
(select pr_at_tokn,pr_at_dt14,pr_at_loph,null pr_at_dt01 from pr_batn_yr
where pr_at_perd="15-sep-2007" and nvl(pr_at_loph,0)=0 and pr_at_dwrk > 0
and pr_at_mode="w" and substr(pr_at_tokn,2,1)="1" and
pr_at_tokn not like "z%" and pr_at_dt14 not in ("uu")
union select pr_at_tokn,null pr_at_dt14,0,pr_at_dt01 from pr_batn_01
where pr_at_perd="30-sep-2007" and pr_at_dwrk > 0 and pr_at_mode="w"
and substr(pr_at_tokn,2,1)="1" and pr_at_tokn not like "z%" and pr_at_dt01 not in ("uu") 
The above query is unable to get required output, pls correct the query to get required output...

Oracle Question
by kalyan.naga on 12th November 2007 in Oracle
Can you please tell how can we improve performance of an SQL query?

Date Conversion Problem
by krishnaindia2007 on 10th November 2007 in Oracle
In a table indate and outdate are of varchar2 type. It stores data in the the format DD-MON-YYYY HH:MI (03-Apr-2006 16:48). While generating the report I need to display the date in the format DD/MM/YYYY. For that I have given the following command select to_date(indate,"DD/MM/YYYY") , to_date(outdate,"DD/MM/YYYY") from cmswhitesugarweighment It is showing errormessage ORA-01858: a non-numeric character was found where a numeric was expected Could anybody please suggest how to display date in DD/MM/YYYY format?

Does QTP Script run if the system is locked?
by amni7303 on 14th November 2007 in QTP
Hi all, experts please answer this query. This is urgent. Could you please tel if the QTP scripts will run if I lock my system and leave. Currently, if I lock my system, the QTP scripts fails.

write a program to reverse a string with/with out reverse() method?
by ramakris143 on 14th November 2007 in Java
write a program to reverse a string with/with out reverse() method?

Test director
by shivali singh on 12th November 2007 in Testing Issues
what is difference between refuse and rejected status in test diector and after execution why * comes what is the meaning of that

Rebuilding of indexes
by vinayhc on 16th November 2007 in Oracle
Hi all, I have doubt in rebuilding of indexes in oracle. Please advice me in the following scenario. i have a table which has indexes. the table data will be emptied once in 3 months. and a new set of data flows in. Please tell me if it is required to rebuild indexes in this case. thank you, With best regards, Vinay "I have not failed; I have simply found 10,000 ways which do not work!" -- Thomas Edison

Re usable functions
by rajaputra on 12th November 2007 in QTP
Hi, Any body tell me about reusable functions/ user defined functions in QTP, How to work with reusable/user defined functions in real time scenario.

User function
by dowens on 12th November 2007 in SQL
Need a user function that will return top 3 status by seqno desc data looks like key seqno status 1 1 r 1 2 s 1 3 p 1 4 x The function has to go in a query. I need "xps" returned. Please can any one help me to create this user function?

Am I eligible for software developer
by Geek_Guest on 16th November 2007 in Career Advice
Hello, I am doing GNIIT and MCSE with a BCom degree could you please tell me that am I eligible for software developer in good companies like TCS and Wipro. Also what are the things I should look after. Since i dont have any BCA or BSc degree [B]Question asked by visitor Saikat[/b]

Insert Script
by krishnaindia2007 on 15th November 2007 in Oracle
I have to send a table data as insert script to another person. How to create insert script for table data in SQL * PLUS?

performance tuning
by bindus1000 on 12th November 2007 in Data Warehousing
Hi Can anyone tell me the process how to check the performance and validity of data displayed on report in Cognos? regards bindu

Dbms_scheduler
by susarlasireesha on 12th November 2007 in Oracle
How to use DBMS_SCHEDULER .Pls explain it with an example

A View Doubt
by krishnaindia2007 on 12th November 2007 in Oracle
We can see code in procedure, functions and triggers using ALL_SOURCE. But How to see a query assosiated with a view?

Defect Management Process
by newhere on 13th November 2007 in Testing Issues
I am new in testing please help me guys.:) Can anyone explain me what is Defect Management Process in testing? And what is ticket in testing?

Functions inside triggers
by rajakumar_na on 15th November 2007 in Oracle
Can we call functions inside the triggers or not? If yes tell me with example? If NO Tell me why?

Find previous executed SQL
by pande.dhiraj on 14th November 2007 in SQL
Hi all Can anybody tell me the query to find out the last or previous some executed SQL by SQL command prompt. it doesnt matter it is executed by application or the SQL command prompt thanks in advance

If no web test then what test to perform on a web application?
by SwarupDukuria on 16th November 2007 in Web Testing
Hi All, First of thanks to bizzzzzare for the wonderful answer for my last question.i was more than satisfied. Recently in one of the interview i was asked: "You have been given an application and you have to test it,but you should not perform web test on the application,then what test will you perform?" Can any one please help me in getting the correct answer. Thanks in advance. Regards, Swarup

plain asp session
by rumbleEye on 13th November 2007 in ASP.NET
I program in asp (isn"t there a page here regarding plain asp?) in my website, after a user creates an account i give the session("_user_name_") = request.form("username") so the user will be logged in automatically after he signes up to the website. The session always gets lost. I have no clue why is that :( anyone knows about some tricks or rare reasons why this happens? thank you.

Winrunner"s M_ROOT not defined
by Geek_Guest on 16th November 2007 in WinRunner
When I try to run a WinRunner script from QC, I am getting an error message "Winrunner"s M_ROOT not defined". If anyone has a fix for this, please let me know. [b]Question asked by visitor elan[/b]

Archieve file
by krishnaindia2007 on 13th November 2007 in Oracle
What is the use of Archieve file in oracle. Whether it takes space from table space or hard disk ?

Can a class in java be private, if yes what are implementations of it?
by prsaraf on 16th November 2007 in Java
Can a class in java be private, if yes what are implementations of it?

Automate MS Outlook Operations using QTP?
by kavita debroy on 16th November 2007 in QTP
Can we automate MS Outlook Operations using QTP? We need to find out automation tools which can automate MS Outlook. Pls help.

Importing Data
by krishnaindia2007 on 13th November 2007 in Oracle
In a user account I required to access database objects from other user accounts. For that After importing data in oracle 9i, every time I am dropping exisiting synonyms that are dependent on other users and granting privileges from other user accounts. Is it compulsory to do this process every time after importing data or else does it automatically takes care?

function conversion file to blog
by dwarakanath on 16th November 2007 in DB2
how to convert a picture in file like aa.jpg and store in database in DB2 ....

Help in Public Speaking
by think4word on 15th November 2007 in Personality Development
Hi friends.....I am software engineer working in a reputed IT firm....But no one will agree to that, since I do not speak at all, when I meet a group of people....I have two yrs of experience, but still I will present myself as a school kid....I am finding very difficult to speak in meetings and discussions...I feel very bad since I am not at all making a small contribution in meetings and discussions...Though I work hard, I lack confidence in public speaking.....Can any one help me out, what exactly I can do to overcome this?

Get 10 months data from sysdate
by subbaraovangalli on 16th November 2007 in SQL
suppose we have 2 years data. we want to get a data of 10 weeks data starting from sysdate. i.e when ever we run then query then it gives 10 months data from that sysdate how we can get this

Load Testing
by SwarupDukuria on 13th November 2007 in Web Testing
Hi all, I have just started testing.I wanted to ask is it necessary to do web testing before load testing a web application? I was going through a video on load testing and i found this statement.I tried finding reasons for the same but couldnt. Please help me in getting the reason,as it will help in getting my base clear. Thanks in advance. Swarup

Software Life Cycle
by vasantha.v on 17th November 2007 in Testing Issues
Please send software life cycle process briefly. Thank u for the reply in advance.

Latest Tutorials

N-Tier Application Partitioning
Application partitioning is a vital process, as it provides one with the opportunity to clearly define an even distribution of an application’s presentation, process, and key data components – without which, you may find yourself feeling quite lost. The components may be distributed over several different physical machines, or across a vast array of memory address spaces.

Listening Skills : Why listening is important
Why do you need to have good listening skills? You might recall that several years ago on TV there was a public service announcement that talked about the importance of listening skills. The PSA differentiated between hearing, which is merely a physical ability, and listening, which is actually a skill. By being able to listen, we are able to effectively make sense of what another person is saying.

Listening Skills - Classroom Listening as key to a Bright Future
A lot of people confuse listening with hearing. The truth is, the two are very distinct. Most of us can hear, but not all of us are effective when it comes to listening. Listening is a skill that has to be developed over time. Below, we will review some of the questions that every student should ask himself or herself at some point when attending a class. This helps them become better listeners – and more successful in life outside the classroom.

N-Tier Application Manageability
While it is a fact that N-Tier applications tend to provide almost limitless scalability, the desire to change or add new forms of functionality can present a challenge in more than one arena. Growth on a large scale can make capacity planning quite hard. When available resources have been exhausted by applications, then there must be some sort of provision made to borrow resources in order to support unexpected workloads. This is where manageability becomes key.

Practice Makes Perfect
Can Practicing Help Improve My Attitude?You bet it does. But it is not as simple as merely ldquo;practicingrdquo; whatever it is that you want to get good at. You have to learn how to practice the right way. Indeed, practicing can be used in virtually every profession as a way of getting good at something. But instead of practicing to make perfect, we should first practice in a perfect way in order to realize perfection.

Listening Skills - Become a Better Listener in the Classroom
What are the most common obstacles to classroom listening? Let us face the facts here: In order to be a good student, you have to become a good listener. There is no way around it. You cannot take notes unless you are really listening to what is being said. The difference between merely hearing what your instructor is saying and actually listening to them is engagement. Once you become engaged with what the speaker is saying, you will be able to latch on to the important points and thus make good notes – and greatly improve your overall performance in the course.

Use Your Assets for Attitude Development
The dictionary defines an asset as a valuable or useful thing or quality. The fact of the matter is, whether we are rich or poor, we all have assets. On the flipside of that coin, we all have liabilities as well. The trick is to learn how to use the former by discarding the latter. In order to make use of onersquo;s assets, one needs to have one thing: that is, guts.

Listening Skills - Become an Active Listener
Can you hear what people are really saying? If you feel that you are lacking in the communication skills department, this can be detrimental in the long run in terms of your career. It is simply not possible to influence, negotiate, and persuade people – all tools that you need to be a success in the work place – when your listening and communication skills are sub par.

Service Autonomy
As Businesses continue to step up the process of constructing enterprise automation logic in the service format, there is also an increasing need to step up both the efficiency and reliability that the services are intended to take on at run time. This dire need is increased when it comes time to assemble a service inventory with a vast quantity of reusable services.

Regards,
Chandra Vennapoosa
Geekinterview.com
Exforsys Inc
248 Millington Road
Cortlandt Manor
New York 10567
 
Create a Free Monster Account and Post Your Resume Now!

Monster Horoscope

Tech FAQ  

Interview Questions 

Placement Papers 

Tech Articles 

Learn 

Freelance Projects 

Online Testing 

Geeks Talk 

Job Postings 

Knowledge Base 

Site Search 

Add/Ask Question

In case you have lost your password Click here to retrieve Lost Password
    
If you don"t wish to receive newsletters, Unsubscribe me from this mailing list

Please NOTE :
For all Partner Site Resource Links you may need to register in respective sites for login. 
Your geekinterview username and password is exclusive for geekinterview.com website.   
For exforsys tutorials login you need to register separate at www.exforsys.com

No comments: