REVISION POINTS

self introduction (detailed and precise including hints to interviewer)

For oracle

SQL
sql queries

write queries as below
max salary
second highest salary
third highest salary
nth highest

index (clustered and non clustered)
partition (types)
views
materialised views
difference between m view and view

contraints
primary key
foreign key
surrogate key
composite key

sub queries
group by
order by
CTE (common table expression)
regex (regular expression)

aggregate functions (count, min, max, avg)
analytical functions (rank, dense_rank)
scalar functions

output of joins for given sets/tables

inner join
full outer join
left outer join
right outer join
cross join
self join

union
union all
intersect
minus

collections
and difference between each collection

PLSQL

package
stored procedure
functions

difference between proc and function
how can we return multiple values from a function

cursor (implicit and explicit)
what is implicit curosr called as ?
ref_cursor

trigger (types)

write a query to print 1 to 10 numbers using rownumber and without using rownumber

ETL
what is ETL?
pros and cons of ETL
steps of ETL

SDLC

how to use git and commands?

unix basic commands

grep (to search a word)
mv
cp
awk
cd
find?????
chmod
to replace word from file
rm -rf (for dir)
tar and untar commands
gzip gunzip

how to search for a file older than 30 days?

scheduler/job

write a command, how to schedule a particular job using cron?

e.g. command for a job who runs every minute

• * * * * path/file.sh

python

data structure (list, tuple, set, dictionary)
write a query to find factorial of any number

lamda function