1Tell abt  your self
2View and materialized view
3 If we create table and then create m view and now del table using m view can we retrieve data
4 Synonyms based question
5 nested table
6 stored procedure


Telephonic round asked in chainsys
1.Tell me about yourself
2.roles and responsibilities
3.How you strong In sql and plsql
4.What is Constraints and why we use
5.What is cursor and its types. 
6.what is conditional operator
7.difference between procedure and function
8.Index and why we use
9.view and mview
10.why you use hints in your projects. 
11.what are the hints use frequently used. 
12.triggers
13.sql loader and its types
14.other than sql and plsql any technology you know.. 
15.any other questions From your side..

16.Group by clause syntax. 
17.where you use 'between' and why in sql statement

Interview questions 
Chain sys 
-What is index
-What is view
-What is trigger and types 
-What is function syntax
-What will do like %A
 sql syntax
-Joins types 
-What is dml 
Ellathukum syntax ketanga

Wht is synonyms

Chainsys Interview 
Face to face 
1. About ur self 
2. Why Pragma transaction 
3. 5th max salary query y use dense rank 
4. Delete, truncate , after this roll back is possible 
5. Package uses 
6. SDLC life cycle
7. Roles and responsibilities 
8. Current company, salary

Chain sys interview ques:
1.tell about yourself
2.what is ddl 
3.syntax for alter
4.diff b/w union and union all
5.types of joins available
6.subquery and typea
7.diff b/w truncate and drop
8.in which scenario we will use group by clause
9.what are the aggregate  function available
10.purpose of like % command
11.what is primary key
12.in plsql what is the use of case statement nd syntx
13.syntax for loop
14.what are the triggers available in plsql and syntax for triggers
15.syntax for cursor
16.how will u handle exception in plsql
17.what is dynamic sql
18.day to day  activites

Chainsys interview questions::
-Roles and responsibilities 
-trigger and syntax
-Views,Materialized views with syntax
-Joins and types
-Constraints and types
-Ddl and dml 
-Syntax for insert, update, delete in dept table
-Cursor with syntax
-Ref-cursor with syntax
-Bulk collect and syntax 
-Current Company
-Day to Day activities 
-Any questions

[7:01 PM, 1/25/2019] Dinesh Sir Greens: 1. How do u do performance tuning?
2. How will u reduce query cost?
3.What are all the index u used.
4. Purpose of materialized view?
5. How do u refresh?
6. Fetch data from t1 which are all not available in t2.
7. Have you used bulk collect? And its purpose?
8. Why we use for all?

chain-sys interview 
1.what's cursor
2.package
3.analytical function
4.bulk collect
5.where is using function 
6.whats your rool
7.current ctc

Chainsys interview questions
-Tell me about yourself 
-what is ddl?
-syntax for alter
-diff between delete and drop
-diff between union and unionall
-which scenario you use group by
-what are the aggregate function
-what are the conditional operators
-what is index
-what is constraints
-syntax for constraints
-syntax for procedure
-Types of cursor
-Types of subqueries
-what is Materialized view
-what is xml file loader
-what is dbms_jobs
-what are  the steps we followed to tune the query
-any other technology you know

extra activities like ssis ,Ssrs

About your self..

Project details..
 
Day to day activities roles
 and responsibilities.. 

What is index and types? 

What is trigger and
 syntax ..

Write query we have table 1 and table 2.. do Left outer join using primary key and another one with foreign key...
 
rank and its syntax.. densrank and syntax ?
 
Difference between procedure and function? 

Cursor it's types and syntax... 

Pragma autonomous transaction ...

Index query ...
Tell me about yourself.              
What is performance tuning.  
For t1 table u have fetch row that does not allow t2 table  tell about two different types of query      
analytical function types   example of rank function have u update bulk collect.       
Trigger types

Chainsys interview questions
1.what's cursor.
2.package.
3.analytical function.
4.bulk collect.
5.where is using function .
6.whats your role.
7.table a(I'd,name,dname)
I'd name dname
1  Surya  purchase
2  surya  sales
3  Surya  IT

Want to display 
Name  dnmae
Surya purchase,sales,IT

8. A table have 1000 and b table have 500 display b table not in records.

7. Tell about mviews.

Chainsys questions
1. About yourself
2. Reason for switching company
3. Purpose of mviews
4. Implicit and explicit cursor
5. Types of trigger
6. Can you insert value in two tables using SQL loader at a time. 
7. Analytical functions
8. Exceptions
9. Can you return value in procedure. 
10. Aggregate function. 
11. Any other skill set.

Where use Pragma 
why we use pragma  
Index
Delete trancate diff
Rating out of 10 in sql and plsql
How to get recrds in 2tables
Dml ddl diff
 hw pragma will used in function with prog
Procedure
Packages