• 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

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

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
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 physics
550 Quizzes
11687 Questions
 history
1132 Quizzes
13047 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions