Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Index ?
- 2 Answers
- 6607 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rahul
indexing a table is access stretagy. its a way to sort and
search record in the table. its a faster way of retreving
records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / orawhiz
An Index is an optional structure associated with a table to
have direct access to rows,which can be created to increase the
performance of data retrieval. Index can be created on one
or more columns of a table.
| Is This Answer Correct ? | 2 Yes | 0 No |
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
How to use "in out" parameter properly?
What are the differences between interval year to month and interval day to second?
How to select all columns of all rows from a table in oracle?
How do we switch from init.ora file to asp file?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
How to use in conditions in oracle?
How to connect the oracle server as sysdba?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
How to define Data Block size ?
What is autonomous transaction?
Oracle General 
