What is the fastest way of accessing a row in a table?




Answers were Sorted based on User's Feedback



What is the fastest way of accessing a row in a table?..

Answer / ritesh

The fastest way to acces row is by rowid.

Is This Answer Correct ?    33 Yes 2 No

What is the fastest way of accessing a row in a table?..

Answer / rohit

By making index of that row.

Is This Answer Correct ?    14 Yes 7 No

What is the fastest way of accessing a row in a table?..

Answer / vidit tyagi

The fastest way to acces row is by rowid.

Is This Answer Correct ?    7 Yes 2 No




What is the fastest way of accessing a row in a table?..

Answer / maheshg

It's Rowid is the fastest way to access the row.

Is This Answer Correct ?    0 Yes 0 No

What is the fastest way of accessing a row in a table?..

Answer / bhisma

The Fastest way to access a row is to use primary key of
the table.

Is This Answer Correct ?    0 Yes 6 No

Post New Answer



More SQL PLSQL Interview Questions

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,


What is a database trigger ? Name some usages of database trigger ?

4 Answers  


i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,


1. Which is an aggregate function? a. Union b. like c. max d. Rank

1 Answers   Fintellix,


using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,






Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,


How pl/sql source code can be protected?

2 Answers  


can i write pl/sql code in a package

2 Answers  


Can a table have two primary keys?

44 Answers   HCL, MetaCube,


Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

12 Answers   Satyam,


What is nvl function?

4 Answers   Cap Gemini,


I have the table like this S.No Name ID 01 Xyz 123 I want the result as 01Xyz123 How to write the query to retrieve the entire row data in a single column?

1 Answers  






Categories