How will you write a shell script to connect to SQL database?

Ashutosh Gupta

• Sep 10th, 2011

In vi editor
vi connect.sh
#!/bin/bash

sqlplus -s sys as sysdba

NARESH

• Jul 31st, 2011

Sqlplus -s username/password@schema name
:wq

Answer Question  Select Best Answer

give UNIX command to wait for a specified number of seconds before exit.

PriyadharshiniNaveenKumar

 Profile Answers by PriyadharshiniNaveenKumar Questions by PriyadharshiniNaveenKumar

• Sep 13th, 2009

Sleep n

shumi

 Profile Answers by shumi Questions by shumi

• Aug 2nd, 2009

'at' command is used for scheduling jobs not for delay

Answer Question  Select Best Answer

How to find out whether reference is pointing to a scalar, array or hash?

santhosh_89

 Profile Answers by santhosh_89 Questions by santhosh_89

• Sep 19th, 2009

You can use ref function.

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• May 2nd, 2008

With 'ref' keyword we can find the data type of the variable.

Answer Question  Select Best Answer

You have unsorted array of strings, like:my @arr = qw(hello World Show must go on);Print this array, sorted in reversed case-insensitive order.

iamkamalnayan

 Profile Answers by iamkamalnayan Questions by iamkamalnayan

• Dec 26th, 2016

Code
print join  , sort {lc $b cmp lc $a} @arr;

Gaurav.khurana

 Profile Answers by Gaurav.khurana Questions by Gaurav.khurana

• Apr 18th, 2015

Code
        @array = qw( Udzial IS going Where means  How are Youu you share);
        print join (" ", reverse(sort{lc($a) cmp lc ($b) } (@array)));
     #  cmp used to do characters sort and 
     #  lc to do case insensitive
     # after sorting applied reverse on it

Answer Question  Select Best Answer

soumdgr8

• Aug 1st, 2015

Is used for chaining elements of a reference type. The element can be another reference, scalar, array, function, object

shalusanju

 Profile Answers by shalusanju Questions by shalusanju

• Aug 13th, 2010

In object oriented PERL, the arrow -> symbol is used for creating or accessing a particular object of a class. For eg. in Perl/Tk 1. use Tk; my $main_win = MainWindow->new(); Here we u...

Answer Question  Select Best Answer

vasu

• Dec 19th, 2011

Code
#!/usr/bin/perl
use strict;
use warnings;
my @myNames = (Jacob, Michael, Joshua, Matthew, Alexander, Andrew);
my  @grepNames = grep(/^m(.*)$/i, @myNames);
foreach my $grepNames (@grepNames) {
        print"the value is :".$grepNames."
";
} 
 

contactparagm

 Profile Answers by contactparagm Questions by contactparagm

• Dec 3rd, 2010

"grep" is a built function which extract all elements in ARRAY, matched by regex/pattern given as argument for grep and return the resultant elements in an array.perl syntax:  &nbs...

Answer Question  Select Best Answer

shah

• May 16th, 2018

Its wrong sangeeta. To implement a stack in perl, we have to use push and pop function, push will add an element at the end of array and pop will remove the element from the end of array

singh_Pushpendra

 Profile Answers by singh_Pushpendra Questions by singh_Pushpendra

• Aug 13th, 2010

#! /usr/bin/perl -w$str1="Pushpendra Singh";@str=split("", $str1);@stack_array=();foreach $i (@str){ print "nt Item being pushed is : $i"; push(@stack_a...

Answer Question  Select Best Answer

a)provides information on helpb)grep searches in a file whereas find searches for files and directories.c)both a) and b)d) none of the above

Parth Gandhi

• Dec 6th, 2017

C) both a and b

sandip

• Sep 4th, 2016

In find command we can search all type of file or directory.
like: inode number wise, size wise, name wise, permission wise etc.

Answer Question  Select Best Answer

yzesong

 Profile Answers by yzesong Questions by yzesong

• Jul 31st, 2009

They have almost same lifetime(local is shorter), but different access scope.

burraganesh

 Profile Answers by burraganesh Questions by burraganesh

• Dec 7th, 2008

For both these the default initial value is 0A static global variable can only be accessed in the file it exists, we cannot use it in other files, even after mentioning it as externIn static local var...

Answer Question  Select Best Answer

sachin_mundhra

 Profile Answers by sachin_mundhra Questions by sachin_mundhra

• Jan 28th, 2010

Inline function should be small in terms of line of code. Complier will replace the code whenever inline function gets called.

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• May 2nd, 2008

In case of ordinary function, when calling the function the scope jumps to the function and after return jumps back to the function call statement resulting in some extra execution time. While in case...

Answer Question  Select Best Answer

george

• Oct 11th, 2013

Die will print a message to the std err, then exit with a non-zero return code. You dont control the return code and you are stuck with the text going to the std err. Exit will terminate with a speci...

vinod

• Jun 20th, 2013

Exit will simply end the program but die will print the message before ending the program

Answer Question  Select Best Answer

Gaurav.khurana

 Profile Answers by Gaurav.khurana Questions by Gaurav.khurana

• Apr 18th, 2015

R should be small here i.e.
`rm -rf /home/udzial/*`

Navrattan

• Oct 8th, 2013

Rmtree () is function which is used to remove a directory which has files in it

Answer Question  Select Best Answer

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• Jun 17th, 2009

I believe, most important difference will be platform dependency.1) PERL scripts can be used on both UNIX and windows systems, unless some OS specific commands are used. But the same case is not with...

Sachin.K.P

• Jun 7th, 2007

My ideas on the main differences are: - Perl is complied at run time and runs faster as a result. Shell scripts are translated line by line. This is much slower for many uses. - Perl handles flo...

Answer Question  Select Best Answer

ashwini chavan

 Profile Answers by ashwini chavan Questions by ashwini chavan

• Jul 22nd, 2008

Hash is an associative array where data is stored in "key"->"value" pairs.Eg : fruits is a hash having their names and price%fruits = ("Apple", "60", "Banana", "20", "Peers", "40");

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• May 2nd, 2008

Hash is also known as 'Associative array' sometimes. It basicaly contains of two parts first is key and value. It is very much like a name given for a value.Ex. A student with his/her roll number can ...

Answer Question  Select Best Answer

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• Jun 8th, 2009

qw stands for 'Quote word'. It usually used to create array.           Ex. @arr = qw/one two three/;       ...

gnana

• Oct 31st, 2006

The quoting opeator for lists is qw.advantage of qw is you need not quote the strings in additional way as qw already does quoting.

Answer Question  Select Best Answer

sachin_mundhra

 Profile Answers by sachin_mundhra Questions by sachin_mundhra

• Dec 18th, 2009

No concept of encapsulation, code is different than the data in case of C structure. This is possible in C++ structure.

samitriani

 Profile Answers by samitriani Questions by samitriani

• Jul 8th, 2008

C does not have limitation access. Structures in C are used to regroup data from different types.In C++ structure have limitation access propreties (private,public protected) with public access as default, can contain methods and can be used as a class.

Answer Question  Select Best Answer

is the output redirection operator when used it overwrites while >> operator appends into the file.

Anupam Kumar

• Nov 2nd, 2016

> will redirect the output to file and will overwrite its existing contents. >> will just append.

Sabbir

• Mar 29th, 2016

> is used to copy data (output) by overwriting old data.
>> is used to copy data (output) without overwriting old data. Just will be added under old data.

Answer Question  Select Best Answer

cmp - Compares two files byte by byte and displays the first mismatchdiff - tells the changes to be made to make the files identical

Anupam Kumar

• Nov 2nd, 2016

Com - will give the difference between two files; data available only in file 1 or file 2; data available in both the file.
Diff - will give difference between two file in a way that how file 1 and be in sync with file 2.

Deepak

• Sep 3rd, 2014

To check the differences between the data of two files cmp command is used. But it displays only the first difference. Syn: $ cmp file1 file2 To display all the differences between the files diff comm...

Answer Question  Select Best Answer

Yes, using the ‘mesg’ command.

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• May 7th, 2008

messages can be restricted by you with the help of 'mesg n', this will restrict the incoming of messages to your terminal, for again allowing messages for your terminal you can use 'mesg y'.

ashok kumar

• Feb 21st, 2006

Yes its by using mesgbut the command is mesg n(to restrict incomming messge)mesg y(to allow messge)

Answer Question  Select Best Answer

Directing the flow of data to the file or from the file for input or output.Example :  ls > wc

satyam.kumar2008

 Profile Answers by satyam.kumar2008 Questions by satyam.kumar2008

• Aug 9th, 2008

Whenever we run a command on shell prompt we get some output on shell prompt.In case we don't want to appear the output on the shell prompt we can redirect the output to the somewhere else. We can mak...

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• May 7th, 2008

redirection is used to change the default input and output source.'>' is used to redirect the output to location other than standard output terminal. If the location doesn't exist it wi...

Answer Question  Select Best Answer

A pipe is two or more commands separated by pipe char '|'. That tells the shell to arrange for the output of the preceding command to be passed as input to the following command. Example : ls -l | prThe output for a command ls is the standard input of pr. When a sequence of commands are combined using pipe, then it is called pipeline.

satyam.kumar2008

 Profile Answers by satyam.kumar2008 Questions by satyam.kumar2008

• Aug 9th, 2008

The Unix commands alone are powerful, but when two or more commands get combine together, we can accomplish complex task with ease.In unix we can combine the two or more commands together to perform m...

wow_suraj

 Profile Answers by wow_suraj Questions by wow_suraj

• May 7th, 2008

Pipe '|' is used to combine two or more commands to be executed at the sameinstance.Pipe redirects output of the first command (before '|') as input to the second comman...

Answer Question  Select Best Answer