Accenture interview questions and answers on PLSQL HD

PL/SQL: When we give SELECT * FROM EMP; How does oracle respond? What is different between union and minus? What is the relation b/w view and trigger Write a query to get 2nd maximum salary in an employee table ? What is an index and types of indexes. How many number of indexes can be used per table ? What is a constraint. Types of constraints ? What is a trigger ? When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then? will function return more than one value how what is purge command explain about oracle performance tuning Give an example of any procedure. How will we see framework of a table? What is difference between procedure and function? How to return value using procedure in pl/sql? What is syntax of pl/sql function? What is view? What is Materialized View? What is difference between view and Materialized View? What is package in pl/sql ? What is advantage of package in pl/sql? What is index? What is sequence? What is trigger in pl/sql? What is the use of pl/sql trigger and how many type of trigger? What is synonym in pl/sql? What is collection in pl/sql? How to reduce execution time of any sql query? Do you know about bulk collect and forall? For HCL interview questions : https://www.youtube.com/watch?v=Pf0lRerwF5U For CTS interview questions: https://www.youtube.com/watch?v=ISpHa2IDlaU For Global analytics interview questions: https://www.youtube.com/watch?v=joRTF8ZhVwg&t=45s please subscribe to my channel for more interview questions and answers. https://www.youtube.com/channel/UCofhGV_j_4cVGa9R08MsuXQ thanks to my subscribers and viewers.