Answer / hr@tgksolutions.com

Databases made for handling transaction-oriented applications are known as OLTP (Online Transaction Processing) databases. They are designed to handle a lot of brief online transactions (update, remove, insert). Retail sales systems are one example.
Databases created for querying and reporting are known as OLAP (Online Analytical Processing) databases, and they are frequently used for corporate intelligence and data analysis. They are best suited for processes involving a lot of reading on big data sets. Data warehousing is one example.

What is CRUD Operations?

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

0 Answers  

---

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

0 Answers  

---

How do you create a database for an organization?

0 Answers  

---

Explain the different types of languages that are available in the dbms?

0 Answers  

---

What is rdbms and its types?

0 Answers  

---

What do you mean by DBMS?

0 Answers   Hexaware,

---

What are its two major subsystems of r?

0 Answers  

---

Explain database partitioning and its importance.

0 Answers  

---

What is dbms used for?

0 Answers  

---

What's the difference between 'union' and 'union all' ?

0 Answers  

---

what is s/w lifecycle?

1 Answers   IBM,

---