Answer Posted / marco birchler

In Oracle make the first letter capital if you wish the
output names also capitalised. "Month" instead of "month"

What are transactions and its controls?

1003

---

What are data resources?

853

---

What is indexed view? How to create it?

931

---

what happens on checkpoint? : Sql server database administration

1018

---

Can you explain what is the use of custom fields in report?

1000

---

What is lock escalation? : sql server database administration

1102

---

Do you know data definition language, data control language and data manipulation language?

982

---

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2157

---

What is the difference between Triggers and Stored Procedure?

1031

---

When you use @@error and try-catch?

982

---

What command is used to rename the database?

946

---

How many types of stored procedures are there in sql server?

952

---

What do you mean by a Composite primary key?

1028

---

What is the difference between clustered and a non-clustered index?

975

---

What is index, cluster index and nonclustered index?

927

---