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 |
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What are the different types of indexes available in sql server? : sql server DBA
How do you tell what your machine name is and what is its IP address?
what is the differnce between process and thread ?
what is incremental checkpoint?
When creating a user, what permissions must you grant to allow them to connect to the database?
What view would you use to determine free space in a tablespace?
what is the use of ocr?
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.
Can you redefine a table online?
What is the difference between dropping a database and taking a database offline? : sql server DBA
What is transparent data encryption? : sql server DBA
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)