what are database files, control files and log files. How many of these files should a database have at least? Why?

0 Answers  

---

What is a functional dependency in the dbms?

0 Answers  

---

Can I use google sheets as a database?

0 Answers  

---

Tell me about view, sequence and index in DBMS.

0 Answers   Honeywell, Zomato,

---

What is a deadlock and mention how it can be resolved?

0 Answers  

---

---

what is candidate key & primary key,different b/t the two?

3 Answers  

---

What is the best database to use?

0 Answers  

---

What are the types of rdbms?

0 Answers  

---

What is the relationship?

0 Answers  

---

What is foreign key in dbms?

0 Answers  

---

what is the location of oracle inventory?

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  

---