Some of you might thinking how to create sequence for table which contains some records. You might always export all records from database, then eventually create sequence and after all import those records once again into database. Nevertheless there is a solution how to create this sequence using PL/SQL.
DECLARE seq_value_holder NUMBER; BEGIN -- create a sequence for YOUR_TABLE SELECT NVL(MAX(id), 0) + 1 INTO seq_value_holder FROM YOUR_TABLE; EXECUTE immediate 'create sequence SEQ_YOUR_TABLE start with ' || seq_value_holder || ' increment by 1'; END;
A few days ago, I got an email with inquiry if I would like to participate in recruitment process to Google. I thought why not. It is always good to gain some experience around that. After a phone interview which was not successful for me, but I am not sad about that fact at all, I thought that I might give you some insight what areas you should refresh or just learn quickly. Of course your questions will be correlated with those areas which you picked up before phone interview, but I assume that some of them might be similar with those which I chose.
- Operating systems - monitors, semaphores, mutexes, linux, unix, processes, inode
- Algorithm Complexity - big O notation for different algorithms. Provide some complexity for sorting algorithms. Pick up those data structures which have following complexity for instance O(n log (n))
- Mathematics - calculate something very quickly in mind for instance 2 to the power of 32
- Trees - big O notation for different operation performed on trees like AVL, Binary trees
- Java - question related to programming language which you chose
