The Log Writer (LGWR) process reads information from the ()and writes it to the online logs.
第1题:
For a given Servlet Response response, which two retrieve an object for writing text data? ()
第2题:
A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process (LGWR) at a log switch. How does this failure affect the operational database?()
第3题:
Which two statements about the background process of the database writer are true()
第4题:
the writer is enthusiastically supporting the National Lottery
the writer has objections to the National Lottery
the writer believes that the lottery money should be used for cancer research
the writer is just expressing her feelings about collecting money for charity
第5题:
the writer was to fail
the writer was stupid
he would do the same if possible
he would reject the writer’s request
第6题:
increase the size of the redo log buffer
increase the number of redo log groups
increase the number of log writer processes
increase the number of ARCn processes
change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
第7题:
large pool
shared pool
data buffer cache
redo log buffer
data dictionary cache
第8题:
It is possible to have multiple database writers in an Oracle instance.
It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
It writes dirty buffers, if any, to data files whenever a transaction commits.
It writes dirty buffers, if any, to data files before the log writer (LGWR) writes
第9题:
response.get writer ()
response.get Output Stream ()
response.getOutput Writer()
response.get Writer ().get Output Stream ()
response.get Writer (Writer.OUTPUT_BINARY)
第10题:
The database re-created the missing redo log files automatically.
The database continues to function normally with the existing files.
The database allows only queries, no other statements are allowed.
The database returns and error and the database instance shuts down.
The user sessions that generate redo logs are terminated automatically.
第11题:
RECOVER LOFIEL BLOCK GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE CLEAR LOGFILE GROUP 2;
ALTER DATABASE RECOVER LOGFILE GROUP 2;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
第12题:
the woman’s window was dirty
the writer’s window was dirty
the woman lived nearby
the writer was near-sighted
第13题:
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
第14题:
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
第15题:
Which two statements about the background process of thedatabase writerare true()
第16题:
The writer believed that a family tradition was not good.
The writer enjoyed talking with her father.
The writer tried to comfort her father with love.
The writer thanked her children for looking after her father.
第17题:
It is possible to have multiple database writers in an Oracle instance.
It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
It writes dirty buffers, if any, to data files whenever a transaction commits.
It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.
第18题:
Increase the size of redo log files
Increase the size of redo log buffer
Increase the number of redo log files
Place the redo log files on a separate disk
Decrease the number of redo log groups to two
Increate the number Log Writer (LGWR) process
第19题:
RECOVER LOGFILE BLOCK GROUP 2;
ALTER DATABASE DROP LOGFILE GROUP 2;
ALTER DATABASE CLEAR LOGFILE GROUP 2;
ALTER DATABASE RECOVER LOGFILE GROUP 2;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
第20题:
the writer’s pursuit for money or promotion
the writer’s laziness at his/her work
the writer’s deception on himself
the writer’s deception on the reader
第21题:
response.get Writer ()
response.get Output Stream ()
response.get Output Writer ()
response.get Writer ().get Output Stream()
response.get Writer (Writer.OUTPUT_TEXT)
第22题:
archival
log writer
database writer
system monitor
process monitor
change tracking writer
第23题:
The database instance aborts.
The database operation temporarily halts till the member becomes available.
Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.