在oracle数据库中，db file sequential read等待P2参数的含义是？（）A、访问的文件名B、访问的文件号C、文件拥有者D、访问的数据块号
在oracle数据库中，db file sequential read等待P2参数的含义是？（）
- A、访问的文件名
- B、访问的文件号
- C、文件拥有者
- D、访问的数据块号
相关考题：
Viewthisparametersettinginyourdatabase：DB_CREATE_FILE_DEST=’D：\oracle\product\10.2.0\oradata\oracle’Youcreatedatablespacebyusingthiscommand：CREATETABLESPACEUSERS；WhichtwostatementsaretrueabouttheUSERStablespace？（）A.Thetablespacehastwodatafiles.B.Anerrorisreportedandtablespacecreationfails.C.Datafilesarecreatedwithnamesgeneratedbytheinstance.D.Thetablespacecanbeextendedwithoutspecifyingthedatafile.E.DatafilesbelongingtotheUSERStablespacecannotberenamed.
ThedatabaseisrunninginARCHIVELOGmode.Examinetheinitializationparametersandtheirvaluessettoenablearchivingonyourdatabaseserver：LOG_ARCHIVE_FORMAT=arch_%t_%s_%r.arcLOG_ARCHIVE_DEST_1=’LOCATION=/disk1/archive’DB_RECOVERY_FILE_DEST=’/u01/oradata’DB_RECOVERY_FILE_DEST_SIZE=20GWhichstatementistrueregardingthearchivedredologfiles（）A.Itwillbecreatedonthelocalfilesystem.B.ItwillbecreatedonlyintheFlashRecoveryArea.C.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandthedefaultlocation$ORACLE_HOME/dbs.D.ItwillbecreatedinthelocationspecifiedbytheLOG_ARCHIVE_DEST_1parameterandlocationspecifiedbytheDB_RECOVERY_FILE_DESTparameter.
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
oracle版112的后台数据库名为db112,oracle数据库的实例名为WG73,oracle客户端的配置文件中的连接名为ora－112,在112cfg.ini中[ora112]下有“ServerName=”一项,其配置应为:() A.Db112B.@db112C.WG73D.@WG73E.Ora-112F.@ora-112
Oracle数据中,下列哪些等待事件将产生大量的IO?() A.log file parallel writeB.latch：cache buffers chainsC.db file sequential readD.db file scattered read
Oracle数据中，下列哪些等待事件将产生大量的IO？（）A、log file parallel writeB、latch：cache buffers chainsC、db file sequential readD、db file scattered read
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 issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）A、DB_CREATE_FILE_DEST B、DB_CREATE_ONLINE_LOG_1 C、DB_CREATE_ONLINE_LOG_2D、The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A The archived redo logs are stored in an operating system-dependent location.B The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
单选题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 are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）A One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
单选题oracle版112的后台数据库名为db112，oracle数据库的实例名为WG73，oracle客户端的配置文件中的连接名为ora-112，在112cfg.ini中[ora112]下有“ServerName=”一项，其配置应为：（）ADb112B@db112CWG73D@WG73EOra-112F@ora-112
多选题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
多选题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访问的数据块号