1Z0-045 試験問題を無料オンラインアクセス

You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?

• A.FREQ = MONTHLY; BYDAY = FRI(2);
• B.FREQ = MONTHLY; BYDAY = 2FRI;
• C.FREQ = MONTHLY; BYDAY = FRI2;
• D.FREQ = MONTHLY; BYDAY = -2FRI;

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down:
SQL> shutdown immediate;
What is the result of executing this command?

• A.The ASM instance is shut down, but the other instances are still running.
• B.HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode.
• C.HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
• D.All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
• E.All the instances, including the ASM instance, are shut down in the ABORT mode.
• F.The ASM instance is still functional, but the other instances are shut down.

Identify the three predefined server-generated alerts. (Choose three.)

• A.SYSTEMTablespace Size Increment
• B.Recovery Area Low On Free Space
• C.Tablespace Space Usage
• D.Privilege Grants
• E.Drop User
• F.Tablespace Reorganization
• G.Resumable Session Suspended

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two).

• A.To tune memory using the existing *_AREA_SIZE parameters.
• B.To allocate memory to work areas in order to optimize both throughput and response time.
• C.To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.
• D.To allocate memory to work areas in order to optimize response time only.
• E.To allocate memory to work areas in order to optimize throughput only.

You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?

• A.Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.
• B.The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.
• C.The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.
• D.The EMPLOYEES table will be changed to read-only mode during the shrink operation.
• E.The data in the segment will be compacted but the high water mark will not be adjusted.