*Hi Partners,*
**
*Greetings,*
**
*Hope you are doing Well!!!!!!!!!!!!!!!*
**
*Please forward a profiles to
**[email protected]*<[email protected]>
**
*Here are the requirement details*
**
*Please send. Will hire off of phone.
*
**
*King of Prussia is looking for a Perl Developer to backfill my consultant
that is going to relocate.*
**
*PERL Development*
*CPAN Library*
**
**
*h1 is okay*
Questionnaire for Developers:
1. Name:
2. Date:
1. Version of Perl You current work with?
1. Rate yourself on a scale from 0 – 10 (0 – just purchased the camel, 10
– Larry Wall, Tim Bunce, Randal Schwartz) ?
1. What is CPAN?
1. How many modules have you released on CPAN?
If any, please list the modules.
1. What is your favorite 5 Perl Modules and Why?
1. When calling a subroutine/method/function does the Perl language pass
by value or pass by reference?
Provide a code example that supports your answer:
1. Describe in your *own words* the scoped variable declarations “my”,
“our” and “local”?
- my
- our
- local
*Where code snippets are provided, if you’re going to execute the snippet
please supply a before and after running the snippet answers.*
1. Describe the results of this code snippet:
my $var_a = 72;
sub fred
{
local $var_a = 37;
my $var_b = 42;
print "$var_a == $var_b\n";
$_[1] = $var_b;
}
fred($var_a);
print "$var_a == $var_b\n";
exit;
1. How would you execute the above from the command line?
1. If an error exists in the above how would you correct?
1. Describe in *your own *words what are these operators?
- q
- qq
- qr
- qw
- qx
1. Given these variables:
my $var_1 = qq{ Sports 4 Everyone };
my $var_2 = q{More $var_1};
What is produced by?
print $var_2;
print $var_1;
How would you extract just the number from $var_1?
How would you remove leading and trailing spaces from $var_1?
How would you remove all spaces from $var_1?
1. Given variable:
my $var_s = q{ a, b, c,,e,f , g, h, 7|&*, , };
Write a Perl code snippet that produces an array containing only
alphanumeric values or undef. Remove leading/trailing spaces. Separator is
a comma “,”.
Show the results:
1. Is the following syntax valid? If not valid, why not?
- open $fred, “< big_file.txt”;
- open $fred, “<”, $big_file;
1. Describe the results from this code snippet (see note above about code
snippets):
my $out_file = "data_to_save.txt";
{local *OUT_FH;
open OUT_FH, "> $out_file" or die $!;
print OUT_FH, "Line 1\n";}
print OUT_FH "Line 2\n";
close OUT_FH;
exit;
1. Write code that does the following:
Given 10 files with a random number of records up 100,000,000,000 rows per
file; each row has the same record layout:
Tname varchar(100),
TNum integer,
TTS timestamp (HH24MISS TZ),
TDate date (YYYYMMDD)
Do the following:
For each file provide the file name, first and last record, the line number
of the row plus a random sample of rows equal to .1% of the total rows in
the file. Output example:
File Name, Line Number, Name, Number, Timestamp, Date
“filename_a”,1,george,1,213001 UTC,18870101
“filename_a”,39830123,horse,7,213001 UTC,18870101
… (above are first and last rows, randomly select rows go here) …
Prove the above code works by providing the results (only a small data set
please).
1. What won’t you do with Perl?
1. How comfortable are you using a command shell like bash? 0 – 10 (0 –
what’s a shell, 10 – I wrote the book):
1. What is a shell?
1. Describe each command and provide a simple usage example:
- ls
- cat
- top
- ps
- more
- less
- kill
- grep
- cut
- chmod
- cd
- pwd
- vi
- od
- diff
- find
1. Using bash write a one line command that provides all the process ids
for commands that contain “bash” in the example below. Exclude your command
process id from the list.
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
1. mullenj 31534 0.0 0.0 4352 1012 pts/2 S Mar08 0:01
/bin/bash
2. arjulav 29000 0.0 0.0 3316 708 ? S Jun02 0:00
ssh-agent
3. root 16397 0.0 0.0 7056 2616 ? S Aug01 11:13 sshd:
mull...@pts/4
4. mullenj 16402 0.0 0.0 4340 1288 pts/4 S Aug01 0:45 -bash
5. root 21414 0.0 0.0 7056 2628 ? S Aug02 0:45 sshd:
josh...@pts/11
6. joshit2 21415 0.0 0.0 4336 1264 pts/11 S Aug02 0:00 -bash
7. root 21537 0.0 0.0 7056 2612 ? S Aug02 4:23 sshd:
mull...@pts/13
8. mullenj 21542 0.0 0.0 4332 1248 pts/13 S Aug02 0:04 -bash
9. root 23213 0.0 0.0 7124 2696 ? S Aug02 10:56 sshd:
donoh...@pts/22
10. donohuet 23219 0.0 0.0 7336 2744 pts/22 S Aug02 0:33 -bash
11. root 23266 0.0 0.0 7056 2608 ? S Aug02 23:51 sshd:
donoh...@pts/23
12. donohuet 23274 0.0 0.0 4352 1384 pts/23 S Aug02 0:07 -bash
13. root 24823 0.0 0.0 7056 2608 ? S Aug02 0:44 sshd:
mull...@pts/28
14. mullenj 24832 0.0 0.0 4348 1256 pts/28 S Aug02 0:02 -bash
15. root 25783 0.0 0.0 5008 1692 ? S Aug02 0:42 sshd:
fe...@pts/8
16. feeds 25784 0.0 0.0 1944 748 pts/8 S Aug02 0:00 -ksh
17. feeds 26078 0.0 0.0 4212 1136 pts/8 S Aug02 0:00
/bin/bash
18. root 9136 0.0 0.0 10824 4452 ? S Aug03 0:34
/usr/local/apache2/bin/httpd -k start
19. root 13946 0.0 0.0 7056 2636 ? S Aug04 0:43 sshd:
mull...@pts/15
20. mullenj 13976 0.0 0.0 4336 1252 pts/15 S Aug04 0:07 -bash
21. root 2480 0.0 0.0 4972 1708 ? S Aug05 0:40 sshd:
fe...@pts/16
22. feeds 2481 0.0 0.0 1944 748 pts/16 S Aug05 0:00 -ksh
23. feeds 2811 0.0 0.0 4316 1112 pts/16 S Aug05 0:07
/bin/bash
24. root 30001 0.0 0.0 7048 2628 ? S Aug13 0:40 sshd:
mcquist...@pts/12
25. 3156924 30002 0.0 0.0 4352 1288 pts/12 S Aug13 0:20 -bash
1. SQL Questions:
- How many tables have you ever had to join together in a single
query?
1. Given these two tables:
Employee
Department
Emp_id (primary key)
Emp_name
Hire_date
Salary
Manager_id
Dept_id
Dept_id (primary key)
Dept_name
Dept_manager_id
Create_date
Relationship between Department and Employee is optional one to many. An
employee may be assigned to none or one department. A department may have
zero or more employees. Employee.Manager_id is a foreign key to
Employee.emp_id. Department.Dept_manager_id is a foreign key to
Employee.emp_id.
- Write a query that produces a count of employees by department (include
department name, department id and count labeled as “Employee_Count”:
Example Results:
Dept_name Dept_id Employee_Count
-------------------------------------------------------------------
Department_A 42 1
Department_Z 17 5
HR 1 3
- Write a query that produces a report of departments with no employees:
Example Results:
Dept_name Dept_id
-------------------------------------
Development 2
1. Write a query that updates the employee table adding 10% to the
salary of employees with a manager id.
1. Write a query that updates the employee table using a salary table:
--
Regards,
Shankar
248-522-6879
Technology consultanst inc
--
You received this message because you are subscribed to the Google Groups "SAP
ABAP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sap-abap?hl=en.
