Tag: databases

Questions Related to databases

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)

technology databases

  1. SYNC or ASYNC to identify the network transmission mode.

  2. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

  3. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

  4. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

Show answer
Correct Option: A

Which three features are provided by Oracle Net Services? (Choose three)

technology databases

  1. Data encryption

  2. User authentication

  3. Transparent data conversion

  4. Configuration and administration mechanisms

  5. Support for multiple network transport protocols

Show answer
Correct Option: A

What file will give you Oracle instance status information?
technology databases

  1. alert.ora

  2. init.ora

  3. tnsname.ora

  4. redolog

Show answer
Correct Option: A

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 ?
technology databases

  1. PMON

  2. SMON

  3. RECO

  4. ARCn

  5. CKPT

Show answer
Correct Option: B

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?

technology databases

  1. Extent

  2. Segement

  3. Oracle block

  4. Operating system block

Show answer
Correct Option: A

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 ?
technology databases

  1. Check

  2. Unique

  3. Not Null

  4. Primary Key

  5. Foreign Key

Show answer
Correct Option: D

Which statement is ture regarding checkpoints and recovery ?

technology databases

  1. A checkpoint defines the highest system change number (SCN)

  2. All redo entries higher or at the SCN are known to be written to the data files.

  3. Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.

  4. The LOG_CHECKPOINT_INTERVAL initialization paramter specifies the amount of time beteen incremental checkpoints.

Show answer
Correct Option: C

What should you look at to compute the number of undo blocks written per second on disk ?

technology databases

  1. V$UNDOSTAT

  2. V$TRANSACTION

  3. V$ROLLSTAT

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS

Show answer
Correct Option: A

Which background process reads the redo log buffer and writes it to a file ?

technology databases

  1. ARCn

  2. DBWn

  3. CKPT

  4. LGWR

  5. PMON

  6. SMON

Show answer
Correct Option: D

In user-managed backup and recover procedure, how are data files backed up ?

technology databases

  1. Using SQL commands.

  2. Using SQL*Plus Commands.

  3. Using operating system commands.

  4. Using Recover Manager commands.

Show answer
Correct Option: C