1z0-182 Practice Questions

A.  

Oracle Database Metrics monitor performance using thresholds to generate alerts.

B.  

Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events.

C.  

Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance.

D.  

Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control's Notification system used to email alerts.

E.  

Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

A.  

Instance recovery occurs automatically during the shutdown.

B.  

Uncommitted transactions are allowed to continue to the next ROLLBACK.

C.  

New connection requests made to the database instance are refused.

D.  

Sessions remain connected even if they are not running a transaction.

E.  

Uncommitted transactions are allowed to continue to the next COMMIT.

A.  

Renaming data files.

B.  

Enabling online redo log archiving.

C.  

Creating a database.

D.  

Re-creating control files.

E.  

Full database recovery.

A.  

ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.

B.  

Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated.

C.  

Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.

D.  

The first block with enough free space to accommodate a row being inserted will always be used for that row.

E.  

PCTFREE defaults to 10% for all blocks in all segments for all compression methods.

A.  

It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

B.  

It skips only tables that exist in ORCL:SH and ORCL:O

E.  

C.  

It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

D.  

It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.

E.  

It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

A.  

It must be the name of the database to whose instance HR wishes to connect.

B.  

It must resolve to a valid connect descriptor in the client's tnsnames.ora file.

C.  

It must be the name of the server running the database to whose instance HR wishes to connect.

D.  

It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

E.  

It must be the value of the SERVICE_NAMES parameter on the client side.

A.  

By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.

B.  

The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

C.  

The predefined maintenance window starts automatically with 20% of the system resources ...

D.  

The SYS_GROUP consumer resource group policies define the resources assigned ...

A.  

Automatic Backups of the database system files.

B.  

Automatic Optimizer Statistics Collection.

C.  

Automatic error and failure log collection tasks.

D.  

Automatic SQL Plan Management advisor tasks.

E.  

Automatic notification tasks.

F.  

Automatic segment and segment statistics advisor tasks.

A.  

A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

B.  

Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.

C.  

The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.

D.  

A packaging system that allows you to combine all error and failure logs to share with Oracle Support.

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.

A.  

It permits DML on global temporary tables even if the database is opened read-only.

B.  

It reduces the amount of UNDO stored in the UNDO tablespace.

C.  

It reduces I/Os to the SYSTEM tablespace.

D.  

It reduces the amount of redo generated.

E.  

It reduces I/Os to the SYSAUX tablespace.