Quiz 1z0-042

Quiz 1z0-042, Database 10g Administration I

What action would you take to achieve this task?

Failure of which file would cause an instance to shut down?

What effect it will have on the database?

Which statement regarding the status of the database is true?

Which three descriptions are correct about the effects of the TRUNCATE command on a table?

What would you do to ensure that database is still running correctly?

You execute the following command to audit the database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;What is the effect of this command?

How does this change to the table affect the index?

ORA-02392: exceeded session limit on CPU usage, you are being logged offWhich action would you take to increase the session limit on CPU usage?

You execute the following command to audit the database activities:SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?