1) Brief about yourself and current project? 
	I have 3yrs experience as Oracle PL SQL Developer. I work for Investment banking like capital, trade and Securities. My role like Enhancement and Maintenance Role. I work on L2 and L3 support and also on change Request. I am strong in writing SQL querines and creating PL/SQL objects and I am good in tuning the SQL queries and PLSQL blocks.

2) What is the Job Scheduling Tool you are using?
	We are using DBMS Scheduler in PL/SQL and DBMS Jobs. I am also familiar with Auto Sys and Crontab.

3) What is the Ticketing Tool you are using?
	we are using Service Now.

4)Do you have any experience writing UNIX Shell Scripting and Name some of the Basic Commands used on day to day basis? 
	grep - For searching string
	find - To find files and directory
	ls - To list the files in a current directory
	vi editor - screen-oriented text editor
	cut - To cut the line and column

5) What is the AWK command in Unix and give me the Syntax.
	AWK is used for selecting particular column and also for manipulating data and generating reports.

	Syntax

	awk ‘BEGIN {start_action} {action} END {stop_action}’ filename


	Begin-Section: 

	The scripting will start here.

	Start_action :

	Here user can use any command which will be the starting action.

	Action :

	Here user can use set of commands to perform text manipulation.

	Stop_action:

	Here user can use command which will end the script.

	Different Usages of Awk Command in Unix :
	The Awk command is useful in following situations :

	1.Scanning of the File Line by line.

	2.It is used to transform the data files and data manipulation in text files.

	3.Awk Command used to splits each input line into fields.

6) What is your Release Cycle?

	Release Cycle - Every Week we have new Change Request. We call that as a Minor Release. Once in a Month we work on Major Release. We call that as a Work Request.

7) Are you into Development?
	I am into Enhancement and Maintenance. The Application which we have been working was Developed 30yrs Before. We have Centralised Database. My Role Maintaining Database and Automating the job by using shell Scripting. Every week we get New Change Request.
Every Month we get New Work Request. Every day work on Incident and Problem management. We get Lot of tickets on daily basis. Minimum we get 200+ tickets.

8) Have you written Procedures and Functions?
	I have written lot of procedures and functions inside packages. I have good experience on tuning SQL queries and PL/SQL objects.

9) Have you used cursors in your Project and Difference Between Explicit and Implicit Cursor?
    Explicit Cursor
    	When a Query Returns more than one Row and if we want to do a row by row selection then we have to use explicit cursor which is declared in declaration block and we can execute explicit Cursor by using open and to do row by row data selection we use fetch. If we want to do multiple row selection we use bulk collect with the combination of limit. Attributes in Explicit cursors are %notfound, %found, %isopen, %rowcount.

   Implicit Cursor
	To perform all the DML statements like Insert , Update , Delete. When select statement return one row then also it's called as an implicit cursor.


10) How do you Handle Exception?
	We have Pre-Defined Exceptions, User-Defined Exceptions, Non Pre-Defined Exceptions. But in our project We handled all the errors with others exception and logged the error into error log table by catching error code by using SQLCODE, error message by using SQLERRM , line number by using DBMS_UTILITY.format_error_backtrace

11) In Performance Tuning what are the parameter you look into the Explain Plan?
	First we check for the joins. What type of Join? and we ll check whether it is doing Full table or Index Scan. In index scan we ll check whether it is Unique Scans, Range Scans, Skip Scans, Full Scans or fast scan. Also we check for CPU time and Cost cordinality. After analysing these, we also check whether the index is created for the column that we are using in where clause and table is partitioned. Also we ll check for last analysed date and we ll check for the table fragmentation error if there is any unused block. If any unused blocks are there we ll try to release the unused block by executing shrink command. And if the index not in a valid state then we ll try to rebuild the index. If the table is not partitioned and the volume is big , we ll patition the existing table by using exchange partition.