多选题Identify two situations in which the block header grows in a data block. （）Awhen row directories need more row entriesBwhen there is row migration in the data blockCwhen there is an increase in the PCTFREE value for the data blockDwhen more transaction

题目
多选题
Identify two situations in which the block header grows in a data block. （）
A

when row directories need more row entries

B

when there is row migration in the data block

C

when there is an increase in the PCTFREE value for the data block

D

when more transaction slots are required than are initially configured

相似考题

1.You are creating a Web Form. The Web Form allows users to rename or delete products in a list. You create a DataTable named dtProducts that is bound to a GridView. DataTable has the following four rows. dtProducts.Rows(0)("ProductName") = "Soap"dtProducts.Rows(1)("ProductName") = "Book"dtProducts.Rows(2)("ProductName") = "Computer"dtProducts.Rows(3)("ProductName") = "Spoon"dtProducts.AcceptChanges()The user utilizes a Web Form to delete the first product. You need to set the RowStateFilter property of the DataTables DefaultView so that only products that have not been deleted are shown. To which value should you set the DataTabless DefaultView.RowStateFilter?（）A. Data View Row State.Modified OriginalB. Data View Row State.Modified CurrentC. Data View Row State.Current RowsD. Data View Row State.Added

2.Which of the following is the definition of CAS latency？（）A、 CAS latency is the ratio between the column access time and the clock cycle time.B、 CAS latency is the ratio between the row access time and the clock cycle time.C、 CAS latency is the ratio between the column access time and the data burst transfer time.D、 CAS latency is the ratio between the row access time and the data burst transfer time.

3.Which of the following best describes how locks are used in DB2?（）A、To maintain control of updated rows for commit processingB、To ensure only committed changes are altered by another applicationC、To allow two applications to update the same row of data simultaneouslyD、To prevent multiple applications from accessing the same data simultaneously

4.The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.Which two statements about the results of the query shown in the Exhibit are correct?（）A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCNB. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN

更多“多选题Identify two situations in which the block header grows in a data block. （）Awhen row directories need more row entriesBwhen there is row migration in the data blockCwhen there is an increase in the PCTFREE value for the data blockDwhen more transaction”相关问题

  • 第1题：

    Which two statements are correct regarding the Flashback Versions Query feature？（）

    • A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.
    • B、 You can use this feature to identify the versions of V$ views.
    • C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.
    • D、 You can use this feature for a table only if row movement is enabled for the table.
    • E、 You can use this feature to identify the versions of external and fixed tables.

    正确答案:A,C

  • 第2题：

    Which two statements about subqueries are true?（）

    • A、A single row subquery can retrieve data from only one table.
    • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
    • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
    • D、A single row subquery can retrieve data from more than one table.
    • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
    • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    正确答案:B,D

  • 第3题：

    Identify two situations in which the block header grows in a data block. （）

    • A、when row directories need more row entries
    • B、when there is row migration in the data block
    • C、when there is an increase in the PCTFREE value for the data block
    • D、when more transaction slots are required than are initially configured

    正确答案:A,D

  • 第4题：

    Which three statements are true regarding the logical structure of the Oracle database？（）

    • A、Each segment contains one or more extents.
    • B、Multiple tablespaces can share single data file.
    • C、A data block is the smallest unit of I/O for 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 OS block.

    正确答案:A,C,D

  • 第5题：

    Which four are attributes of single row functions? （）

    • A、cannot be nested
    • B、manipulate data items
    • C、act on each row returned
    • D、return one result per row
    • E、accept only one argument and return only one value
    • F、accept arguments which can be a column or an expression

    正确答案:B,C,D,F

  • 第6题：

    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）

    • A、Use NTFS file system compression on the volume.
    • B、Use row-level compression on the document table.
    • C、Use varbinary(MAX) data type with FILESTREAM storage.
    • D、Enable row-level compression on all columns that use the vardecimal() data type.

    正确答案:A,C

  • 第7题：

    多选题
    Identify three situations in which you would NOT be able to drop a tablespace. （）
    A

    when the tablespace is online

    B

    when the tablespace has segments with data in it

    C

    when the tablespace is a default permanent tablespace for the database

    D

    when the tablespace contains a table that is currently being used by transactions

    E

    when the tablespace contains undo data that is needed to rollback an uncommitted transaction


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

  • 第8题：

    单选题
    Which of the following best describes how locks are used in DB2?（）
    A

    To maintain control of updated rows for commit processing

    B

    To ensure only committed changes are altered by another application

    C

    To allow two applications to update the same row of data simultaneously

    D

    To prevent multiple applications from accessing the same data simultaneously


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

  • 第9题：

    多选题
    The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs. View the Exhibit. Which two statements about the results of the query shown in the Exhibit are correct?（）
    A

    The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCN

    B

    The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.

    C

    The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.

    D

    The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted. LAST_SCN


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

  • 第10题：

    多选题
    Which two statements are correct regarding the Flashback Versions Query feature？（）
    A

    You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.

    B

    You can use this feature to identify the versions of V$ views.

    C

    You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.

    D

    You can use this feature for a table only if row movement is enabled for the table.

    E

    You can use this feature to identify the versions of external and fixed tables.


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

  • 第11题：

    多选题
    Which two statements are true regarding single row functions?（）
    A

    They accept only a single argument

    B

    They can be nested only to two levels

    C

    Arguments can only be column values or constants

    D

    They always return a single result row for every row of a queried table

    E

    They can return a data type value different from the one that is referenced


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

  • 第12题：

    多选题
    You administer a SQL Server 2008 instance. You deploy a new database named Engineering. The Engineering database manages large documents that will be revised occasionally. You need to design a table structure that allows fast read access. You also need to minimize storage space requirements.  Which two actions should you perform?（）
    A

    Use NTFS file system compression on the volume.

    B

    Use row-level compression on the document table.

    C

    Use varbinary(MAX) data type with FILESTREAM storage.

    D

    Enable row-level compression on all columns that use the vardecimal() data type.


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

  • 第13题：

    Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）

    • A、An update in a leaf row takes place.
    • B、The index becomes invalid after the update.
    • C、The leaf block containing the row to be updated is marked as invalid.
    • D、A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted

    正确答案:D

  • 第14题：

    Which statement describes the ROWID data type? （）

    • A、Binary data up to 4 gigabytes.
    • B、Character data up to 4 gigabytes.
    • C、Raw binary data of variable length up to 2 gigabytes.
    • D、Binary data stored in an external file, up to 4 gigabytes.
    • E、A hexadecimal string representing the unique address of a row in its table.

    正确答案:E

  • 第15题：

    Which three statements are true regarding single-row functions？（）

    • A、 They can accept only one argument.
    • B、 They can be nested up to only two levels.
    • C、 They can return multiple values of more than one data type.
    • D、 They can be used in SELECT， WHERE， and ORDER BY clauses.  
    • E、 They can modify the data type of the argument that is referenced.
    • F、 They can accept a column name， expression， variable name， or a user-supplied constant as arguments.

    正确答案:D,E,F

  • 第16题：

    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.

    正确答案:A,C,D

  • 第17题：

    Which property of the ListView class is used to get/set the name of the data field whose value exclusively identifes every data row of a ListView when the ClientIDMode property is set to Predictable？（）

    • A、LoadViewStateByID
    • B、UniqueID
    • C、ClientIDMode
    • D、ClientIDRowSuffix

    正确答案:D

  • 第18题：

    Which two statements are true regarding single row functions?（）

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第19题：

    单选题
    Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）
    A

    An update in a leaf row takes place.

    B

    The index becomes invalid after the update.

    C

    The leaf block containing the row to be updated is marked as invalid.

    D

    A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted


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

  • 第20题：

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


    正确答案： A,C,D
    解析： A答案：每个段包含一个或多个区，正确。 
    B答案：一个数据文件只能属于一个表空间，故错误。 
    C答案：Oracle data block是最小的I/O单位，正确 
    D答案：可以是不同的块大小，需要指名非标准块的位置。 
    E答案：每个数据库里面的数据库对应一个或多个操作系统块，故E错误。

  • 第21题：

    多选题
    Which two statements about subqueries are true? （）
    A

    A single row subquery can retrieve data from only one table.

    B

    A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.

    C

    A SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.

    D

    A single row subquery can retrieve data from more than one table.

    E

    A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.

    F

    A multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.


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

  • 第22题：

    多选题
    Which four are attributes of single row functions? （）
    A

    cannot be nested

    B

    manipulate data items

    C

    act on each row returned

    D

    return one result per row

    E

    accept only one argument and return only one value

    F

    accept arguments which can be a column or an expression


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

  • 第23题：

    多选题
    Which three statements are true regarding single-row functions？（）
    A

    They can accept only one argument.

    B

    They can be nested up to only two levels.

    C

    They can return multiple values of more than one data type.

    D

    They can be used in SELECT， WHERE， and ORDER BY clauses.

    E

    They can modify the data type of the argument that is referenced.

    F

    They can accept a column name， expression， variable name， or a user-supplied constant as arguments.


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

相关内容