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 Dangre. If you like dEexams.com and would like to contribute, you can also 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.
Please write comments if you find anything incorrect, or you want to share more information about the topic discussed above.