Online Access Free 1Z1-050 Exam Questions

Which three statements are true regarding persistent lightweight jobs? (Choose three.)

• A.Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
• B.Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
• C.The use of a template is mandatory to create persistent lightweight jobs.
• D.The user cannot set privileges on persistent lightweight jobs.
• E.Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A.Automatic undo management must be enabled.
• B.The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
• C.Undo retention guarantee must be enabled.
• D.Database must be running in archivelog mode.

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database: RMAN> CONNECT target sys/sys@APPPROD RMAN> DUPLICATE TARGET DATABASE
TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)

• A.The password file must exist for the source database and have the same SYS user password as the target.
• B.The target database backups should be copied to the source database backup directories.
• C.The target database should be in ARCHIVELOG mode if it is open.
• D.RMAN should be connected to both the instances as SYSDBA
• E.The source database should be open.

Observe the following PL/SQL block:
BEGIN
dbms_spm .configure('SPACE_BUDGET_PERCENT', 30);
END;
Which statement is correct regarding the above PL/SQL block?

• A.It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.
• B.It reserves 30% of the space in the SYSTEM tablespace for SMB.
• C.It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
• D.It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

You executed the following commands:
SQL> VAR tname VARCHAR2(60);
SQL> BEGIN
:tname := lmy_instance_analysis_mode_task,;
DBMS_ADDM .INSERT_SEGMENT_DIRECTIVE(:tname ,lSg_directivel ,'SCOTT1); END;
Which statement describes the consequence?

• A.The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
• B.The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
• C.The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
• D.All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.