0

databases Online Quiz - 175

Description: databases Online Quiz - 175
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. It creates the pointer file

  2. It creates the base directory

  3. It creates the inventory pointer file

  4. It creates the oracle user for installation.

  5. It modifies the UNIX kernel parameters to match oracle’s requirements.


Correct Option: C
  1. backup set only

  2. image copy only

  3. only user-managed backup

  4. both image copy and backup set

  5. only incremental image copy backup


Correct Option: A
  1. uses undo data for roll forward

  2. uses flashback log for recovery

  3. uses online redo logs to roll back

  4. uses undo data to roll back the transaction

  5. uses recovery managers (RMAN) to roll back.


Correct Option: D

You are using the following command to clear the log file group ALTER DATABASE CLEAR LOGFILE GROUP 2; In which case would the command be successful?

  1. Group 2 is the active group

  2. Group 2 is the current group

  3. Database is in the MOUNT stage

  4. Group 2 has been already archived


Correct Option: D
  1. Flash back the database

  2. Perform a point-in-time recovery.

  3. Perform a full database recovery.

  4. Drop and re-create the tablespace.

  5. Use recovery manager (RMAN) to recover the database.


Correct Option: D
  1. Guarantee undo retention

  2. Add one more redo log group.

  3. Configure an appropriate undo retention interval.

  4. Size the UNDO tablespace appropriately.

  5. Size the SYSTEM tablespace appropriately.


Correct Option: A,C,D
  1. roll back of large transaction

  2. roll forward to redo a transaction

  3. data concurrency for large updates

  4. read consistency for long running transactions.


Correct Option: D
  1. Set the SESSION to 1 in the parameter file.

  2. Grant SINGLE SESSION privileges to all of the users.

  3. Set SESSION_PER_USER to 1 in user’s profile.

  4. Grant RESTRICTED SESSION to all of the database users.

  5. Create a role with SINGLE SESSION privilege and assign the role to users.


Correct Option: C
  1. trace file

  2. audit trail

  3. control file

  4. alert log file

  5. event viewer


Correct Option: D
  1. Enable instance failover

  2. Configure shared server

  3. Enable database failover

  4. Enable connect-time failover

  5. Enable Transparent Application Failover


Correct Option: D
  1. The analysis tool doesn’t provide output for the performance of SQL statement

  2. The results of analysis are stored in tables, belonging to SYS user in the SYSAUX tablespace.

  3. The results of analysis are stored in tables, belonging to SYS user in the SYSTEM tablespace.

  4. The analysis runs automatically after each Automatic Workload Repository (AWR) snapshot.


Correct Option: D
  1. Transactions are rolled back using redo log files.

  2. Transactions are rolled forward using redo log files.

  3. Transactions are rolled back using redo log files and archived log files.

  4. Transactions are rolled forward using redo log files and rolled back using redo log files


Correct Option: B
- Hide questions