Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
IBM,
1 3146emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 2642I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?
2 4465How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
2239Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
1848i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
5 6044
How to drop an existing view in oracle?
How to create a new oracle data file?
What is concurrency in oracle?
What is memo?
How to use group functions in the select clause using oracle?
Which environment variables are absolutely critical in order to run the OUI?
What do you mean by oracle dba?
Why does for update in oracle 8 cause an ora-01002 error?
What is rac?
What are the common oracle dba tasks?
How to use attributes of the implicit cursor in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How to compare dates in oracle sql?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
List out the difference between commit, rollback, and savepoint?