Raw datatype is variable length datatype like varchar2 but basically it only stores data in 1 ‘s and 0’s means binary data format.Ħ.What is materialised view and what are its different fields while creating it? Long raw datatype is used to store graphics,sound documents.
![pl sql developer interview questions pl sql developer interview questions](https://m.media-amazon.com/images/S/aplus-media/kdp/85eff40f-6792-46cf-8f8d-f2e7168f6d4d.__CR0,0,2500,773_PT0_SX970_V1___.jpg)
Raw datatype is used to store values in binary data format. (Source- Click here)Ĥ.What is difference Between UNION and UNION All?(90 % asked in Interview Questions for Accenture ) Union and Union allġ.Union Set operator is used to fetch the records from 2 different tables which eliminates the duplicate recordsġ.Union all Set operator is used to fetch the records from 2 different tables which does not eliminates the duplicate recordsģ.For Performance tuning Union operator is not preferable as it takes time to eliminate duplicate recordsģ.Union all is preferable operator in Performance tuning. Step 2 is repeated until and unless all output is been fetched. The First Record of the Employee second query is executed and output is given to first query.
![pl sql developer interview questions pl sql developer interview questions](https://static1.shine.com/l/m/images/blog/sql_interview_questions_banner_1.png)
![pl sql developer interview questions pl sql developer interview questions](https://intellipaat.com/blog/wp-content/uploads/2015/11/PL-SQL-IQ-1.jpg)
(Select Department_no From Department D where E.Employee_id=D.Employee_ID) I have written the popular articles on SQL Questions for Deloitte technologies as well as Infosys Software.I have studied lot of Websites and i myself have experienced the SQL interview for Accenture and come up with the set of Interview Questions for Accenture.Accenture is well known US based organization which will always well known for its work life balance.įollowing are some Interview Questions for Accenture which will ask for SQL,PL SQL,ETL developer Interview:ġ.What is SQL?(100 % Interview Questions for Accenture )Īnswer: SQL Stands for Structured Query Language which is specially designed to communicate with databases.SQL pronounced as Sequel is very widely used language in most of the database management systems like Oracle,Mysql,Postgresql etc.SQL provides us a simple and efficient way of reading,writing,executing the data from the system.this is one of the SQL Interview Question ever asked in interviewsĢ.What is the use of NVL function in Oracle?(80% asked Interview Questions for Accenture )Īnswer: NVL function is most important function to replace null value with another value.Įxample: select NVL(null,’Amit’) from dual which will give you output as Amit.ģ.What is Correlated Subquery?Explain with the steps of execution with example.Ĭorrelated query is the query which is executed after the outer query is executed.The outer query is always dependent on inner query.The approach of the correlated subquery is bit different than normal subqueries.In normal subqueries the inner queries are executed first and then the outer query is executed but in Correlated Subquery outer query is always dependent on inner query so first outer query is executed then inner query is executed.Correlated Subqueries always uses operator like Exist,Not Exist,IN,Not IN.