Oracle and DB2 Database Utilities Quiz
Covers Oracle database administration topics (control files, tablespaces, RMAN, initialization parameters, backups, and background processes) and DB2 standalone utilities (DSN1 and DSNJ utilities for data management and recovery).
Questions
Which standalone utility is used to Preformat the Active Log
- DSNJU003
- DSNJLOGF
- DSN1LOGP
- DSN1SDMP
Which standalone utility is used to modify the BSDS(BootStrap DataSet)?
- DSNJLOGF
- DSN1CHKR
- DSNJU003
- DSNJ004
Which standalone utility can be used to list System and Utility timestamps, Contents of Quiesce history record, active Log datasets available etc.
- DSN1LOGP
- DSNJU003
- DSNJU004
- DSNJLOGF
Which standalone Utility verifies the Integrity of DB2 directory and Catalog
- DSN1SDMP
- DSN1LOGP
- DSN1COMP
- DSN1CHKR
Which Utility is used to estimate space savings to be achieved by DB2 Data compression in tablespaces?
- DSN1COMP
- DSN1CHKR
- DSN1COPY
- DSN1SDMP
Which standalone utility can be used to move data between subsystems by translating OBID, PSID and DBID?
- DSN1COMP
- DSN1PRNT
- DSN1SDMP
- DSN1COPY
Which standalone utility used to format the contents of the recovery log for display?
- DSNJLOGF
- DSN1LOGP
- DSN1PRNT
- DSN1SDMP
Which standalone utility can be used to identify the contents of a tablespace, index or Image copy datasets?
- DSN1PRNT
- DSN1SDMP
- DSN1LOGP
- DSN1COMP
Which standalone utility trace the events to occur and force a dump to a user defined dataset?
- DSN1PRNT
- DSN1COPY
- DSN1CHKR
- DSN1SDMP
Standalone utilities are also known as
- Online
- Offline
- Private
- Public
When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)
- Perform I/O
- Lock rows that are not data dictionary rows
- Monitor other Oracle processes
- Connect users to the Oracle instance
- Execute SQL statments issued through an application
Which three are the physical structures that constiture the Oracle database ? (Choose Three)
- Control file
- Extent
- Segment
- Data file
- Log file
- Tablespace
Which three features are provided by Oracle Net Services? (Choose three)
- Data encryption
- User authentication
- Transparent data conversion
- Configuration and administration mechanisms
- Support for multiple network transport protocols
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)
- ABORT
- NORMAL
- IMMEDIATE
- TRANSACTIONAL
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)
- TARGET_REDO_BLKS
- FAST_START_IO_TARGET
- LOG_CHECKPOINT_TIMEOUT
- RECOVERY_ESTIMATED_IOS
- LOG_FILE_SIZE_REDO_BLKS
- LOG_CHECKPOINT_INTERVAL
Which two roles or privileges must you have to export tables owned by another user? (Choose two)
- CREATE USER
- CREATE SESSION
- CREATE ANY TABLE
- IMP_FULL_DATABASE
- EXP_FULL_DATABASE
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)
- Oracle Managed Files used for this instance.
- The USER_DATA tablespace in managed using FET$/UET$ tables.
- The COMPATIBLE intialization paramter must be 9.0.0 or higer.
- Space within segments is the USER_DATA tablespace is managed with freelists.
Which two statments regarding the control file and Recover Manager are true ? (Choose two)
- The control file can grow in size.
- The control file can store RMAN scripts.
- CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.
- The RMAN catalog can exist solely in the control file of the target database.