What is nvarchar max in sql?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

What is the difference between cross join and natural join?

0 Answers  

---

Is truncate ddl or dml?

0 Answers  

---

what is the use of HASH, LIST partitions?

1 Answers   ITC Infotech,

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

Does inner join return duplicate rows?

0 Answers  

---

Does sql*plus also have a pl/sql engine?

0 Answers  

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

Explain ttitle and btitle.

0 Answers  

---

How to change the order of columns in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

Is a table valued function object?

0 Answers  

---