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 4059emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 3459I 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 5560Please 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.
2362i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
5 79851. 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 4740nw 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
2263Post New Oracle General Questions
What is an Oracle Instance?
What is literal?
State any two functions of oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How to select some rows from a table in oracle?
How to revoke create session privilege from a user in oracle?
Is truncate autocommit in oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the different pseudo commands? Explain in general?
Is oracle an operator?
What the is the diff between local index and global index. give some example.
How to create a testing table in oracle?
What is materialized view in Oracle?
What is truncate oracle?
Explain the use of indexes option in exp command.