What are Schema Objects ?
- 2 Answers
- 4887 Views
- I also Faced
- E-Mail Answers
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 |
Explain overloading. Can functions be overloaded?
Explain the difference between a procedure and a function? What do you understand by those terms?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Use of an integrity constraint is better to validate data. Explain
Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL
What is the difference between formal parameters and actual parameters?
How to calculate date and time differences in oracle?
What is Java Pool in Oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
In Exception handling if we are using the when others first then what happens . whether it will show the compiler error
Explain oracle left join with an example?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Oracle General 
