The following select statement has accessed 54 blocks to retrieve 1000 records. What is the Blocks/Row ratio
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Ideal Blocks/Row ratio for selecting data from a table . BLocks=Number of BLocks accessed ROws=Number of ro...
- There are 10 rows in Table A and 0 Rows in table B. Select * from A,B How many rows will be retrieved.
- How many rows can be retrieved using a SELECT INTO statement in an application?
- The table employee contains 20 records. What is the output of the query " Select 8 from Employee"?
- How many records are specified in the SELECT clause?
- What is the limit on the size of a PL/SQL block?
- What is the output of the below query? select rowid from dual
- Which statement selects the odd number of records :