Round 1: Online test for 70 minutes:
SQL/PLSQL - 15 Questions in 15 Minutes.
Analytical - 15 Questions in 15 Minutes.
DB Concepts - 10 Questions in 10 Minutes.
Write the program for given Question - 1 Question in 30 minutes.
The question was like below :
SELECT details of all the employees whose ename starts with 'J' and display the salary (.5) times of original salary. The result should be descending order of emp_id.
Round 2: Technical F2F :
create table a (a number); insert into a values(1); insert into a values(2); COMMIT; create table b (b number); insert into b values(2); insert into b values(3); create table c (c number); insert into c values(1);
declare a number:=0; b number:=1; c number:=0; i number := 8; fib varchar2(500):= a |||| b; begin for j in 1..i loop c := a + b; fib := fib || || c; a := b ; b := c ; end loop; dbms_output.put_line('Fibonacci is : '|| fib); end;
Since most modules can be written either as a procedure or a function, the decision between them comes down to efficiency and maintainability. Functions are preferred when a module returns one value. This value may be a variable, record or array, but as long as the module always returns one value else it is a good candidate for a procedure.
SELECT LENGTH(REPLACE('abaabbaab','b')) FROM dual; Result : 5 SELECT LENGTH(TRANSLATE('abaabbaab','ab','a')) FROM dual; Result : 5
This article is contributed by Amit. If you like dEexams.com and would like to contribute, you can write your article here or mail your article to email@example.com . See your article appearing on the dEexams.com main page and help others to learn.