Answer Posted / satish reddy

Each table can have only one primary key; however, that key may consist of more than one column.

SQL> create table EMP(EMPNO Number(5),EMPNAME Varchar2(10),ADDRESS Varchar2(10),Constraint Multi_Constr
aint Primary Key(EMPNO,EMPNAME));

After creating table try to insert null value into EMPNAME Column, it will throw an error "cannot insert NULL into ("SCOTT"."EMP"."EMPNAME")"

What is the use of partition by in sql?

976

---

What are the parts of a basic sql query?

956

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1020

---

What is write ahead logging in sql server?

1030

---

what is a unique key ? : Sql dba

1077

---

explain access control lists. : Sql dba

981

---

Does normalization improve performance?

1019

---

what is a record in a database ? : Sql dba

1046

---

How do I truncate a sql log file?

1053

---

Is primary key is clustered index?

986

---

How does one load ebcdic data? : aql loader

1150

---

How insert into statements in sql?

1057

---

What does select count (*) mean in sql?

1005

---

How can I make sql query run faster?

996

---

Can we edit a view in sql?

963

---