Which two events always cause the LGWR to write? (Choose two.)
A. when a checkpoint occurs
B. when DBWn writes dirty buffers
C. when LGWR is notified by a server process that performs a COMMIT OR ROLLBACK
D. when a log switch occurs
E. when PMON restarts a server process
Which three are true about the Automatic Workload Repository (AWR)? (Choose three.)
A. It is maintained by executing the PL/SQL procedures in the DBMS_STATS package.
B. It includes statistics that contain the number of distinct values per table column.
C. It includes statistics that contain the number of rows per table.
D. AWR data is stored in the SYSAUX tablespace.
E. Automatic AWR snapshots are created by the Manageability Monitor (MMON) background process.
F. By default, AWR data is retained for eight days.
Which two are true about the Inventory directory? (Choose two.)
A. It should be created before installing Oracle software for the first time on a server
B. It is shared by all Oracle software installations on a single server
C. It is required only for Oracle Grid Infrastructure and Oracle Database software installations
D. It is owned by the oinstall group, which must be created before installing Oracle software for the first time on a server
E. It can be created only if the ORACLE_BASE environment variable is set
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?
A. Restore statistics from statistics history.
B. Reduce the optimizer statistics retention period by 2 days.
C. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
D. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
A. It records usernames and passwords of users when granted the DBA role
B. It contains usernames and passwords of users for whom auditing is enabled
C. It is used by Oracle to authenticate users for remote database administrator
D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?
A. CLOB
B. BLOB
C. BFILE
D. LONG RAW
Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?
A. The DML operations re-create the bitmap index blocks
B. The bitmap index is rebuilt automatically after a DML operation
C. The smallest amount of a bitmap that can be locked is a bitmap segment
D. Additional time is taken to remove NULL values from the bitmap index after a DML operation
Your database instance is started using the server parameter file (SPFILE). You executed a command to
change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;
What would be the outcome of this command?
A. The command succeeds only if Automatic Memory Management is not enabled.
B. The command succeeds, but you need to restart the database for changes to take effect.
C. The command returns an error because the size of the redo log buffer cannot be changed dynamically.
D. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).
Which two statements about the background process of the database writer are true? (Choose two.)
A. It is possible to have multiple database writers in an Oracle instance.
B. It writes dirty buffers, if any, to data files whenever a checkpoint occurs.
C. It writes dirty buffers, if any, to data files whenever a transaction commits.
D. It writes dirty buffers, if any, to data files before the log writer (LGWR) writes.
View the Exhibit and examine the command used to create the ZONEDATA table. The table contains a million rows for zonewise analysis in the DSS system. DML operations are performed very rarely on the table. You decide to prepare an index on the ZONE column to enhance the performance of the queries on the ZONE column.
Which type of index would you select in this scenario?
Exhibit:
A. Bitmap index
B. Reverse key index
C. Normal BTree index
D. Functionbased index
