1211] - Read-Only - Word O Search References Mailings Review View Help 20 - Hash index entries are assigned to. a) Values b) Clusters c) Buckets d) Blocks 21 - what are the index of an efficient...

Extracted text: 1211] - Read-Only - Word O Search References Mailings Review View Help 20 - Hash index entries are assigned to. a) Values b) Clusters c) Buckets d) Blocks 21 - what are the index of an efficient bitmaps index? a) Each bucket has initially one block. Any additional blocks are allocated and linked to an initial block b) The WHERE clause may specify any values in upper ways. The column used in a WHERE clause may contain mixed upper- and lower-case characters. c) The database can quickly determine the block containing a table row from the index row mumber. Any indexed column relatively few distinct values. d) Indexes change only when primary key values are updated. physical indexes change whenever a row moves to a new block. 22 - A column contains grades from 0 to 10, but uh where clause specifies values from 0 to 100. A. index can be used to modify the column values and process the queries. a) Multi - level b) logical c) single - level d) function 23 - In logical index, pointers to table blocks are you pleased with values. a) foreign key b) primary key c) artificial key d) composite key DFocus 少 ** PrtSc Insert FO F10 % & 4 7. 8 9 Y K ..


Extracted text: Quiz[1211] - Read-Only - Word Layout References Mailings Review View Help 24 - What object Maps one or more tables to a single file? a) Vertical partition b) horizontal partition table c) table space d) Shard 25 - a subset of table rows is called a a) Cluster b) fragment c) vertical partition d) horizontal partition 26 - how does a list partition assign rows to partition? a) I return value from a partition expression that uses VALUES IN b) a specified number of partitions assigned with a positive integer values. c) I return value from partition expression that specifies MAX VALUES d) a value that is determined automatically by the database. 27 - When a table is assigned to a table space where is the index stored? a) In an adjacent table space b) in the same tablespace as the table c) within the table d) in the separate tablespace file *- F11 FS F8 F9 F10 F12 24 * 4 5 8 R Y