Interview

Jul 152015
 

26. TALK: Chat to Users The “talk” command is used to chat with another logged-in user(s) or allow chat to users on other systems. Example: $ talk user3 This command will allow the current user to talk to user “user3”. 27. UNAME: Print system information The “uname” command is used to print the name, version

[Read More]
Jul 132015
 

UNIX Commands    1. CAT: Concatenate files to standard output The “cat” command can be used to: Display text files Copy text files into a new document Append the contents of a text file to the end of another text file, combining them Syntax: cat [options] [file_names] Example: $ cat myfile.txt This command will display the

[Read More]
Jan 152015
 
[Infosys] Infosys Interview Process

Many readers commented on my previous post of “Infosys Interview Process” and have shared their Interview experience with Infosys. With their comments and information provided, I am going to write one more post on Infosys through which I will share complete interview process of Infosys, beginning from the job application till rolling out the offer

[Read More]
Dec 232014
 

14) SQL Query to compare NULL values in Oracle table Step 1: Create two Table “Test1” and “Test2”: CREATE TABLE TEST1 (A NUMBER,B NUMBER); CREATE TABLE TEST2 (A NUMBER,B NUMBER); Step 2: Insert Rows: INSERT INTO TEST1 VALUES (1,25); INSERT INTO TEST1 VALUES (2,20); INSERT INTO TEST1 VALUES (3,NULL); INSERT INTO TEST1 VALUES (4,30); INSERT

[Read More]
Dec 222014
 

1) SQL query to fetch first 50 rows from a Table.  SELECT   * FROM   employee WHERE   ROWNUM < 51; 2) SQL query to fetch 50 random rows from a Table  SELECT   * FROM   (SELECT   * FROM   employee ORDER BY   DBMS_RANDOM.VALUE) WHERE   ROWNUM < 51; 3) SQL Query to generate Serial/Sequence Number for a Table.  SELECT  

[Read More]
Dec 162014
 

Solved 51 SQL Queries 37) SQL query to create a role and grant it to a user Create role <role_name>; //Create Role Grant create table, create view to <role_name>; // Grant privileges to role Grant <role_name> to <user_name1>, <user_name2>; // Grant Role to Users 38) SQL query to revoke select and insert privileges from a

[Read More]
Dec 152014
 

Solved 51 SQL Queries 25) SQL query to get the first day of a month Select trunc(to_date(’30-Nov-2014′,’DD-MON-YYYY’),’month’)from dual; Output: 01-Nov-2014 26) SQL query to get the first day of a Year Select trunc(to_date(’30-Nov-2014′,’DD-MON-YYYY’),’Year’)from dual; Output: 01-Jan-2014 27) SQL query to spell a day Select To_char(to_date(’20-Nov-2014′,’DD-MON-YYYY’),’ddspth’)from dual; Output: twentieth [day 20 is spelled as twentieth] 28)

[Read More]
Dec 112014
 

Solved 51 SQL Queries 13) SQL query to copy structure of a table Create table employee_new as select * from employee where 1>2; [Where”employee_new” is a copied table to “employee” table without any data] 14) SQL query using MERGE statement MERGE INTO bonuses D USING (SELECT employee_id, salary, department_id FROM employees WHERE department_id = 80)

[Read More]
Dec 102014
 

Solved 51 SQL Queries 1) SQL query to create partition by range on a table create table product (product_id number, product_name varchar2(30), Manufactured_Date date) partition by range (Manufactured_Date) ( partition part1 values less than (TO_DATE(‘2013-01-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)), partition part2 values less than (TO_DATE(‘2014-01-01 00:00:00’, ‘YYYY-MM-DD HH24:MI:SS’)) ); 2) SQL query to create database link

[Read More]
Oct 162014
 
Infosys Recruitment Reviews

Through my previous post “Infosys Interview Process” I have noticed that many candidates have concerns related to salary, Location and Joining Date offered by Infosys. In this post I will share my personal experience and experiences shared by the candidates on these concerns. Salary offered by Infosys Many candidates believe that MNC’s offer hike in

[Read More]