Use the add_group_column function to add a column to record group that was created at a design time?
2 4433
Name the three major set of files on disk that compose a database in Oracle?
What are a collation and state the different types of collation sensitivity?
What is the difference between translate and replace in oracle?
Explain the various modes of normalization?
What is materialized view in Oracle?
How to define an anonymous procedure without variables?
Why cursor variables are easier to use than cursors?
State all possible different index configurations a table can possibly have?
How to create a single index for multiple columns?
Explain the use of analyse option in exp command.
How many categories of data types?
What is a private synonym?
Discuss row chaining, how does it happen? How can you reduce it?
Can a View based on another View in Oracle?
How many types of auditing in Oracle?