HCL SOFTWARE CERTIFIED ADMINISTRATOR
BIGFIX PLATFORM 11 EXAM 2026
COMPREHENSIVE STUDY GUIDE
◉ Your database is open and the LISTENER listener is running. The
new DBA of the system stops the listener by using the command:
LSNRCTL> STOP What happens to the sessions that are presently
connected to the database instance? Answer: The sessions are not
affected and continue to function normally
◉ The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$OS_ROLES =
FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES =
FALSETIMED_OS_STATISTICS = 0 You have a local operating system
user SKD. You create a database user OPS$SKD, and then assign
external authentication. The user OPS$SKD has the CREATE
SESSION privilege. What would you achieve by the above process?
Answer: The local operating system user SKD will be able to access
the database instance without specifying the username and
password
◉ Your database instance is running with full workload after
database creation. You have decided to use a fixedsize undo
tablespace. You want to use the undo Advisor to estimate the
capacity of the undo tablespace.What two factors must you consider
before using the Undo Advisor to estimate the capacity of the undo
, tablespace? Answer: The retention period to support flashback, The
expected length of the longest-running query
◉ The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance
recovery? Answer: All redo log entries after the last checkpoint are
applied from redo log files to data files
◉ Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0LOG_CHECKPOINT_INTERVAL=0
What will be the implications of these values in your database?
Answer: The MTTR advisor will be disabled, Automatic checkpoint
tuning will be disabled
◉ You are using a SharePoint load balancing project that is stored in
the procedure catalog. An Environment has been defined in the
procedure catalog. You need to add the Environment to the project.
What stored procedure should you use? Answer: The
catalog.create_environment_reference stored procedure
◉ Identify two situations in which you can use Data Recovery
Advisor for recovery. Answer: The database files are corrupted when
the database is open, The database is not opening because the
required database files are missing
BIGFIX PLATFORM 11 EXAM 2026
COMPREHENSIVE STUDY GUIDE
◉ Your database is open and the LISTENER listener is running. The
new DBA of the system stops the listener by using the command:
LSNRCTL> STOP What happens to the sessions that are presently
connected to the database instance? Answer: The sessions are not
affected and continue to function normally
◉ The database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$OS_ROLES =
FALSEREMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES =
FALSETIMED_OS_STATISTICS = 0 You have a local operating system
user SKD. You create a database user OPS$SKD, and then assign
external authentication. The user OPS$SKD has the CREATE
SESSION privilege. What would you achieve by the above process?
Answer: The local operating system user SKD will be able to access
the database instance without specifying the username and
password
◉ Your database instance is running with full workload after
database creation. You have decided to use a fixedsize undo
tablespace. You want to use the undo Advisor to estimate the
capacity of the undo tablespace.What two factors must you consider
before using the Undo Advisor to estimate the capacity of the undo
, tablespace? Answer: The retention period to support flashback, The
expected length of the longest-running query
◉ The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance
recovery? Answer: All redo log entries after the last checkpoint are
applied from redo log files to data files
◉ Examine the values for the following initialization parameters:
FAST_START_MTTR_TARGET=0LOG_CHECKPOINT_INTERVAL=0
What will be the implications of these values in your database?
Answer: The MTTR advisor will be disabled, Automatic checkpoint
tuning will be disabled
◉ You are using a SharePoint load balancing project that is stored in
the procedure catalog. An Environment has been defined in the
procedure catalog. You need to add the Environment to the project.
What stored procedure should you use? Answer: The
catalog.create_environment_reference stored procedure
◉ Identify two situations in which you can use Data Recovery
Advisor for recovery. Answer: The database files are corrupted when
the database is open, The database is not opening because the
required database files are missing
