1.	Identifying  duplicates and Deleting duplicates
2.	2nd maximum salary
3.	rownum and rowid diff
4.	case and decode diff
5.	Write all the sql and plsql concepts you know
6.	What is synonym and purpose?
7.	sequence and purpose
8.	diff between group fun and analytical fun
9.	replace and translate diff
10.	instr and substr diff with examples
11.	identify the no of 'a' in a string
12.	What is view - why? – functionality
13.	mview and refresh methods
14.	constraints 
15.	delete and truncate diff
16.	null functions with real time scenario
17.	write a query with group by clause
18.	joins - diff - cartesian product
19.	Why we are using gtt ? disadvantages
20.	What is index? functionality - types
21.	procedure and functions diff
22.	How many table u 've created?
23.	How many subprograms u 've created?
24.	Types of exceptions,how exceptions handling in your project ?
25.	recently created procedure/function/package ?
26.	yesterday the query was running fast but not today why ?
27.	what is cursor ? - attributes - real time example
28.	diff between cursor and ref cursor - real time scenario
29.	files handling concepts in oracle - which is faster ?
30.	write a query for delete and update with joins
31.	insert values using select statement
32.	create table using select statement and structure ?
33.	how take insert scripts using sql developer/toad
34.	how to check the program error and debug ?
35.	connect by level - hierarchycal query
36.	collection types - where u used in your project
37.	collection type as table column
38.	mutating table error - hw to solve it ?
39.	where u 've used trigger in ur project
40.	:new ? :old ?
41.	what is compound trigger
42.	recently faced issue , ur contribution ?
43.	how oracle works while executing the query
44.	function based index - issue - why ?
45.	packages - advantages
46.	write a query - who joined on tuesdays ?
47.	list all the alphabets - write a querypossible to create fk for the same table ?
48.	how to generate awr report ? - how to read it
49.	query tuning - how do u do that ?
50.	what is table fragmentation ?
51.	explain plan - how to get it ? and how to read it ?
52.	sample real time procedure and function
53.	basic unix commands - 10 frequently used commands
54.	what is olap ? Online Analytical Processings
55.	what is oltp ? Online transaction Processings
56.	joins and sub query diff
57.	with clause and sub query 
58.	Inline view ?
59.	who is getting the maximum salary ?
60.	dynamic sql ?
61.	how to insert values in clob , blob and bfile ?
62.	There is a column name Inv-128 how you print separately char alone and number alone?
63.	insert - Last One year data into another table
64.	Get - Last 30 days data Month wise employees count ?
65.	Which dep is having max no of employees ?
66.	Recently inserted record ?
67.	Change fname to lname and lname to fname
68.	when parent key not found error will occur ?
69.	when child record found error will occur ?
70.	what is on delete cascade / on delete null ?
71.	what is novalidate ? -- not to validate the existing data
72.	How to get no of records in a table?
73.	Which join will be faster
74.	Find the count of a char in a string using regular exp and other way
75.	Return 50% of  the data from a table
76.	Date and year functions in oracle
77.	TOP N values
78.	Hierarchy queries
79.	11 G features, 12 C features
80.	Split a comma separated string into rows
81.	Find the 1st and last date of a given period
82.	Listagg
83.	Rollup & Cube
84.	In bulk collect if limit is not used what will happen
85.	Query a plsql table
86.	Virtual column
87.	How to modify a column datatype in a table which contains millions of records?
88.	Merge & it uses
89.	What happens when a query executed in a database
90.	Explain plan & the structure of the explain plan
91.	Gather statistics report
92.	Normalization 
93.	Pragma Autonomous transaction
94.	Pragma exception_init
95.	How to fine line of error in a program
96.	Types of cursor and attributes
97.	Refcursor & sys_refcursor
98.	Weak & strong ref Cursor
99.	DBMS packages 
100.	Check with oracle default packages
101.	UTIL file handling
102.	How to debug the procedures or packages 
103.	Transaction Isolation level
104.	Round(45.883,-2) & Round(45.883,-1)
105.	How to debug the procedures or packages
106.	Find which query is performing low inside proc or package
107.	Subquery types and example . Which subquery will return fast
108.	Different types of hints & when to use it
109.	Different types of hints & when to use it
Why we should not use commit inside trigger? If we use what      will  happen