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 5468Please 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 77951. 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 4680nw 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
2209Post New Oracle General Questions
What is the simplest tool to run commands on oracle servers?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Is oracle an open source?
How to invoke the data pump export utility?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is a data dictionary and how can it be created?
What are privileges and grants?
In the oracle version 9.3.0.5.0, what does each number shows?
How data locks are respected in oracle?
Can objects of the same schema reside in different tablespace?
what happened to the global index when I truncate the data in one of the partition?
How to unlock the sample user account in oracle?
How to drop an index?
What are set operators?
What is a package ? What are the advantages of package ?