Oracle DBA Interview Questions and Answers for Freshers - 1
Explain materialized views?
Materialized views are called snapshot.
They represent a state of data at a specific point to time.
These are generally used in warehouse application to avoid commonly used data analysis by storing analyzed data. Unlike normal views, they actually store data and need to be refreshed.
What is the use of dynamic SQL?
Dynamic SQL is an enhanced form of Structured Query Language (SQL) that is used to build SQL statement at runtime.
It is used when you do not know all parts of the SQL while writing the SQL.
What is a cursor?
Cursor is a handle or pointer to memory context area allocated for the execution of SQL statement.
What is Analytical function?
Analytical functions are used to perform data analysis for different subsets of a data set.
This is achieved through partition clause.
There are different types of analytical functions available in Oracle, which are given as follows.
Ranking functions, such as rank, dense_rank, row_number, ntile, percent_rank and cume_dist.
Windows functions, such as sum, max and avg.
What is conditional compilation?
Conditional compilation allows you to compile code conditionally based on compiler directives.
It is helpful when you need to have different code based on certain conditions.
7000+ TNPSC Group 1, 2, 4, VAO Indian Economy Study Materials Pdf More
7000+ Gate Computer Science Engineering Previous Year Questions More
7000+ Fill in the Blanks with Suitable Homonyms More
7000+ Fill in the Blanks with Suitable Homophones More
Power Semiconductor Device and Integrated Circuits MCQ Questions Pdf More
Trb Exam Date 2019-2020 | Physics Question Pattern More
15+ Economics Objective Type Questions and Answers More
7000+ Steel Making Quiz Questions and Answers Pdf More
100+ SBI PO Quantitative Aptitude Questions with Answers Pdf More
Computer Organisation Quiz Questions and Answers More