1Z0-042 Oracle Database 10g: Administration I our products come with a 100% guarantee of success. We hold this claim because of the highly dedicated and expert team that we have and because of our past performance.

Practicetest 1Z0-042 Oracle cert24

QUESTION NO: 1
A user receives the following error while executing a query:
ORA-01555: snapshot too old
Which two options can be the solutions to avoid such errors in future? (Choose two.)
A. increase the size of the Database Buffer Cache
B. increase the size of the default temporary tablespace
C. increase the size of redo log files
D. increase the size of the undo tablespace
E. enable the retention guarantee for the undo tablespace
Answer: D,E

QUESTION NO: 2
What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)
A. The database files are synchronized.
B. The database is closed, but the instance is still started.
C. The database undergoes automatic media recovery during the next startup.
D. Database buffers and redo buffers are not written to the disk.
E. Uncommitted changes are not rolled back.
Answer: D,E

QUESTION NO: 3
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a
bank. As part of the year-end tax and interest calculation process, all the rows in the table need to
be accessed. The bank authorities want to track access to the rows containing balance amounts
exceeding $200,000, and then send an alert message to the administrator. Which method would
you suggest to the bank for achieving this task?
A. performing standard database auditing to audit SQL statements with granularity level set to
ACCESS
B. implementing value-based auditing by using triggers
C. performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL
parameter to EXTENDED
D. implementing fine-grained auditing with audit condition and event handler
Answer: D

Practicetest 1Z0-042 Oracle cert24