Online Access Free 1Z1-182 Practice Test

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

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

Which three statements are true about the tools used to configure Oracle Net Services?

• A.The lsnrctl utility requires a listener.ora file to exist before it is started.
• B.Oracle Net Manager can be used to locally configure naming methods on a database server.
• C.Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.
• D.The Oracle Net Configuration Assistant is only used when running the Oracle installer.
• E.Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
• F.Oracle Net Manager can be used to centrally configure listeners on any database server target.

Which three statements are true about resumable space allocation in Oracle databases?

• A.All sessions must have the same timeout value when waiting for resumable space allocations.
• B.Resumable space allocation may be enabled for some sessions and not others.
• C.The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
• D.A user's session may be suspended and resumed multiple times.
• E.Resumable space allocation is only possible with locally managed tablespaces.
• F.A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

• A.The role has the privileges to create and manage users within the PDB.
• B.The role has the privileges to administer the PDB.
• C.The role has the privileges to perform DDL operations on all local schema objects.
• D.No privileges are provided with the PDB_DBA role.

What are the three components of Oracle Database Automatic Maintenance Tasks?

• A.The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.
• B.A packaging system that allows you to combine all error and failure logs to share with Oracle Support.
• C.Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.
• D.A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.
• E.A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.
• F.A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.