SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

---

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

---

Explain the categories of stored procedure?

0 Answers  

---

What is the difference between indexing and hashing?

0 Answers  

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

0 Answers  

---

---

Explain about Normalization?

0 Answers   Infosys,

---

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

---

What is log cache in sql server?

0 Answers  

---

Wht is SQL Injection Attack ?

3 Answers  

---

What is the most common trace flags used with sql server?

0 Answers  

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---

What is a partition function in sql server?

0 Answers  

---