please explain about oracle
Answer / su
-Oracle is a database, you can store data(RDBMS, since it
follows more than 8 rule out of 12 proposed by E F Codd).
-Made up of memory structures and back ground processes.
-Memory structure - SGA (system global area) and PGA
(Process Global Area)
-Background Process are Database writer (DBWR) which
actually writes to the physical files (Data files), Log
Writer (LGWR) which writes to the physical log files
(important to get the database in consistent state if there
is a crash)
-Combination of memory structure and backgroung processes
gives us oracle instances , which is instrumental in
helping us work with the oracle database
:)
| Is This Answer Correct ? | 0 Yes | 0 No |
key flexfield structure
How would you determine what sessions are connected and what resources they are waiting for?
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Name two files used for network connection to a database.
In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record
What is Tax Categories?
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
what is debit memo and credit memo in AR?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain the difference between a hot backup and a cold backup and the benefits associated with each
the user should know to which database he is connected currently in oracle
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..