how many types of index?
Answers were Sorted based on User's Feedback
Answer / manasa
Bit Map
B-tree index
Function based index
concatenated index
| Is This Answer Correct ? | 11 Yes | 1 No |
Briefly explain what is literal? Give an example where it can be used?
How to define an oracle cursor variable?
What privilege is needed for a user to query tables in another schema?
Can group functions be mixed with non-group selection fields?
difference between procedures and function?
Explain the use of compress option in exp command.
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
how to truncate date and get only time part 9:20:00
You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?
What is mean by Program Global Area (PGA) ?
how do u setup a replication site?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here