When a user process fails, what background process cleans up
after it?
Answer / guest
It is PMON which clean up the memory and other resources
allocated to a given user process after it fails
Regards
Abhinav
| Is This Answer Correct ? | 14 Yes | 0 No |
how will u see whether the dabase is in archive log mode or not?
Give two examples of referential integrity constraints.
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
In oracle 10g export, import if we declare rows=y/n what would be the output?
when does an alert gets signaled?
What are the ways tablespaces can be managed and how do they differ?
How would you force a log switch?
Why does Oracle not permit the use of PCTUSED with indexes?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
what is a user-defined lock?
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)