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 |
Why do we use bulk collect in oracle?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
Can we create more than one constraint to column ?
How to retrieve first and last records from a table?
What are the components of logical database structure in oracle database?
How to upsert (update or insert into a table)?
is database gud carrier option??
What is COST-based approach to optimization ?
How to define an explicit cursor in oracle?
what is the exact definition for pointer?
Explain the use of log option in exp command.
How to convert times to characters in oracle?