Oracle Exam 1Z0-116 Topic 10 Question 69 Discussion

Actual exam question for Oracle's 1Z0-116 exam

Question #: 69
Topic #: 10

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.

Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

APARAMETER_NAM=>'CHECKPOINT'

BOBJECT_OWNER=>'SYS

CCLAUSE_NAME=>'CHECKPOINT'

DCLAUSE_NAME=>'SYSTEM'

ECOMMANI>=>' ALTER SYSTEM'

FOBJECT_NAME=>'CHECKPOINT'

GCOMMAND=>'ALTER'

Show Suggested Answer

Suggested Answer: C, D

by Leota at May 01, 2025, 06:49 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-116 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Paris

This question is like a game of 'spot the trap answer'! I'm going to go with A and C, but I'll be on the lookout for any sneaky trick questions.

upvoted 0 times

...

Dorcas

3 days ago

Wait, why would we need to specify the OBJECT_OWNER as 'SYS'? That seems a bit overkill. I'd go with A and C as well.

upvoted 0 times

...

Maryanne

5 days ago

I believe OBJECT_OWNER=>'SYS' and OBJECT_NAME=>'CHECKPOINT' should also be specified for more specific conditions.

upvoted 0 times

...

Frederick

9 days ago

I agree with Jin, those parameters make sense for restricting the alter system checkpoint command.

upvoted 0 times

...

Pamella

9 days ago

Haha, this is a tricky one! I bet the exam writers got a good laugh coming up with these options. But I'm pretty confident the right answers are A and C.

upvoted 0 times

Roslyn

2 days ago

I think you're right, A and C seem to be the most relevant parameters for restricting the alter system checkpoint command.

upvoted 0 times

...

Jin

18 days ago

I think the parameters to be specified are PARAMETER_NAME=>'CHECKPOINT' and COMMAND=>'ALTER SYSTEM'.

upvoted 0 times

...

Kristel

1 months ago

Hmm, I'm not sure about this one. Maybe D and E would work too, but I'd better double-check the docs just to be sure.

upvoted 0 times

Kristofer

13 days ago

B) OBJECT_OWNER=>'SYS'

upvoted 0 times

...

Lorean

14 days ago

A) PARAMETER_NAME=>'CHECKPOINT'

upvoted 0 times

...

Laticia

1 months ago

I think the answer is A and C. The PARAMETER_NAME must be 'CHECKPOINT' and the CLAUSE_NAME must be 'CHECKPOINT' to restrict the ALTER SYSTEM CHECKPOINT command.

upvoted 0 times

Dahlia

14 days ago

Great, so we need to specify PARAMETER_NAME=>'CHECKPOINT' and CLAUSE_NAME=>'CHECKPOINT' to restrict the ALTER SYSTEM CHECKPOINT command.

upvoted 0 times

...

Paulina

16 days ago

Yes, that's correct. Those are the two parameters specified in the dbms_macadm.create_command_rule procedure.

upvoted 0 times

...

Mohammad

1 months ago

I agree, the PARAMETER_NAME must be 'CHECKPOINT' and the CLAUSE_NAME must be 'CHECKPOINT'.

upvoted 0 times

...