• databases Online Quiz - 140
Back
0

databases Online Quiz - 140

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

Standalone utilities are also known as

technology databases

  1. Online

  2. Offline

  3. Private

  4. Public

Show answer
Correct Option: B

Which standalone utility is used to Preformat the Active Log

technology databases

  1. DSNJU003

  2. DSNJLOGF

  3. DSN1LOGP

  4. DSN1SDMP

Show answer
Correct Option: B

Which standalone utility is used to modify the BSDS(BootStrap DataSet)?

technology databases

  1. DSNJLOGF

  2. DSN1CHKR

  3. DSNJU003

  4. DSNJ004

Show answer
Correct Option: C

Which standalone utility can be used to list System and Utility timestamps, Contents of Quiesce history record, active Log datasets available etc.

technology databases

  1. DSN1LOGP

  2. DSNJU003

  3. DSNJU004

  4. DSNJLOGF

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the purpose of each utility and which one is used to perform specific tasks. Let's go through each option to understand why it is correct or incorrect:

Option A) DSN1LOGP - This utility is used to format and print the System Log data set (SYSLOG) contents. It does not provide information about Quiesce history records or active Log datasets available. Therefore, this option is incorrect.

Option B) DSNJU003 - This utility is used to print and delete Log data sets that are no longer needed. It does not provide information about System and Utility timestamps, Quiesce history records, or active Log datasets available. Therefore, this option is incorrect.

Option C) DSNJU004 - This utility is used to list System and Utility timestamps, Contents of Quiesce history record, active Log datasets available, and other related information. This option is correct because it provides the required functionality.

Option D) DSNJLOGF - This utility is used to format and print the System Log data set (SYSLOG) contents. It does not provide information about Quiesce history records or active Log datasets available. Therefore, this option is incorrect.

The correct answer is Option C) DSNJU004. This option is correct because it provides the utility to list System and Utility timestamps, Contents of Quiesce history record, active Log datasets available, and other related information.

Which standalone Utility verifies the Integrity of DB2 directory and Catalog

technology databases

  1. DSN1SDMP

  2. DSN1LOGP

  3. DSN1COMP

  4. DSN1CHKR

Show answer
Correct Option: D

Which Utility is used to estimate space savings to be achieved by DB2 Data compression in tablespaces?

technology databases

  1. DSN1COMP

  2. DSN1CHKR

  3. DSN1COPY

  4. DSN1SDMP

Show answer
Correct Option: A

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

technology databases

  1. DSN1COMP

  2. DSN1PRNT

  3. DSN1SDMP

  4. DSN1COPY

Show answer
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?

technology databases

  1. DSN1COMP

  2. DSN1PRNT

  3. DSN1SDMP

  4. DSN1COPY

Show answer
Correct Option: D

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

technology databases

  1. DSNJLOGF

  2. DSN1LOGP

  3. DSN1PRNT

  4. DSN1SDMP

Show answer
Correct Option: B

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

technology databases

  1. DSN1PRNT

  2. DSN1SDMP

  3. DSN1LOGP

  4. DSN1COMP

Show answer
Correct Option: A

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

technology databases

  1. DSN1PRNT

  2. DSN1COPY

  3. DSN1CHKR

  4. DSN1SDMP

Show answer
Correct Option: D

Standalone utilities are also known as

technology databases

  1. Online

  2. Offline

  3. Private

  4. Public

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: A

Which three are the physical structures that constiture the Oracle database ? (Choose Three)

technology databases

  1. Control file

  2. Extent

  3. Segment

  4. Data file

  5. Log file

  6. Tablespace

Show answer
Correct Option: D

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

technology databases

  1. Data encryption

  2. User authentication

  3. Transparent data conversion

  4. Configuration and administration mechanisms

  5. Support for multiple network transport protocols

Show answer
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)

technology databases

  1. ABORT

  2. NORMAL

  3. IMMEDIATE

  4. TRANSACTIONAL

Show answer
Correct Option: B

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

technology databases

  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

Show answer
Correct Option: B

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

technology databases

  1. CREATE USER

  2. CREATE SESSION

  3. CREATE ANY TABLE

  4. IMP_FULL_DATABASE

  5. EXP_FULL_DATABASE

Show answer
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)

technology databases

  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.

Show answer
Correct Option: A

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

technology databases

  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.

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions