What is data redundancy in dbms?

0 Answers  

---

What is Partial Backup ?

2 Answers  

---

What is the rdbms concept in sql?

0 Answers  

---

Does the Database trigger will fire when the table is TRUNCATED ?

3 Answers  

---

Why do we use databases?

0 Answers  

---

What database should I learn first?

0 Answers  

---

Define view, sequence and index in DBMS.

0 Answers   HAL,

---

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  

---

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

0 Answers  

---

How can we tune if buffer busy wait issue comes in oracle?

1 Answers   IBM,

---

What is a data source (ds)?

0 Answers  

---

When would you use a database?

0 Answers  

---