7.7. Review Questions
What activity is responsible for causing most block corruption?
Human errors that introduce bugs caused by hardware, software, or firmware
Memory errors written to disk
Random I/O errors written to disk
A bad transaction that updates many tables
What is the most common way of detecting block corruption in the database?
Monitoring the operating system log files
Monitoring the application log files
Monitoring the ALERT.LOG database log
Monitoring the ALERT.LOG and associated trace files
What is the correct command to analyze the EMPLOYEE table in the schema owned by user TEST?
ANALYZE INDEX EMPLOYEE VALIDATE STRUCTURE
ANALYZE TABLE TEST.EMPLOYEE VALIDATE STRUCTURE
ANALYZE TABLE EMPLOYEE VALIDATE STRUCTURE
ANALYZE INDEX TEST.EMPLOYEE