Tech Mahindra PL/SQL Interview Questions

Tech Mahindra PL/SQL Interview Questions

Introduce yourself

Tell me your project

What are the packages, functions, procedures you developed in your project what are their Functionality?

Difference between 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?

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

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