You as a DBA, executes ALTER SYSTEM command to update listener parameter value to register a new listener with the database.

Which of following statement is TRUE with respect to the execution of ALTER SYSTEM command?

After the command execution, to make the changes effective the database must be restarted

The command execution makes changes in the pfile of the database

The command execution makes changes in the spfile of the database

The command need to be executed twice to make the changes in spfile and pfile

Verified Answer
Correct Option - c

To get all Infosys Certified L1 Junior Database Admin Professional Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in