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
  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 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

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

  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
  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

Which two roles or privileges must you have to export tables owned by another user? (Choose two)

  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
  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