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 |
How to work with data objects interactively?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What are the differences between interval year to month and interval day to second?
What is the data pump import utility?
What exactly do quotation marks around the table name do?
What is coalesce function?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
What are the database administrators utilities available?
how can we store any pdf file in oracle
What is a package ? What are the advantages of package ?
Explain how are indexes update?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,