what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

What does joining a thread mean?

0 Answers  

---

Does sql between include endpoints?

0 Answers  

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

can we call a procedure from a function?

9 Answers   Mind Tree,

---

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

How many types of relationship are there?

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

What is the difference between mdf and ndf files?

0 Answers  

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

What is a heap in sql?

0 Answers  

---

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

---