Tag: databases

Questions Related to databases

Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command?
technology databases

  1. Backups will never expire.

  2. It removes any retention policy.

  3. The DELETE OBSOLETE command will fail with an error.

  4. It sets the retention policy to the default of REDUNDANCY 1.

Show answer
Correct Option: D

You have just run this syntax to start the listener from the Listener Control utility: LSNRCTL>START Starting /mstgelai/oracle/bin/tnslsnr: please wait... System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to... The command completed successfully What is the name of the Listener you started?
technology databases

  1. TNSLSNR

  2. LISTENER

  3. LOCAL_LISTENER

  4. DEFAULT_LSRN

Show answer
Correct Option: B

A tablespace has a table with 30 extents in it. Is this bad?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

A tablespace has a table with 30 extents in it. Is this bad?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem?
technology databases

  1. True

  2. False

Show answer
Correct Option: B

When performing recovery of a database in NOARCHIVELOG mode with RMAN, the target database must be in the ______ state to restore the control file.

technology databases

  1. OPEN

  2. IDLE

  3. MOUNT

  4. NOMOUNT

Show answer
Correct Option: D

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

The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The index become fragmented. Whic statment is true ?
technology databases

  1. The index need to be dropped, and then re-created.

  2. The resolution of index fragmentation depends on the type of index.

  3. The index can be rebuilt while users continue working on the table.

  4. The fragmented can be ignored because Oracle resolve index fragmentation by means of a freelist.

  5. The index can be rebuilt, but users will not have access to the index during this time.

Show answer
Correct Option: C