Free Oracle 1Z1-050 Exam Dumps Questions & Answers

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

• A.You cannot create an incremental incident package when the physical files are purged from the ADR.
• B.You can add SQL test cases to the incident package,
• C.You can add or remove the trace files to the package.
• D.You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)
SQL>STARTUP UPGRADE

• A.It enables all system triggers.
• B.It ensures that all job queues remain active during the upgrade process.
• C.It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
• D.It allows only SYSDBA connections.

You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:
SQL> SELECT dbms_addm.get_report(lmy_instance_analysis_mode_task') FROM dual;
You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?

• A.Disable the Segment Advisor from the Automatic Maintenance Task.
• B.Add a finding directive for the ADDM task.
• C.Add a parameter directive for the ADDM task.
• D.Add a segment directive for the ADDM task.

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 must be the default temporary tablespace of the user who issues the command.
• B.It stores both the temporary table as well as its indexes.
• C.It stores only the temporary table but not its indexes.
• D.It must be a nondefault temporary tablespace for the database.
• E.It can be a default or nondefault temporary tablespace for the database.

You issued the following command on the temporary tablespace LMTEMP in your database:
SQL>ALTER TABLESPACE Imtemp SHRINK SPACE KEEP 20M;
Which requirement must be fulfilled for this command to succeed?

• A.The tablespace must be made nondefault and offline.
• B.The tablespace can remain as the default but must have no active sort operations.
• C.The tablespace must have only one temp file.
• D.The tablespace must be locally managed.