HCL SOFTWARE CERTIFIED ADMINISTRATOR
BIGFIX PLATFORM 11 EXAM 2026 COMPLETE
PRACTICE QUESTIONS AND ANSWERS
◉ In your database instance, the STATISTICS_LEVEL initialization
parameter is set to BASIC. What is the impact of this setting?
Answer: The snapshots for the Automatic Workload Repository
(AWR) are not generated automatically.
◉ You have recently collected statistics on certain objects of a
schema in your database. But you observe suboptimal execution
plans for the queries on these objects after two days of statistics
collection. The optimizer statistics retention period is set to its
default value. Which action would help to use the previous set of
statistics on the objects? Answer: Restore statistics from statistics
history.
◉ Examine the
command:SQL>DBMS_STATS.SET_TABLE_PREFS('SH&apos
;,'CUSTOMERS','PUBLISH','false&apo
s;); What statement describes the effect of the above command?
Answer: Subsequently, statistics gathered on the CUSTOMERS table
are stored as pending statistics
,◉ The instance abnormally terminates because of a power outage.
What 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 command:SQL>ALTER USR skd ACCOUNT LOCK;
What two statements are true after the command is executed?
Answer: The SKD user cannot log in to the database instance, The
other users can access the objects owned by the SKD user, on which
they have access
◉ The job to gather optimizer statistics for objects runs as part of
the automatic maintenance window in your database instance. At a
certain point of time, the maintenance window closes before the
statistics are gathered for all objects. What statement is true in this
scenario? Answer: The job is terminated and the statistics for the
remaining objects are collected the next time that the maintenance
window is opened.
◉ You want to move all objects of the APPS user in the test database
to the DB_USR schema of the production database. Which option of
IMPDP would you use to accomplish this task? Answer:
REMAP_SCHEMA
◉ You executed the following command to create a password file in
the database server: $ orapwd file = orapworcl entries = 5
ignorecase=N What statement describes the purpose of the above
, password file? Answer: It is used by Oracle to authenticate users for
remote database administrator
◉ SQL> CREATE BIGFILE TABLESPACE MRKTDATAFILE '
/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M
LOGGINGEXTENT MANAGEMENT LOCAL SEGMENT SPACE
MANAGEMENT AUTO; Tablespace created.SQL> ALTER
DATABASE DEFAULT TABLESPACE MRKT; Database altered. What
two statements are true regarding the MRKT tablespace? Answer:
No more data files can be added to the tablespace, A user created
without being assigned a default tablespace uses this tablespace
◉ After performing a clean shut down of the database instance for
maintenance, you mount the database and then execute a command
to open the database: SQL> ALTER DATABASE OPEN; What two
statements are true? Answer: The online redo log files and online
data files are opened, All the online data files headers are checked
for consistency
◉ Examine the command that is used to create a table: SQL>
CREATE TABLE orders (oid NUMBER(6) PRIMARY KEY,odate
DATE,ccode NUMBER (6),oamt NUMBER(10,2)) TABLESPACE users;
What two statements are true about the effect of the above
command? Answer: A NOT NULL constraint is created on the OID
column., The ORDERS table and a unique index are created in the
USERS tablespace.
BIGFIX PLATFORM 11 EXAM 2026 COMPLETE
PRACTICE QUESTIONS AND ANSWERS
◉ In your database instance, the STATISTICS_LEVEL initialization
parameter is set to BASIC. What is the impact of this setting?
Answer: The snapshots for the Automatic Workload Repository
(AWR) are not generated automatically.
◉ You have recently collected statistics on certain objects of a
schema in your database. But you observe suboptimal execution
plans for the queries on these objects after two days of statistics
collection. The optimizer statistics retention period is set to its
default value. Which action would help to use the previous set of
statistics on the objects? Answer: Restore statistics from statistics
history.
◉ Examine the
command:SQL>DBMS_STATS.SET_TABLE_PREFS('SH&apos
;,'CUSTOMERS','PUBLISH','false&apo
s;); What statement describes the effect of the above command?
Answer: Subsequently, statistics gathered on the CUSTOMERS table
are stored as pending statistics
,◉ The instance abnormally terminates because of a power outage.
What 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 command:SQL>ALTER USR skd ACCOUNT LOCK;
What two statements are true after the command is executed?
Answer: The SKD user cannot log in to the database instance, The
other users can access the objects owned by the SKD user, on which
they have access
◉ The job to gather optimizer statistics for objects runs as part of
the automatic maintenance window in your database instance. At a
certain point of time, the maintenance window closes before the
statistics are gathered for all objects. What statement is true in this
scenario? Answer: The job is terminated and the statistics for the
remaining objects are collected the next time that the maintenance
window is opened.
◉ You want to move all objects of the APPS user in the test database
to the DB_USR schema of the production database. Which option of
IMPDP would you use to accomplish this task? Answer:
REMAP_SCHEMA
◉ You executed the following command to create a password file in
the database server: $ orapwd file = orapworcl entries = 5
ignorecase=N What statement describes the purpose of the above
, password file? Answer: It is used by Oracle to authenticate users for
remote database administrator
◉ SQL> CREATE BIGFILE TABLESPACE MRKTDATAFILE '
/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M
LOGGINGEXTENT MANAGEMENT LOCAL SEGMENT SPACE
MANAGEMENT AUTO; Tablespace created.SQL> ALTER
DATABASE DEFAULT TABLESPACE MRKT; Database altered. What
two statements are true regarding the MRKT tablespace? Answer:
No more data files can be added to the tablespace, A user created
without being assigned a default tablespace uses this tablespace
◉ After performing a clean shut down of the database instance for
maintenance, you mount the database and then execute a command
to open the database: SQL> ALTER DATABASE OPEN; What two
statements are true? Answer: The online redo log files and online
data files are opened, All the online data files headers are checked
for consistency
◉ Examine the command that is used to create a table: SQL>
CREATE TABLE orders (oid NUMBER(6) PRIMARY KEY,odate
DATE,ccode NUMBER (6),oamt NUMBER(10,2)) TABLESPACE users;
What two statements are true about the effect of the above
command? Answer: A NOT NULL constraint is created on the OID
column., The ORDERS table and a unique index are created in the
USERS tablespace.
