{Learn-Intern-Certify}©

Understanding Analytic Functions in Oracle SQL by Rocky Jagtiani Oracle Certified Associate I train on Oracle Certification from last 7 years Analytic functions in Oracle SQL are very useful and are utilized by many people, but sometimes without completely understanding how they work or what data they operate on. This article does not focus on a specific function, but on analytic functions in general. I decided to write it because I have seen people being confused by the results they get when they make even a very small change in the analytic clause of a function call, which is the part that determines on which data the function will operate and how it will calculate the results, and also because several friends have asked me, during my Oracle Training sessions in the past. So, if you are new to analytic functions , or have only used them sporadically without completely understanding how they work, you might find this article useful. Contents [ 45 mins read & exe...

Manipulating Data Questions 1. What all operations can MERGE statement perform in SQL? INSERT DELETE GROUP BY None of the above 2.Which of following commands is a DDL (Data Definition Language) command but is often considered along with DML commands? DELETE INSERT TRUNCATE None of the above 3. What among the following is a TRUNCATE statement equivalent to? (Choose the most suitable answer) To a DELETE statement To an UPDATE statement A DELETE statement without a WHERE clause None of the above 4.Which of the following situations indicate that a DML operation has taken place? When new rows are added to a table When two queries are combined When a table is truncated None of the above 5.What is true about the keyword VALUES in INSERT statements? VALUES can add multiple rows at a time during the INSERT VALUES can add only 100 rows at a time during the INSERT VALUES is mandatory to be used if we use the keywor...