What are different Oracle database objects?
Answer / parthasarathi
1)tables
2)views
3)sequences
4)synonyms
5)clusters
6)indexes
7)materialized views
8)procedures
9)functions
10)packages
11)triggers
| Is This Answer Correct ? | 1 Yes | 0 No |
What is an Oracle view?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the data types in oracle?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
What is flashback in Oracle?
What happens if the imported table already exists?
Use of an integrity constraint is better to validate data. Explain
What are the oracle built-in data types?
What is oracle rowcount?
List the various oracle database objects?
Does oracle partitioning improve performance?
What is flashback Query ? And Use ?