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 is used to Preformat the Active Log

  1. DSNJU003

  2. DSNJLOGF

  3. DSN1LOGP

  4. DSN1SDMP


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

AI Explanation

To answer this question, we need to understand the different utilities available in IBM's Db2 for z/OS database management system.

Option A) DSN1COMP - This utility is used to compress Db2 table spaces and indexes. It does not have the capability to move data between subsystems or translate OBID, PSID, and DBID.

Option B) DSN1PRNT - This utility is used to print the data in a Db2 table space or index. It does not have the capability to move data between subsystems or translate OBID, PSID, and DBID.

Option C) DSN1SDMP - This utility is used to dump the data in a Db2 table space or index. It does not have the capability to move data between subsystems or translate OBID, PSID, and DBID.

Option D) DSN1COPY - This utility is used to copy Db2 table spaces and indexes. It can be used to move data between subsystems by translating OBID, PSID, and DBID. It allows you to specify the target subsystem and translate the identifiers accordingly.

The correct answer is D) DSN1COPY. This option is correct because it is the only utility among the given options that can be used to move data between subsystems by translating OBID, PSID, and DBID.

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

Standalone utilities are also known as

  1. Online

  2. Offline

  3. Private

  4. Public


Correct Option: B

When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)

  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 are the physical structures that constiture the Oracle database ? (Choose Three)

  1. Control file

  2. Extent

  3. Segment

  4. Data file

  5. Log file

  6. Tablespace


Correct Option: D

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

You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)

  1. ABORT

  2. NORMAL

  3. IMMEDIATE

  4. TRANSACTIONAL


Correct Option: B

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

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

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