Ideal Blocks/Row ratio for selecting data from a table . BLocks=Number of BLocks accessed ROws=Number of rows retrieved

Keep practicing — related questions

• The following select statement has accessed 54 blocks to retrieve 1000 records. What is the Blocks/Row ratio
• There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
• The max no of columns in a record is usually 80 because way back then people used to use punch cards to inp...
• ____________ involves putting different rows into different tables.
• What is selectivity of an Index
• When you have less that 20 elements in a database table, then which among the below is preferred options.
• The number of rows in a table can be
• ________ is a structure used for quickly accessing the rows of a table using the values of the columns.