多选题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 slots are required than are initially configured
多选题
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
参考解析
解析：
暂无解析
相关考题：
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) = SoapdtProducts.Rows(1)(ProductName) = BookdtProducts.Rows(2)(ProductName) = ComputerdtProducts.Rows(3)(ProductName) = SpoondtProducts.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
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
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.
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
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.
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
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.
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.
Identify two situations in which the block header grows in a data block. （）A、when row directories need more row entriesB、when there is row migration in the data blockC、when there is an increase in the PCTFREE value for the data blockD、when more transaction slots are required than are initially configured
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.
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.
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.
Which four are attributes of single row functions? （）A、cannot be nestedB、manipulate data itemsC、act on each row returnedD、return one result per rowE、accept only one argument and return only one valueF、accept arguments which can be a column or an expression
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、LoadViewStateByIDB、UniqueIDC、ClientIDModeD、ClientIDRowSuffix
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.
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
多选题Identify three situations in which you would NOT be able to drop a tablespace. （）Awhen the tablespace is onlineBwhen the tablespace has segments with data in itCwhen the tablespace is a default permanent tablespace for the databaseDwhen the tablespace contains a table that is currently being used by transactionsEwhen the tablespace contains undo data that is needed to rollback an uncommitted transaction
单选题Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）AAn update in a leaf row takes place.BThe index becomes invalid after the update.CThe leaf block containing the row to be updated is marked as invalid.DA row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
单选题Which of the following best describes how locks are used in DB2?（）ATo maintain control of updated rows for commit processingBTo ensure only committed changes are altered by another applicationCTo allow two applications to update the same row of data simultaneouslyDTo prevent multiple applications from accessing the same data simultaneously
多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block.
多选题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?（）AThe LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300. LAST_SCNBThe LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.CThe LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.DThe 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
多选题Which two statements about subqueries are true? （）AA single row subquery can retrieve data from only one table.BA 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.CA SQL query statement can display data from table B that is referred to in its subquery, without including B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in an INSERT statement to insert multiple rows at a time.
多选题Which two statements are correct regarding the Flashback Versions Query feature？（）AYou can use this feature to identify the committed versions of the rows， but not the uncommitted versions.BYou can use this feature to identify the versions of V$ views.CYou 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.DYou can use this feature for a table only if row movement is enabled for the table.EYou can use this feature to identify the versions of external and fixed tables.
多选题Which four are attributes of single row functions? （）Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression
多选题Which two statements are true regarding single row functions?（）AThey accept only a single argumentBThey can be nested only to two levelsCArguments can only be column values or constantsDThey always return a single result row for every row of a queried tableEThey can return a data type value different from the one that is referenced
多选题Which three statements are true regarding single-row functions？（）AThey can accept only one argument.BThey can be nested up to only two levels.CThey can return multiple values of more than one data type.DThey can be used in SELECT， WHERE， and ORDER BY clauses.EThey can modify the data type of the argument that is referenced.FThey can accept a column name， expression， variable name， or a user-supplied constant as arguments.
多选题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?（）AUse NTFS file system compression on the volume.BUse row-level compression on the document table.CUse varbinary(MAX) data type with FILESTREAM storage.DEnable row-level compression on all columns that use the vardecimal() data type.