Answer Posted / murali krishna penke

we can create more than one primary key in a table. the
maximum allowed to create primary keys for columns is 16,
but we call it primary key for one column only and the
remaining we call it as composite primary key..

create table TestPrimaryKey(ID int,Name nvarchar(50),Email
nvarchar(50),Phone nvarchar(12),cellphone nvarchar
(10),primary key(ID,Name,Email,Phone,cellphone))

the above table creates primary key for all above mentioned
columns.

What is indexing in sql and its types?

1003

---

What is rownum and rowid?

982

---

What is the maximum size of sqlite database?

1039

---

How do you know if a relationship is 2nf?

877

---

Can we insert data into materialized view?

896

---

what is bcp? When is it used?

1046

---

What is the need of a partition key?

940

---

What is procedure explain with example?

894

---

What are the advantages of indexing?

926

---

How can we debug in PL/SQL?

1090

---

What is acid property in a database?

973

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1042

---

What is memory optimized?

1008

---

Could you please provide oca (oracle 10g) dumps for my certification ?

5070

---

Which sql statement is used to return only different values?

952

---