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 privilege is needed for a user to insert rows to tables in another schema?
What is a initialization parameter file in oracle?
What is self-referential integrity constraint ?
what are archived logs?
Describe Referential Integrity ?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
Explain the truncate in oracle?
What is a package in oracle?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
What is a table index in oracle?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
How do I limit the number of rows returned by an oracle query after ordering?