Which Shell generally used for the Guest Login and in secure Installation ?
Rsh
Csh
Bsh
Ksh
Match Accordingly ([A.B,C,D,E] with [1,2,3,4,5])
A-2, B-3, C-4-, D-1, E- 5
A-1, B-4,C-5,D-2, E-3
A-1, B-5, C-4, D-3, E-2
Non of the above
Which is/are the script/scripts generally used and suitable in within Unix?
Perl
Shell
Rubby
Java/ajax
Awk
Which are the different Emulators in Unix?
Putty
Secure CRT
Telnet Connection
Exceed
First,Third,Fourth
First Two only
which are the Unix flavors ?
System V at AT&T lab.
BSD (Berkeley Software Distribution)
Solaris at Sun Microsystems
MAC OS X at Apple
Only first two
First Three only
What is the correct use of the Trunc command on a date?
TRUNC=To_Date('09-Jan-02,DD-MON-YY,'YEAR',"Date" from Dual;
Select TRUNC(To_Date('09-Jan-02,DD-MON-YY,YEAR')) "DATE" from Dual;
Date =TRUNC(To_DATE('09-Jan-02','DD-MON-YY'),'YEAR'),'YEAR)"DATE: from DUAL;
SELECT TRUNC(TO_DATE('12-Feb-99','DD-MON-YY'), 'YEAR') "Date " FROM DUAL;
Which type of join should be written to perform an outer join of tables A and B that returns all rows from B?
Any outer join
A left outer join
A cross join
A right outer join
How many join conditions should be there to avoid a Cartesian Join for joining three tables?
1
2
3
None of these
Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?
It returns employees who have 50% of the salary greater than $23,000:
It returns employees who have 50% commission rate or salary greater than $23,000:
It returns employees who have 50% of salary less than $23,000:
None of the above
Which of the following tasks can be performed by using the TO_CHAR function?
Convert '10'to 10
Convert 10 to '10'
Convert 'TEN' to 10
Convert a date to a character expression