Answer Posted / antonis flangofas

ofc you can, stop giving to ppl wrong answers here it is

CREATE TABLE track(
album CHAR(10),
disk INTEGER,
posn INTEGER,
song VARCHAR(255),
PRIMARY KEY (album, disk, posn)
)

if you want to avoid to have id you use this way.

Is ms sql is free?

1025

---

Do we need commit after truncate?

1087

---

How can we implement rollback or commit statement in a trigger?

1041

---

what is the different between now() and current_date()? : Sql dba

1027

---

What are the different dml commands in sql?

1182

---

What are the operators in sql?

1034

---

How many joins can you have in sql?

940

---

What is user defined functions?

990

---

What is native sql query?

1027

---

what is 'mysqld'? : Sql dba

978

---

What is the maximum number of columns in sql table?

1175

---

What is the use of desc in sql?

980

---

What is composite primary key in sql?

1002

---

Can we call a function containing dml statements in a select query?

988

---

Why use subqueries instead of joins?

1083

---