1Z1-182 試験問題を無料オンラインアクセス

Which three tasks are part of the predefined Automated Maintenance Tasks?

• A.Automatic error and failure log collection tasks.
• B.Automatic notification tasks.
• C.Automatic Optimizer Statistics Collection.
• D.Automatic Backups of the database system files.
• E.Automatic SQL Plan Management advisor tasks.
• F.Automatic segment and segment statistics advisor tasks.

Which three statements are true about using SQL*Plus?

• A.It can run scripts passed to it by a shell script.
• B.It has its own commands that are separate from any SQL statements.
• C.It must be downloaded from the Oracle Technology Network (OTN).
• D.It can run scripts entered at the SQL prompt.
• E.It can run Recovery Manager (RMAN) commands.
• F.It has both command-line and graphical user interfaces (GUI).

Which three statements are true about dynamic performance views?

• A.They are owned by the SYSTEM user.
• B.V$FIXED_TABLE can be queried to display the names of all dynamic performance views.
• C.Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
• D.They can be queried only when the database is open.
• E.Read consistency is not guaranteed.

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

• A.New connection requests made to the database instance are refused.
• B.Instance recovery occurs automatically during the shutdown.
• C.Sessions remain connected even if they are not running a transaction.
• D.Uncommitted transactions are allowed to continue to the next COMMIT.
• E.Uncommitted transactions are allowed to continue to the next ROLLBACK.

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?

• A.Log in to the database instance.
• B.Revoke the CREATE SESSION privilege from user HR.
• C.Revoke the CREATE SESSION privilege from other users.
• D.Execute DDL statements in the HR schema.
• E.Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
• F.Execute DML statements in the HR schema.