Exam information

Exam 1Z0-042: Database 10g Administration I

Other exams

A user receives the following error while executing a query:ORA-01555: snapshot too oldWhich two options can be the solutions to avoid such errors in future?

A user receives the following error while executing a query:ORA-01555: snapshot too oldWhich two options can be the solutions to avoid such errors in future? (Choose two.)

What are the consequences of executing the SHUTDOWN ABORT command?

What are the consequences of executing the SHUTDOWN ABORT command? (Choose two.)


What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?

You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance?

Which method would you suggest to the bank for achieving this task?

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 […]

Which three operations would wait when issued in SCOTT’s second session?

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:SQL> SELECT job FROM emp2 WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database. Which three operations […]

Which two statements are true in this scenario?

In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario? (Choose two.)

Which three pieces of information would you check to confirm that the statistics have been collected?

In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected? (Choose three.)

logTABLES=employeesWhat would be the outcome of this command?

You executed the following command to export the EMPLOYEES table from a remote machine:$ EXPDP hr/hr@data.us.oracle.comDUMPFILE=my_dir:exp_hr.logLOGFILE=data_pump_dir:log_hr.logTABLES=employeesWhat would be the outcome of this command?

Which three statements are correct about temporary tables?

Which three statements are correct about temporary tables? (Choose three.)

Which two effects would you see in your database?

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? (Choose two.)

Page 1 of 1612345...10...Last »