Answer Posted / madhu

unique key:
1.unique key will accept more than one null value.
2.whenever u created a unique key, then internally one non-clustered index will be created(one table can have more than one Non-clustered index).
3.one table can have more than one unique key.
Primary key:
1.One table should have one primary key only.
2.primary key will not accept null values.
3.whenever u created a primary key then internally one clustered index will be created(one table can have only one clustered index).

What is database sql?

1058

---

Can we call stored procedure in function?

966

---

what is the command line end user interface - mysql? : Sql dba

987

---

Explain the purpose of %type and %rowtype data types?

939

---

What is the limitation on the block size of pl/sql?

996

---

What is transaction control language (tcl)?

1144

---

How to use distinct and count in sql query? Explain

1035

---

What is difference between left and right outer join?

995

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3059

---

What is the least restrictive isolation level? : Transact sql

1079

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1083

---

What are sql ddl commands?

1101

---

How do you drop a trigger?

997

---

Write a query to find the names of users that begin with "um" in sql?

1006

---

What are the types of variable use in pl sql?

1092

---