My preparation notes for Wells Fargo interview-Geneos

Geneos layers and components 1. visualization layer -> active console 2. analysis and correlation layer -> gateways : hosted on central server, which does scheduled checks, rules 3. instrumentation layer -> netprobe : lightweight process hosted on application server, that collects the sample data and communicates to gateway components: sampler plugin managed entity dataview :… Continue reading My preparation notes for Wells Fargo interview-Geneos

My preparation notes for Wells Fargo interview-Oracle II

select e.ename “Employee”,e.salary “Manager” from employee e,employee m where e.salary>m.salary; select ct.ename,ct.email,at.accno,at.bal from customers_table ct inner join account_table at on ct.id = at.id; create sequence sqrno increment by 3 start with 2 minvalue 2 maxvalue 9; sqrno.currval sqrno.nextval auto increment: must be added on key only create table tabloid(size int primary key auto_increment,name varchar(20))auto_increment=11; insert… Continue reading My preparation notes for Wells Fargo interview-Oracle II

My preparation notes for Wells Fargo interview-Oracle I

to connect to database: conn see user name: show user (or) select user from dual; see objects of database select * from tab; see all tables: select * from tab where tabtype = ‘TABLE’; Single Table queries: using variable in query select s.name,s.gpa from students s where s.department = ‘ÇS’; using distinct keyword, removes duplicates… Continue reading My preparation notes for Wells Fargo interview-Oracle I