单选题What is the maximum database block size supported for the Oracle9i database？（）A16KBB32KBC64KBD128KB
单选题
What is the maximum database block size supported for the Oracle9i database？（）
A
16KB
B
32KB
C
64KB
D
128KB
参考解析
解析：
暂无解析
相关考题：
A specialist is monitoring performance on a server. The data is on another partition within the same array as the OS. The following information is available： （1）The average record written to disk is 16KB （2）The I/O block size is 2KB （3）The stripe size on the RAID array is 16KB Which of the following will improve performance without rebuilding the operating system？（）A、Change the I/O block size to match the RAID Stripe size.B、Change the RAID stripe size to match the I/O block size.C、Change the record size of the database to match the RAID stripe size.D、Change the record size of the database to match the I/O transfer rate.
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A、 The Oracle database will not perform block checking for any of the data blocks.B、 The Oracle database will perform block checking for the default permanent tablespace only. C、 The Oracle database will perform block checking for the data blocks in all user tablespaces.D、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E、 The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（） A、 The block change tracking feature must be enabled.B、 OMF must be configured on your database.C、 The database must be in ARCHIVELOG mode.D、 A USERID must be supplied.
Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）A、The minimum memory size for the database buffer cache is set to 100 mb.B、The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbC、The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.D、The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（） A、 The Oracle database will perform block checking for the index blocks onlyB、 The Oracle database will not perform block checking for any of the data blocksC、 The Oracle database will perform block checking for the default permanent tablespace onlyD、 The Oracle database will perform block checking for the data blocks in all user tablespacesE、 The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
What is the maximum database block size supported for the Oracle9i database？（）A、16KBB、32KBC、64KBD、128KB
You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A、 the system change numberB、 the locations of the redo log filesC、 the locations of the datafilesD、 the physical location of all the database changes
The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）A、 DB_4K_CACHE_SIZE onlyB、 DB_8K_CACHE_SIZE onlyC、 DB_BLOCK_SIZE and DB_4K_CACHE_SIZED、 DB_BLOCK_SIZE and DB_8K_CACHE_SIZEE、 SGA_TARGET and DB_4K_CACHE_SIZEF、 DB_CACHE_SIZE only
Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A、 The parameter DB_CACHE_SIZE must be a multiple of 8.B、 The value of the parameter SGA_MAX_SIZE must be increased.C、 The tablespace must be created with a uniform extent size of 8 KBD、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command： SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 （4M） Why is the value set to 4194304 and not to 2516582（）A、because 4194304 is the granule sizeB、because 4194304 is the standard block sizeC、because 4194304 is the largest nonstandard block size defined in the databaseD、because 4194304 is the total size of data already available in the database buffer cache
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（） A、 Use a Dynamic Management View to check for locks.B、 Use a Dynamic Management View to check for blocked queries.C、 Use a Dynamic Management View to check for long-running queries.D、 Use a Dynamic Management View to check the size and maximum size of the database.
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command： SQL SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 （4M） Why is the value set to 4194304 and not to 2516582（）Abecause 4194304 is the granule sizeBbecause 4194304 is the standard block sizeCbecause 4194304 is the largest nonstandard block size defined in the databaseDbecause 4194304 is the total size of data already available in the database buffer cache
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）ABecause 4194304 is the granule sizeBBecause 4194304 is the standard block sizeCBecause 4194304 is the largest nonstandard block size defined in the databaseDBecause 4194304 is the total size of data already available in the database buffer cache
单选题You have configured OMF in your database. You enabled the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING； statement to enable the block change tracking feature. What information will be written in the change tracking file？（）A the system change numberB the locations of the redo log filesC the locations of the datafilesD the physical location of all the database changes
单选题What is a key new feature in Tivoli Storage Manager Version 6 that allows for a larger sizeddatabase?（）A DB2 is the underlying database manager B Data is compressed without any change to the database C SSD drives are now required allowing for faster database access D Deduplication within the database shrinks the size of the current database
单选题You have executed this command to change the size of the database buffer cache： SQL ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered. To verify the change in size， you executed this command：SQL SHOW PARAMETER DB_CACHE_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 Why is the value set to 4194304 and not to 2516582（）ABecause 4194304 is the granule sizeBBecause 4194304 is the standard block sizeCBecause 4194304 is the largest nonstandard block size defined in the databaseDBecause 4194304 is the total size of data already available in the database buffer cache
单选题The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）A DB_4K_CACHE_SIZE onlyB DB_8K_CACHE_SIZE onlyC DB_BLOCK_SIZE and DB_4K_CACHE_SIZED DB_BLOCK_SIZE and DB_8K_CACHE_SIZEE SGA_TARGET and DB_4K_CACHE_SIZEF DB_CACHE_SIZE only
单选题The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）A The Oracle database will not perform block checking for any of the data blocks.B The Oracle database will perform block checking for the default permanent tablespace only. C The Oracle database will perform block checking for the data blocks in all user tablespaces.D The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.E The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
单选题Automatic Shared Memory Management （ASMM） has been enabled for your database instance. Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL ALTER SYSTEM SET DB_CACHE_SIZE = 100M； Which statement is true in this scenario（）AThe minimum memory size for the database buffer cache is set to 100 mb.BThe maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mbCThe minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.DThe maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
单选题The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility. What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）A The block change tracking feature must be enabled.B OMF must be configured on your database.C The database must be in ARCHIVELOG mode.D A USERID must be supplied.
单选题What is the maximum database block size supported for the Oracle9i database？（）A16KBB32KBC64KBD128KB
单选题A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）A Use a Dynamic Management View to check for locks.B Use a Dynamic Management View to check for blocked queries.C Use a Dynamic Management View to check for long-running queries.D Use a Dynamic Management View to check the size and maximum size of the database.
单选题Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）A The parameter DB_CACHE_SIZE must be a multiple of 8.B The value of the parameter SGA_MAX_SIZE must be increased.C The tablespace must be created with a uniform extent size of 8 KBD The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
单选题A specialist is monitoring performance on a server. The data is on another partition within the same array as the OS. The following information is available： （1）The average record written to disk is 16KB （2）The I/O block size is 2KB （3）The stripe size on the RAID array is 16KB Which of the following will improve performance without rebuilding the operating system？（）AChange the I/O block size to match the RAID Stripe size.BChange the RAID stripe size to match the I/O block size.CChange the record size of the database to match the RAID stripe size.DChange the record size of the database to match the I/O transfer rate.
单选题The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）A The Oracle database will perform block checking for the index blocks onlyB The Oracle database will not perform block checking for any of the data blocksC The Oracle database will perform block checking for the default permanent tablespace onlyD The Oracle database will perform block checking for the data blocks in all user tablespacesE The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only