What is a Data File ?
Answer / orawhiz
Every ORACLE database has one or more physical data files. A
database's data files contain all the database data. The
data of logical database structures such as tables and
indexes is
physically stored in the data files allocated for a database
| Is This Answer Correct ? | 6 Yes | 1 No |
What is integrity and what is constraint??Explain with example
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
What is a shared pool?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What are the different editions of oracle?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Explain index?
What is redo log?
how to we delete a row using varray
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
How do I manually create a database in oracle?
What are the different types of databases?