Answer Posted / swetcha

Integrity constraints provide a way of ensuring that
changes made to the database by authorized users do not
result in a loss of data consistency.
An integrity constraint can be any arbitrary predicate
applied to the database.
They may be costly to evaluate, so we will only consider
integrity constraints that can be tested with minimal
overhead.

Types of integrity constraints


(1) Non-null
(2) Key
(3) Referential integrity
(4) Attribute-based
(5) Tuple-based
(6) General assertions

plzz let me know if it's wrong

Which three commands cause a transaction to end?

1062

---

Explain entity set?

1011

---

What is ole db used for?

1009

---

How do you pass parameter in stored procedure?

1207

---

What is the concept of Virtual field?

2053

---

What is the importance of database partitioning?

1057

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1550

---

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

2308

---

aht is the difference b/w network & hierarchial & relational dbms????

2205

---

What are the most common databases?

971

---

List various types of log-based recovery in DBMS.

986

---

Is hive a database?

941

---

Which database is best to store images?

1042

---

what is transaction state, buffer management, shadow paging

3451

---

How do you connect to a database?

1101

---