Answer / Monika Kriplani

The three basic rules, also known as normal forms (NF), are used to ensure the efficiency and integrity of a relational database. They are:
1. First Normal Form (1NF): Each table cell should contain only atomic values, and each record should be unique.
2. Second Normal Form (2NF): A table must be in 1NF, and all non-key columns must depend on the primary key.
3. Third Normal Form (3NF): A table must be in 2NF, and there should be no transitive dependencies.

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

1 Answers  

---

How can I detect whether a given connection is blocked?

1 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

1 Answers   CTR, Infosys, Polaris,

---

what is Normalization?

6 Answers   TCS,

---

What is normalization? Explain different levels of normalization?

9 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

What is the difference between a primary index and a secondary index? What is a duplicate data entry in an index? Can a primary index contain duplicates?

5 Answers   IBM,

---

What is the maximum length of an extended property?

1 Answers  

---

How long can an error message be in raiseerror function?

1 Answers  

---

What is dbms and its application?

1 Answers  

---

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

1 Answers  

---

What are the constraints on severity level in raiseerror?

1 Answers  

---

What are the key features of dbms?

1 Answers  

---