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 2509emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
1 2095I 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 3642Please 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.
1479i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
5 47021. 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 3256nw 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
1265Post New Oracle General Questions
What is rich query?
What is tns name?
How to use attributes of the implicit cursor in oracle?
How to create a stored function in oracle?
Explain joins in oracle?
What is a package ? What are the advantages of package ?
Explain an exception and its types?
Can group functions be mixed with non-group selection fields?
How to loop through data rows in the implicit cursor?
What is truncate oracle?
Explain the use of rows option in imp command.
11. Display the client number and name and the client number and name of the person who referred that client.
Can group functions be used in the order by clause in oracle?
material view and view disadvantages?
What is merge in oracle?
