What are Schema Objects ?
Answers were Sorted based on User's Feedback
Answer / chaudhry
Schema objects are the logical structures that directly
refer to the database's data. Schema objects include tables,
views,
sequences, synonyms, indexes, clusters, database triggers,
procedures, functions packages and database links.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / nishi
Schema objects are logical data storage structures. Schema objects do not have a one-to-one correspondence to physical files on disk that store their information. However, Oracle stores a schema object logically within a tablespace of the database.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Row Chaining ?
Why use resource manager in Oracle?
How to create a table index?
How a tablespace is related to data files?
What are the uses of Rollback Segment ?
How to retrieve the count of updated rows?
Why does Oracle not permit the use of PCTUSED with indexes?
how to use sequence and what use of sequence cache
What is recovery manager in Oracle?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Explain the use of tables option in exp command.