What are inner join and outer join?3 8444
what are indexes..how many types of index's are there and what are they?7 11889
What are the components of Physical database structure of Oracle Database?4 8169
What are the components of Logical database structure of ORACLE database?4 10003
What is a Tablespace?5 5015
What is SYSTEM tablespace and When is it Created?2 4575
Explain the relationship among Database, Tablespace and Data file?4 7502
what happened to the global index when I truncate the data in one of the partition?
Whats the benefit of dbms_stats over analyze?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is the recommended interval at which to run statspack snapshots, and why?
can u plz provide me oca sql dumps please i need them
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
What is integrity and what is constraint??Explain with example
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
can anyody please send me the dump for Oracle 10g certifications for DBA path?