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 3965emp 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 5466Please 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 77921. 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
2208Post New Oracle General Questions
What is oracle latest version?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is Reduced List of Values?
Explain integrity constraint?
What do you mean by a tablespace?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is where clause in oracle?
How do I escape a reserved word in oracle?
How many file formats are supported to export data?
What would you do with an in-doubt distributed transaction?
How to delete a column in an existing table in oracle?
What is java oracle used for?
How to pass a parameter to a cursor in oracle?
What is a parameter file in oracle?
Explain the use of log option in exp command.