Can you create a table with Primary Key not as the clustered
index.
Answers were Sorted based on User's Feedback
Answer / guest
Yes you can create a table with the clustered index on any
column. This must be done at the time of creation of the
table.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / nrapendra singh
function overloadding is allowed in pl sql .we can creete
multiple sp of same name but paramerter should be different.
Is This Answer Correct ? | 4 Yes | 2 No |
While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?
What is inner join in sql?
Can we call procedure in select statement?
What does count (*) do in sql?
Why use subqueries instead of joins?
What are synonyms in sql?
what is error ora-03113: end-of-file on communication channel?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
How many clustered indexes can be created on a table?
Why is %isopen always false for an implicit cursor?
What is a call statement? Explain with an example.
Can we alter stored procedure?