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 |
What is diff between bulk collect and forall
What is pragma exception and how, when, where us
Is left join faster than inner join?
Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.
Why does sql need a server?
Name the tables where characteristics of Package, procedure and functions are stored ?
What operators deal with null?
Explain the steps needed to create the scheduled job?
what are wild cards used in database for pattern matching ? : Sql dba
What is a database? Explain
Is full outer join same as cross join?
What is difference between ms sql and mysql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)