解释data block ， extent 和 segment的区别（这里建议用英文术语）
解释data block ， extent 和 segment的区别（这里建议用英文术语）
相关考题：
在数据封装中PDU的正确顺序是()。 A.data，packet，frame，segment，BitB.data，packet，segment，frame，BitC.data，segment，frame，packet，BitD.data，segment，packet，frame，Bit
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
A PC on a network segment sends data to another PC on a different segment.Which of the following correctly describe the correct order of how this data will be encapsulated?() A. Data, Frame, Packet, Segment, BitB. Data, Frame, Segment, Packet, BitC. Data, Packet, Frame, Segment, BitD. Data, Packet, Segment, Frame, BitE. Data, Segment, Frame, Packet, BitF. Data, Segment, Packet, Frame, Bit
oracle逻辑存储结构正确的是（）A、tablespace--segment--osblock--blockB、tablespace--segment--extent--blockC、tablespace--extent--segment--blockD、tablespace--extent--block–segment
Which two statements correctly describe the relation between a data file and the logical databasestructures（）A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
You want the size of the tablespace to increase when it is full. Which option would you use？（）A、use automatic extent allocationB、disable threshold for the tablespaceC、use freelists to manage the free spaceD、use automatic segment space managementE、create the tablespace as a bigfile tablespaceF、use the RESIZE clause while creating the tablespaceG、enable AUTOEXTEND for at least one of the data files in the tablespace
You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. B、Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C、Choose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.
A PC on a network segment sends data to another PC on a different segment.Which of the following correctly describe the correct order of how this data will be encapsulated?（）A、Data, Frame, Packet, Segment, BitB、Data, Frame, Segment, Packet, BitC、Data, Packet, Frame, Segment, BitD、Data, Packet, Segment, Frame, BitE、Data, Segment, Frame, Packet, BitF、Data, Segment, Packet, Frame, Bit
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.
You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）A、set PCTFREE and PCTUSED to 50B、specify extent allocation as UniformC、specify extent allocation as AutomaticD、create the tablespace as bigfile tablespaceE、create the tablespace as smallfile tablespaceF、set segment space management to AutomaticG、use the RESIZE clause while creating the tablespace
The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）A、Choose Tools - Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. B、Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Table', and enter the SELECT statement in the Query Data Source Name property. E、Choose Tools - Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. F、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually. Alter the Query Data Source Type to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
Which two statements about bigfile tablespaces are true？ （）A、The bigfile tablespace have only one data file.B、The segment space management is automatic.C、The extent management is dictionary managed.D、The database can have only one bigfile tablespace.E、The bigfile tablespace can be converted to a smallfile tablespace.
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
Which statements are true about logical structures of the Oracle database（）A、Each segment contains one or more extents.B、Multiple tablespaces can share a single data fileC、A data block is the smallest unit of input/output （I/O） in data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one operating system block
Which two statements are true regarding transactions in an Oracle database（）A、Multiple transactions can use the same undo segment.B、A transaction is assigned an undo segment when it is started.C、More than one transaction cannot share the same extent in the undo tablespace.D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）A、The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.B、DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.C、The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.D、The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.E、The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent
Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）A、Oracle Managed Files are used for this instance.B、The USER_DATA tablespace is managed using FET$/UET$ tables.C、The COMPATIBLE initialization parameter must be 9.0.0 or higher.D、Space within segments in the USER_DATA tablespace is managed with freelists.
Which three statements are true about logical structures of the Oracle database（）A、Each segment contains one or more extents.B、Multiple tablespaces can share a single data file.C、A data block is the smallest unit of input/output （I/O） in data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one operating system block.
单选题You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）AClick the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. CSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. DSelect the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. ELaunch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
单选题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 uniformB Choosing the Segment Space Management option to manualC Setting autoextension on for the data file mentioned for the tablespaceD Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
单选题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.
单选题A PC on a network segment sends data to another PC on a different segment.Which of the following correctly describe the correct order of how this data will be encapsulated?（）AData, Frame, Packet, Segment, BitBData, Frame, Segment, Packet, BitCData, Packet, Frame, Segment, BitDData, Packet, Segment, Frame, BitEData, Segment, Frame, Packet, BitFData, Segment, Packet, Frame, Bit
多选题Which two statements correctly describe the relation between a data file and the logical database structures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks
单选题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
单选题The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）AThe Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.BDBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.CThe Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.DThe Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.EThe Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent