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 2923emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 2439I 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 4143Please 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.
1693i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
5 55541. How actually index will work ? 2. Why do people prefer mostly bitmap index and btree index in datawarehouse ? 3. If I use the column in aggrigate functions like max,min,count and avg and if I have a index created on that column, will it increases the performance ?
IBM,
1 3657nw 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
1540Post New Oracle General Questions
Difference between varchar and varchar2 data types?
How to bring a tablespace offline?
How do I manually create a database in oracle?
How to delete multiple rows from a table in oracle?
how do u setup a replication site?
What are the limitations oracle database 10g xe?
What are the components of logical database structure in oracle database?
Why is oracle used?
What are the different types of database objects?
How to use existing values in update statements using oracle?
How to use like conditions in oracle?
How do I find my oracle client driver version?
What are the built-in functions used for sending Parameters to forms ?
Explain what are the advantages of views?
Which are the five query types available in oracle?