1z0-182 Exam Dumps - Oracle Database Questions and Answers

Execute DML statements in the HR schema.

Log in to the database instance.

Revoke the CREATE SESSION privilege from other users.

Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

Revoke the CREATE SESSION privilege from user HR.

Execute DDL statements in the HR schema.

Resumable space allocation may be enabled for some sessions and not others.

A user’s session may be suspended and resumed multiple times.

Resumable space allocation is only possible with locally managed tablespaces.

All sessions must have the same timeout value when waiting for resumable space allocations.

A user’s session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.

The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

It will be a dictionary-managed tablespace by default.

Additional data files may not be added.

AUTOEXTEND is possible for the datafile.

It will always have a 32K blocksize.

It must be bigger than the largest SMALLFILE tablespace.

COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level.

At the CDB level.

At the Application Root level of an Application Container.

At any level by using the COMMON option in the policy.

At the PDB level if the policy is created by a COMMON user.

Renaming data files.

Enabling online redo log archiving.

Creating a database.

Re-creating control files.

Full database recovery.

SQL Tuning Advisor

SQL Statistics Advisor

SQL Performance Analyzer

SQL Access Advisor

Oracle Net Manager can be used to centrally configure listeners on any database server target.

The Oracle Net Configuration Assistant is only used when running the Oracle installer.

Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.

Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.

The lsnrctl utility requires a listener.ora file to exist before it is started.

Oracle Net Manager can be used to locally configure naming methods on a database server.

The maximum number of sessions permitted for a user before the password must be changed.

The maximum amount of CPU time allowed for a user’s sessions before their account is locked.

The number of days for which an account may be logged in to one or more sessions before it is locked.

The ability to prevent a password from ever being reused.

The number of days for which an account may be inactive before it is locked.