Online Access Free 1Z0-050 Exam Questions

You issued the following command:
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS
TABLESPACE tbs_t1;
An index is then created on the ADMIN_WORK_AREA temporary table.
Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

• A.It stores both the temporary table as well as its indexes.
• B.It stores only the temporary table but not its indexes.
• C.It must be the default temporary tablespace of the user who issues the command.
• D.It can be a default or nondefault temporary tablespace for the database.
• E.It must be a nondefault temporary tablespace for the database.

You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

• A.Edit the automatic maintenance window group configuration.
• B.Set the CURSOR_SHARING parameter to EXACT for the database instance.
• C.Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.
• D.Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.

Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)

• A.adding the redo log member to the database
• B.database and operating system upgrades
• C.changing the database storage to ASM-managed storage
• D.multiplexing of the control file

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

• A.failures that require no archive logs to be applied for recovery
• B.failures when no standby database is configured
• C.failures due to loss of connectivity-for example, an unplugged disk cable
• D.failures because a data file is renamed by error

View the Exhibit that sets the threshold for the Current Open Cursors Count metric.

Why is the Significance Level threshold type not available in the threshold setting?

• A.because the AWR baseline is a system-defined moving window baseline
• B.because AWR baseline is not enabled
• C.because the STATISTICS_LEVEL parameter is set to BASIC
• D.because Current Open Cursors Count is not a basic metric