Interview Questions Answers in Oracle General

veeru

{ City } hyd
< Country > india
* Profession * etl tester
User No # 124152

Total Questions Posted # 1
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 1074

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { veeru }

Questions Answers Category Views Company eMail

What are the most common interview questions on ETL Testing for experience?

Oracle General 1074

Answers / { veeru }

Question { TCS, 28153 }

what are Triggers?

Answer

Triggers are validating data from COLUMNS/TABLE. It handles complex validations.

Is This Answer Correct ?

0 Yes

0 No

Question { TCS, 26539 }

what are stored procedures?

Answer

1. Store procedure may or may not return a value. If we want to return a value then we need to pass the parameters like INPUT & OUTPUT parameters
2. It can allowed SELECT/INSERT/UPDATE/DELETE Statements. It can be change state of table.
3. It can call Functions, Views, and Procedures inside procedures.

Is This Answer Correct ?

0 Yes

0 No

Question { TCS, 34607 }

what are views?

Answer

View is logical representation of data. But it doesn't store data into tables

Is This Answer Correct ?

0 Yes

0 No