What is dbms and its functions?

0 Answers  

---

Who proposed the relational model?

0 Answers  

---

If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains

2 Answers   Wipro,

---

What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

0 Answers  

---

How do you set up a database?

0 Answers  

---

What database does facebook use?

0 Answers  

---

What SYSTEM VARIABLE is used to refer DATABASE TIME ?

1 Answers  

---

Is declare cursor executable?

0 Answers  

---

What are different partitioning techniques in database?

0 Answers  

---

What is db dialect?

0 Answers  

---

1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????

0 Answers  

---

Mention the different types of dbms.

0 Answers  

---