Tech Mahindra PLSQL Interview Questions
Tech Mahindra PLSQL Interview Questions
- Introduce yourself
- Difference between having and group by
- Difference between case and decode
- Difference between delete and truncate
- How many types of indexes
- What is trigger and types
- Diff b/w view and materialized view
- Can we update the view
- I have one table i created view and materialized view on a table if i
delete a table, Can i see the view and materialized view?
- Can u call function in same function
- Can we use tcl commands in trigger
- What is the cursor and ref cursor
- Tell me your project
- Difference b/w loop and bulk collect which is the faster way
- What is global table
- Can we load the data from table to table through utl_file package
- Difference b/w sql *loader and utl_file package
- Which is the faster way to load the data
- Description about project?
- What r the packages, functions, procedures you Developed in your project
what are their Functionality?
- In which format u got the project?
- How u started with u r project?
- What r the steps u followed to create tables in Your project?
- How you involved in db design process?
- What r the scripts u wrote for inserting and Deleting data from db?
- How u export the data from db to excel file
- Where u stored the files in db?
- How u execute the code in sql prompt?
- Tell me some names of functions and Procedures that u created in u r
project?
- What is the name of requirement Specification?
- What are the path names u provided to
- Execute u r coded data?
- Steps to get the data from oracle to unix Environment?
*/
