Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)
Oracle Security (38)
Oracle Forms Reports (510)
Oracle Data Integrator (ODI) (120)
Oracle ETL (15)
Oracle RAC (93)
Oracle D2K (72)
Oracle AllOther (241) 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 3966emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 3389I 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 5468How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
2697Please 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.
2310i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
5 7797
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
What do database buffers contain?
Is oracle a programming language?
What are the original export and import utilities?
What is Undo Management Advisor in Oracle?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What is transaction control statement and how many types of transaction control statement in Oracle?
Explain about the analyze command in oracle?
What are materialized views & where do we use them? What is a materialized view?
Whether any commands are used for months calculation? If so, what are they?
Does a dba have to file taxes?
What happens to the data files if a tablespace is dropped?
What is data block in Oracle?
How to login to the server without an instance?
what are actual and formal parameters?