1z0-043
多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting？（）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIME
题目
DATE
TIMESTAMP
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
TIMESTAMP WITH LOCAL TIME ZONE
相似问题和答案
第1题：
You have the following requirements in relation to the detection of block corruption for your database instance:1. Check for logical self-consistency of data blocks when modified in memory.2. Checksums are calculated before and after the block change.3. Checks are performed for the lost writes to the physical standby database.Which method would help you perform the above checks automatically? （）
A. Set the DB_SECUREFILE parameter to PERMITTED
B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY
C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL
D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
第2题：
In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）
- A、the alert log file
- B、the core dump files
- C、the change tracking file
- D、the user session trace files
- E、the database audit trail files
- F、the background process trace files
正确答案:A,F
第3题：
A. Setting the FAST_START_MTTR_TARGET to set the mean time to recover
B. Setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C. Using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D. Using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area
第4题：
Which two file types must be included in a closed database backup taken with operating system commands？（）
- A、data files
- B、control file
- C、password file
- D、online redo log files
- E、initialization parameter file
正确答案:A,B
第5题：
You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）
- A、 The database will not start.
- B、 The database will start but will not retain the undo data in the undo segment.
- C、 The database will start， and the undo segment will contain the undo data for at least one hour.
- D、 The database will start， and the undo segment will retain the undo data for at least 15 minutes.
正确答案:D
第6题：
A.120M
B.320M
C.480M
D.600M
第7题：
You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）
- A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.
- B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.
- C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.
- D、 Increase the value of the SGA_TARGET initialization parameter.
正确答案:B
第8题：
A. Set MEMORY_TARGET to zero
B. Set the STATISTICS_LEVEL parameter to BASIC
C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
第9题：
You are maintaining your production database in Oracle10g. You want the circular reuse records in the control file of the target database to be reused as required. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter？（）
- A、 0
- B、 1
- C、 NONE
- D、 DEFAULT
正确答案:A
第10题：
You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?（）
- A、Set MEMORY_TARGET to zero
- B、Set the STATISTICS_LEVEL parameter to BASIC
- C、Set the WORKAREA_SIZE_POLICY parameter to MANUAL
- D、Set the PGA_AGGREGATE_TARGET parameter to nonzero value
正确答案:D