网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
db file sequential read等待P3参数的含义是?()
- A、访问的数据块号
- B、访问的文件号
- C、访问的数据块数量
- D、访问的文件名
参考答案
更多 “db file sequential read等待P3参数的含义是?()A、访问的数据块号B、访问的文件号C、访问的数据块数量D、访问的文件名” 相关考题
考题
YoudecidetoenableFlashbackDatabaseinyourOracle10gdatabasesothatfuturerecoverieswilltakelesstimethantraditionalrecoveries.WhichofthefollowingparametersmustbeincludedinyourinitializationparameterfilebeforeenablingFlashbackDatabase?()A.DB_RECOVERY_FILE_DESTonlyB.DB_FLASHBACK_RETENTION_TARGETonlyC.DB_RECOVERY_FILE_DEST_SIZEandDB_RECOVERY_FILE_DESTonlyD.DB_RECOVERY_FILE_DESTandDB_FLASHBACK_RETENTION_TARGETonlyE.DB_RECOVERY_FILE_DEST_SIZE,DB_RECOVERY_FILE_DESTandF.DB_FLASHBACK_RETENTION_TARGET
考题
Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?()
A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n
考题
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.Identify three possible reasons for this.()A. Missing or stale histogram statisticsB. Undersized shared poolC. High clustering factor for the indexesD. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameterE. Oversized buffer cache
考题
下面哪2个参数是flashback databae必须设置的? ()
A. DB_FLASHBACK_RETENTION_TARGETB. DB_RECOVERY_FILE_DESTC. RECOVERY_PARALLELISMD. FLASHBACK_TRANSACTION_QUERYE. DB_RECOVERY_FILE_DEST_SIZE
考题
Oracle数据中,下列哪些等待事件将产生大量的IO?()
A.log file parallel writeB.latch:cache buffers chainsC.db file sequential readD.db file scattered read
考题
File Reader对象使用()方法把图片显示出来A、read As Binary StringB、read As TextC、read As Date URLD、read As Array Buffer
考题
Oracle数据中,下列哪些等待事件将产生大量的IO?()A、log file parallel writeB、latch:cache buffers chainsC、db file sequential readD、db file scattered read
考题
A customer has a file server using RAID-5 with 8KB sequential write operations. How should the disk controller cache be configured for optimal performance and data integrity?()A、Use write-back cache with battery backup enabledB、Use write-through cache with battery backup enabledC、Use read-back cache with battery backup enabledD、Use read-through cache with battery backup enabled
考题
Which of the following statements is mot correct about mirroring?()A、Mirroring, with the write-verify option turned on, can be used to increase performance.B、Mirroring is a better choice that disk-striping, for large sequential-access file system when one is looking for performance.C、Mirroring, with a parallel-scheduling policy, may improve I/O read-operation performance.D、Mirroring, with maximum inter-disk allocation policy, is used to enhance availability.
考题
You decide to enable Flashback Database in your Oracle 10g database so that future recoveries will take less time than traditional recoveries. Which of the following parameters must be included in your initialization parameter file before enabling Flashback Database?()A、 DB_RECOVERY_FILE_DEST onlyB、 DB_FLASHBACK_RETENTION_TARGET onlyC、 DB_RECOVERY_FILE_DEST_SIZE and DB_RECOVERY_FILE_DEST onlyD、 DB_RECOVERY_FILE_DEST and DB_FLASHBACK_RETENTION_TARGET onlyE、 DB_RECOVERY_FILE_DEST_SIZE, DB_RECOVERY_FILE_DEST andF、 DB_FLASHBACK_RETENTION_TARGET
考题
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?()A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery; status of the tablespace in control file will be changed automatically
考题
The page will be posted to the server after one or more image files are selected for upload.You need to ensure that all unuploaded files are saved to the server within one call to a single event handler. What should you do? ()A、Read the HttpRequest.Files property and call the HttpPostedFile.SaveAs method for each file.B、Read the HttpRequest.inputStream property and call the System.Io.File.WriteLines method for each file.C、Read the HttpRequest.inputStream property and call the HttpResponse.WriteLine method for each file.D、Read the HttpRequest.Files property and call the System.Io.File.WriteLines method for each file.
考题
单选题You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?()A
take data files from the read-only tablespace offline before performing a recoveryB
recovery using backup control file is not possible, so restore all the files from the last full database backup, and then open the databaseC
drop the read-only tablespace and re-create the tablespace after recoveryD
perform a recovery; status of the tablespace in control file will be changed automatically
考题
单选题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database?()A
drop and re-create the read-only tablespacesB
rename the read-only data files to their correct file namesC
change the tablespace status from read/write to read-onlyD
re-create the read-only tablespace because it is automatically removed
考题
多选题You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed. Identify three possible reasons for this.()AMissing or stale histogram statisticsBUndersized shared poolCHigh clustering factor for the indexesDHigh value for the DB_FILE_MULTIBLOCK_READ_COUNT parameterEOversized buffer cache
考题
单选题要从文件"file.dat"中读出第10个字节到变量c中,下列哪个方法适合?()A
FileInputStream in=new FileInputStream(file.dat);in.skip(9);intc=in.read()B
FileInputStream in=new FileInputStream(file.dat);in.skip(10);intc=in.read()C
FileInputStream in=new FileInputStream(file.dat);intc=in.read()D
RandomAccessFile in=new RandomAccessFile(file.dat);in.skip(9);intc=in.readByte()
考题
单选题One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file. Which operation do you need to perform after re/x7fcreating the control file and opening the database?()A
drop and recreate the readonly tablespacesB
rename the readonly data files to their correct file namesC
change the tablespace status from read/write to readonlyD
recreate the readonly tablespace because it is automatically removed
考题
多选题Oracle数据中,下列哪些等待事件将产生大量的IO?()Alog file parallel writeBlatch:cache buffers chainsCdb file sequential readDdb file scattered read
考题
单选题在oracle数据库中,db file sequential read等待P2参数的含义是?()A
访问的文件名B
访问的文件号C
文件拥有者D
访问的数据块号
热门标签
最新试卷