Tag: databases

Questions Related to databases

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