Aug 092014
 

One often faces this problem if purchased the domain and hosting from two different sites. Suppose you have purchased a domain “xyz.com” and hosted on some web hosting site. When you try to open your website you found that your website is opened with URL:” http://xyz.com” but not as “http://www.xyz.com “. In that case please

[Read More]
Aug 082014
 
How to Convert YouTube Video into MP3 Format Directly

YouTube users often want to download there favorite YouTube videos on their machine. In order to do so, we use to search some software’s to get the videos downloaded. One can download the video directly from the YouTube website instead of going for any external software. How to Download YouTube Video without Any Software Go

[Read More]
Aug 072014
 
Best Oracle SQL Questions and Answers

Question 1: What is SQL and also describe types of SQL statements? SQL stands for Structured Query Language. SQL is a language used to communicate with the server to access, manipulate and control data. There are 5 different types of SQL statements. 1)      Data Retrieval: SELECT 2)      Data Manipulation Language (DML): INSERT, UPDATE, DELETE, MERGE

[Read More]
Aug 062014
 
How to Change List Separator for CSV Files

By default the operating system setting for list Separator is set to Comma (,). Whenever you save any excel file in CSV format, by default the column data is separated by Comma. In order to save the excel file in CSV format with other delimiter symbol suppose pipeline (|) you need to change the window

[Read More]
Aug 062014
 
Best 51 Oracle PLSQL Questions and Answers

Question 1: Describe in brief about PL/SQL? PL/SQL is a procedural extension to SQL with design features of programming language such as Data encapsulation, Information hiding, Exception handling etc. Oracle Server and oracle tools (oracle developer) have their own PL/SQL engine. PL/SQL Engine processes the entire PL/SQL block and filters out the SQL and procedural

[Read More]
Aug 052014
 

Many times while developing a project , you come across a scenario when you requires the column data of a table to get converted into row data with comma separated. Following example will show you the easiest way to convert column data into row data with comma separated. Step 1: Create a Table “Test” as

[Read More]
Aug 042014
 

It is necessary for a WordPress blogger to install Google Analytics plugin for tracking traffic statistics. This is a service offered by Google to get detailed statistics of the users reaching your website date-wise, post-wise, country-wise etc. This information inspires the blogger to write more and accurate content. After installing Google Analytics plugin, the user

[Read More]
Aug 042014
 

You can also purchase my ebook- Oracle Developer 2000 (D2K) from amazon. Question 1: What is Oracle Developer? Oracle Developer consists of Oracle Components that are helpful in designing the meaningful applications. Question 2: What is a Report Builder? Report Builder is a component of Oracle Developer that is used to display data in a

[Read More]
Mar 272013
 
INFOSYS Interview Process for Experienced Professionals

Aspiring candidate’s can apply for Infosys recruitment by directly login to Infosys careers website: http://www.infosys.com/careers/apply-now/apply.asp Infosys Interview Process for Experienced Candidates For experienced professionals Infosys recruitment team will scan resume uploaded on the portal as per the current requirement for interview process. If the requirement meets your skills set then you will get a call

[Read More]
Mar 272013
 
Barclays Capital Interview Process for Experienced Professionals

Barclays Capital conducts 4-6 rounds for experienced professionals: Round1: Online test consisting of 40 questions of multi-choice answer. Total duration to complete the test is one hour. Try to answer 2 choices out of 4 or 5 choices. Round2: Technical Round of 30 minutes. All the questions will be related to your skill sets. Try

[Read More]