单选题What is the maximum database block size supported for the Oracle9i database？（）A 16KBB 32KBC 64KBD 128KB

题目
单选题
What is the maximum database block size supported for the Oracle9i database？（）
A

16KB

B

32KB

C

64KB

D

128KB

相似考题

1.在信道编码中，码块分段时最大的码块大小为Z的值为『____』。(In channel coding,Maximum code block size Z-value is『____』.)

2.The network administrator needs to address seven LANs. RIP version 1 is the only routing protocol in use on the network and subnet 0 is not being used. What is the maximum number of usable IP addresses that can be supported on each LAN if the organization is using one class C address block?（）A.8B.6C.30D.32E.14F.16

3.What is the maximum number of agents supported for CCM co-resident installations?（）A、5  B、10  C、15  D、20

4.What is the maximum size that can be specified when creating an XML column in a DB2 table?()A.No size is specifiedB.The buffer pool sizeC.The page size for the table spaceD.The extent size for the table space

更多“What is the maximum database block size supported for the Or”相关问题

  • 第1题：

    A competitor informed a customer that blades were not suitable to implement robust virtual computing infrastructures due to memory limitations.  What is the maximum memory supported by an IBM Intel Blade using what size memory DIMMs？ （）

    • A、16GB using 4GB Memory DIMMs
    • B、8GB using 2GB Memory DIMMs
    • C、32GB using 4GB Memory DIMMs
    • D、16GB using 2GB Memory DIMMs

    正确答案:C

  • 第2题：

    What is the maximum number of NET addresses supported on a virtual router?（）

    • A、0
    • B、1
    • C、2
    • D、3

    正确答案:D

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    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 number
    • B、 the locations of the redo log files
    • C、 the locations of the datafiles
    • D、 the physical location of all the database changes

    正确答案:D

  • 第5题：

    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 only
    • B、 DB_8K_CACHE_SIZE only
    • C、 DB_BLOCK_SIZE and DB_4K_CACHE_SIZE
    • D、 DB_BLOCK_SIZE and DB_8K_CACHE_SIZE
    • E、 SGA_TARGET and DB_4K_CACHE_SIZE
    • F、 DB_CACHE_SIZE only

    正确答案:A

  • 第6题：

    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.

    正确答案:D

  • 第7题：

    单选题
    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 only

    B

     DB_8K_CACHE_SIZE only

    C

     DB_BLOCK_SIZE and DB_4K_CACHE_SIZE

    D

     DB_BLOCK_SIZE and DB_8K_CACHE_SIZE

    E

     SGA_TARGET and DB_4K_CACHE_SIZE

    F

     DB_CACHE_SIZE only


    正确答案： F
    解析： 暂无解析

  • 第8题：

    单选题
    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 KB

    D

     The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    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（）
    A

    Because 4194304 is the granule size

    B

    Because 4194304 is the standard block size

    C

    Because 4194304 is the largest nonstandard block size defined in the database

    D

    Because 4194304 is the total size of data already available in the database buffer cache


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    What is the maximum number of drives supported in a three-frame IBM DS8800?（）
    A

     960 

    B

     1056 

    C

     1190 

    D

     1210


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    What is the maximum number of NET addresses supported on a virtual router?（）
    A

    0

    B

    1

    C

    2

    D

    3


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    The network administrator needs to address seven LANs. RIP version 1 is the only routing protocol in use on the network and subnet 0 is not being used. What is the maximum number of usable IP addresses that can be supported on each LAN if the organization is using one class C address block?（）
    A

    8

    B

    6

    C

    30

    D

    32

    E

    14

    F

    16


    正确答案： D
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:A

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    What is the maximum database block size supported for the Oracle9i database？（）

    • A、16KB
    • B、32KB
    • C、64KB
    • D、128KB

    正确答案:B

  • 第16题：

    What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?（）

    • A、100KB default, 10TB maximum
    • B、256KB default, 1024MB maximum
    • C、10MB default, 126PB maximum
    • D、64KB default, 1EB maximum
    • E、1MB default, 64MB maximum

    正确答案:E

  • 第17题：

    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 KB
    • D、 The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.

    正确答案:D

  • 第18题：

    What is the maximum size that can be specified when creating an XML column in a DB2 table?（）

    • A、No size is specified
    • B、The buffer pool size
    • C、The page size for the table space
    • D、The extent size for the table space

    正确答案:A

  • 第19题：

    单选题
    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（）
    A

    Because 4194304 is the granule size

    B

    Because 4194304 is the standard block size

    C

    Because 4194304 is the largest nonstandard block size defined in the database

    D

    Because 4194304 is the total size of data already available in the database buffer cache


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    View the Exhibit. You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.  Which configuration couldhave enabled the block selection of 16 KB（）
    A

    Choosing the extent allocation type to uniform

    B

    Choosing the Segment Space Management option to manual

    C

    Setting autoextension on for the data file mentioned for the tablespace

    D

    Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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 size

    B

    because 4194304 is the standard block size

    C

    because 4194304 is the largest nonstandard block size defined in the database

    D

    because 4194304 is the total size of data already available in the database buffer cache


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    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 mb

    C

    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


    正确答案： D
    解析： 暂无解析

  • 第23题：

    多选题
    What are the three steps you should take to tune a JDBC Connection pool in WebLogic from the  initial settings in a production environment?（）
    A

    Ensure the maximum size is increased to an appropriate setting.

    B

    Set the minimum and maximum size of the connection pool to the same value.

    C

    Increase the statement cache size.

    D

    Add more heap to the JVM.

    E

    Add more nodes to the cluster.


    正确答案： B,D
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

相关内容