What are the components of Logical database structure of
ORACLE database?
Answer Posted / nishi
There are tablespaces and database's schema objects.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Give the various rollback segment states.
What is ordinary table in oracle?
Which are the five query types available in oracle?
What is an anonymous block?
What are transaction isolation levels supported by oracle?
What is the data type of dual table?
How to rebuild an index in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How to define an external table with a text file?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Can a parameter be passed to a cursor?
Explain the use of inctype option in exp command.
Can we create trigger on materialized view in oracle?