Answer Posted / samar singh
Index by tables are composed of two components
1)primary key of binary_interger
2)column of scalar or record type
and used for increasing the size dynamically.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write a query to display the current date in sql?
What is lookup table in sql?
What is pl sql collection?
How can you fetch common records from two tables?
How do you know if a relationship is 2nf?
Can we use views in stored procedure?
What is the main reason behind using an index?
what are all types of user defined functions? : Sql dba
Difference between table function and pipelined function?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
How to get unique records from a table?
how to rename an existing column in a table? : Sql dba
What is the difference between numeric and autonumber?
What are different types of keys?
What is cursor in pl sql?