Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)
SYNC or ASYNC to identify the network transmission mode.
LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.
AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.
PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.
Which three features are provided by Oracle Net Services? (Choose three)
Data encryption
User authentication
Transparent data conversion
Configuration and administration mechanisms
Support for multiple network transport protocols
What file will give you Oracle instance status information?
alert.ora
init.ora
tnsname.ora
redolog
An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?
PMON
SMON
RECO
ARCn
CKPT
CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?
Extent
Segement
Oracle block
Operating system block
You need to enforce these two business rules: 1. No two rows of a table can have duplicate values in the specified column. 2. A column cannot contain null values. Which type of constraint ensure that both of the above rules are true ?
Check
Unique
Not Null
Primary Key
Foreign Key
Which statement is ture regarding checkpoints and recovery ?
A checkpoint defines the highest system change number (SCN)
All redo entries higher or at the SCN are known to be written to the data files.
Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
The LOG_CHECKPOINT_INTERVAL initialization paramter specifies the amount of time beteen incremental checkpoints.
What should you look at to compute the number of undo blocks written per second on disk ?
V$UNDOSTAT
V$TRANSACTION
V$ROLLSTAT
DBA_UNDO_EXTENTS
DBA_ROLLBACK_SEGS
Which background process reads the redo log buffer and writes it to a file ?
DBWn
LGWR
In user-managed backup and recover procedure, how are data files backed up ?
Using SQL commands.
Using SQL*Plus Commands.
Using operating system commands.
Using Recover Manager commands.