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 stored procedure would you use to view lock information?

1017

---

What is multi-statement table-value user-defined function?

1053

---

Can binary strings be used in arithmetical operations?

985

---

Does partitioning improve performance sql server?

1026

---

What extended events?

1062

---

Why do we use trigger?

1024

---

What is trigger in salesforce?

1051

---

When I delete any data from a table, does the sql server reduce the size of that table?

1062

---

How to locate and take substrings with charindex() and substring() functions?

1072

---

What is inner join? Explain with an example?

1285

---

What is the largest component inside a field?

1187

---

Explain filtered indexes?

1041

---

How do I create a stored procedure in dbml?

1079

---

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

977

---

What is PROJECTION Operation?

1075

---