Unix process management :
1) how to put process background and foreground
2) how to get pid of the process
3) how to kill process
4) environment variables required for oracle
  • ORACLE_HOME
  • ORACLE_BASE (optional)
  • ORA_NLS (optional)
  • NLS_LANG (optional)
  • TNS_ADMIN (optional)

5) output redirection : stdout and stderr to single file
process >>file 2>&1
process >file 2>&1

will have stderr and stdout go to <file>, but:

process 2>&1 >file

will have stdout go to <file> and stderr to - screen! , because when the direction channel 2 should point to is evaluated channel 1 is still pointing to the terminal and not to the file.
 

Unix file management
1)      explain file permissions

r
file is readable by owner, group or other
w
file is writeable. On a directory, write access means you can add or delete files
x
file is executable (only for programs and shell scripts - not useful for data files). Execute permission on a directory means you can list the files in that directory
s
in the place where 'x' would normally go is called the set-UID or set-groupID flag.




The default file permissions (umask):

2) list files with .log extension system wide and change string inside it (example 'abcd' to 'efgh')
  [we can add few more options like older than 1 month and greater than 1mb file size ]
find / -type f -mtime -7

find / -name “*.log” | sed ‘s/abcd/efgh/g’ 
find . -name "*.tmp" -print | xargs rm –f
find . -mtime +10 -size +50000c -exec ls -l {} \; 
3) what is ulimit
4) what is softlink and hardlink (and difference )
5) how to compare two files
sql questions
what are different types of  joins
what is index
what is view
explain normalisation
what is union
what is referntial integrity
what is a transaction



pl/sql
what is pl/sql package
what is cursor and different types of cursor
exception handling in pl/sql
types of triggers and what is a trigger
why we should or should not use triggers

0 Comments :

Post a Comment