Answer Posted / abhishek chakraborty

Yes

In Mysql

CREATE TABLE `rooms2hire`.`user data` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`email` VARCHAR( 255 ) NOT NULL ,
`name` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` , `email` )
) ENGINE = MYISAM

What is pivot and unpivot?

776

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

785

---

What stored by the model? : sql server database administration

710

---

Explain time data type in sal server 2008?

716

---

Explain the steps to use transact-sql cursor?

668

---

---

What is mscorsvw.exe - process - microsoft .net framework ngen?

694

---

Explain can SSRS reports Cache results?

136

---

Difference between LEN() and DATALENGTH() in sql server ?

799

---

Explain the difference between primary keys and foreign keys?

697

---

Explain system scalar functions?

748

---

What are the main sources of data?

806

---

What is policy based management (pbm)? : sql server database administration

739

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

741

---

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

722

---

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

674

---