Answer Posted / sweety singh

superkey is a set of attributes that can uniquely identify
individual tuples whereas a key or a primary key is a
minimal super key that can identify individual tuples.
ex..eno pno hrs
1 1 2
2 4 7

i.e...here eno,pno,hrs together are a superkey but eno,pno
is primary key and hence eno,pno cant hav null values and
repeated enteries....

What is oracle update statement with inner join ?

1067

---

What is the difference between a primary key & a unique key?

1092

---

how to handle exceptions in post production

1433

---

What happens in oracle commit?

1033

---

Can we store pictures in the database and if so, how it can be done?

1047

---

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1994

---

What happens to the current transaction if the session is killed?

991

---

What is meant by joins? List out the types of joins.

1033

---

What is the max number of columns in an oracle table?

1001

---

How to create a new table by selecting rows from another table?

1103

---

What are the numeric comparison operations?

1121

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2034

---

Can select statements be used on views in oracle?

1029

---

How to invoke the original export import utilities?

1069

---

How to revoke create session privilege from a user in oracle?

1020

---