0

databases Online Quiz - 140

Description: databases Online Quiz - 140
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Standalone utilities are also known as

  1. Online

  2. Offline

  3. Private

  4. Public


Correct Option: B

Which standalone utility can be used to move data between subsystems by translating OBID, PSID and DBID?

  1. DSN1COMP

  2. DSN1PRNT

  3. DSN1SDMP

  4. DSN1COPY


Correct Option: D

Which standalone utility can be used to move data between subsystems by translating OBID, PSID and DBID?

  1. DSN1COMP

  2. DSN1PRNT

  3. DSN1SDMP

  4. DSN1COPY


Correct Option: D

Which standalone utility used to format the contents of the recovery log for display?

  1. DSNJLOGF

  2. DSN1LOGP

  3. DSN1PRNT

  4. DSN1SDMP


Correct Option: B

Which standalone utility can be used to identify the contents of a tablespace, index or Image copy datasets?

  1. DSN1PRNT

  2. DSN1SDMP

  3. DSN1LOGP

  4. DSN1COMP


Correct Option: A

Which standalone utility trace the events to occur and force a dump to a user defined dataset?

  1. DSN1PRNT

  2. DSN1COPY

  3. DSN1CHKR

  4. DSN1SDMP


Correct Option: D
  1. Online

  2. Offline

  3. Private

  4. Public


Correct Option: B
  1. Perform I/O

  2. Lock rows that are not data dictionary rows

  3. Monitor other Oracle processes

  4. Connect users to the Oracle instance

  5. Execute SQL statments issued through an application


Correct Option: A
  1. Data encryption

  2. User authentication

  3. Transparent data conversion

  4. Configuration and administration mechanisms

  5. Support for multiple network transport protocols


Correct Option: A

Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)

  1. TARGET_REDO_BLKS

  2. FAST_START_IO_TARGET

  3. LOG_CHECKPOINT_TIMEOUT

  4. RECOVERY_ESTIMATED_IOS

  5. LOG_FILE_SIZE_REDO_BLKS

  6. LOG_CHECKPOINT_INTERVAL


Correct Option: B
  1. CREATE USER

  2. CREATE SESSION

  3. CREATE ANY TABLE

  4. IMP_FULL_DATABASE

  5. EXP_FULL_DATABASE


Correct Option: B

SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)

  1. Oracle Managed Files used for this instance.

  2. The USER_DATA tablespace in managed using FET$/UET$ tables.

  3. The COMPATIBLE intialization paramter must be 9.0.0 or higer.

  4. Space within segments is the USER_DATA tablespace is managed with freelists.


Correct Option: A

Which two statments regarding the control file and Recover Manager are true ? (Choose two)

  1. The control file can grow in size.

  2. The control file can store RMAN scripts.

  3. CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.

  4. The RMAN catalog can exist solely in the control file of the target database.


Correct Option: C
- Hide questions