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

Which two are true about the default listener for a single instance database? (Choose two.)

• A.It must be defined by using the Listener Control utility.
• B.It listens on the default port 1521.
• C.It must support at least one service on startup.
• D.It must be defined in the LISTENER.ORA file.
• E.It uses the settings of the INSTANCE_NAME and SERVICE_NAMES parameters from all databases using that listener.

Which three are true about Oracle Database backup taken with RMAN?

• A.A whole backup contains all data blocks of all data files.
• B.Only offline backup are consistent.
• C.A full backup contains all data blocks from one or more data files.
• D.An RMAN image copy can be written only to disk.
• E.RMAN always includes the control file in a backup.
• F.RMAN cannot backup REDO logs.

A user complains about poor database performance. You suspect that the user's session is losing time waiting for events to complete.
You want to verify this.
Which view reveals on what events a session has spent time waiting in the past?

• A.V$SYSTEM_EVENT
• B.V$SESSION_EVENT
• C.V$SESSION_WAIT_CLASS
• D.V$SESSION
• E.V$SESSION_WAIT

Which two are true about RETENTION GUARANTEE? (Choose two.)

• A.It is a static parameter.
• B.It prevents FLASHBACK DATABASE operation failure.
• C.It prevents "Snapshot too old" errors.
• D.It is a tablespace attribute.
• E.It prevents out-of-space errors.

Which two tasks does DBUA perform by default? (Choose two.)

• A.enabling flashback in the source database if not enabled
• B.running the Pre-Upgrade information tool
• C.setting user tablespaces to "read only" before starting the upgrade
• D.starting the source database instance if not started
• E.adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade