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 # 585

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 585




Answers / { veeru }

Question { TCS, 13775 }

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, 12293 }

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, 19357 }

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