Answer / Shabana

Transaction phases in a DBMS are:
1. Begin Transaction: Starts a new transaction.
2. Work Phase: The actual database operations occur during this phase.
3. Commit: Saves the changes made during the work phase and ends the transaction.
4. Rollback: Undoes all the changes made during the work phase and returns the database to its original state.

Mention the different types of cursor?

1 Answers  

---

Do I need ccp4?

1 Answers  

---

What is the difference between case version and decode version?

0 Answers  

---

When do you get a .PLL extension ?

2 Answers   TVS,

---

What is 3nf in the dbms?

1 Answers  

---

Can A column defined as PRIMARY KEY can have NULL values ?

2 Answers  

---

Define dbms.

1 Answers  

---

Define database.

1 Answers  

---

Define cursor and its types.

1 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????

1 Answers  

---

what is s/w lifecycle?

1 Answers   IBM,

---

What is structure of dbms?

1 Answers  

---