1Z0-182 무료 덤프문제 온라인 액세스

Which two statements are true about views used for viewing tablespace and datafile information?

• A.V$TABLESPACE displays information about tablespaces contained in the data dictionary.
• B.V$TABLESPACE displays information that is contained in the control file about tablespaces.
• C.Tablespace free space can be viewed in V$TABLESPACE.
• D.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.
• E.Tablespace free space can be viewed in DBA_TABLESPACES.

Which two statements are true about the configuration and use of UNDO?

• A.UNDO_RETENTION specifies how long all types of UNDO are retained.
• B.UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.
• C.UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
• D.Unexpired UNDO is always retained.
• E.Active UNDO is always retained.

Which three statements are true about an SPFILE?

• A.It contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.
• B.It contains only static initialization parameters.
• C.It must exist for a database instance to start.
• D.It can be created by SYS from an idle instance.
• E.It can be used to create a PFILE.

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

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

Which two AWR-based tools listed below are part of Oracle Database self-tuning components?

• A.Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic.
• B.Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• C.Automatic Diagnostic Collector used to capture and store database errors and hung analysis.
• D.ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably.
• E.Automatic Application Tracing used to collect High-Load SQL statements and statistics.
• F.Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic.