Answer Posted / sanjeev kumar

CREATE VIEW Authorsview
AS
SELECT au_id, au_fname, au_lname, phone, state, contract
FROM authors
WHERE state = 'ca'

This is an updatable view and a user can change any column value
like:
UPDATE Authorsview SET state='NY'


Example: but when we create With Check Option then Same as
above but the state column cannot be changed.

CREATE VIEW Authorsview
AS
SELECT au_id, au_fname, au_lname, phone, state, contract
FROM authors
WHERE state = 'ca'
With Check Option

The view is still updatable, except for the state column:

UPDATE Authorsview SET state='NY'

This will cause an error and the state will not be changed
because we have use check option with state.

What is log shipping?

945

---

What is the difference between clustered index and primary key?

896

---

How to create a new schema in a database?

1110

---

What is a subquery in a select query statement in ms sql server?

1114

---

What is a database in ms sql server?

1035

---

Explain about Joins?

969

---

What are the different types of normalization?

1137

---

What are audit control procedures?

971

---

What is the default fill factor value?

1063

---

What is the purpose of sql profiler in sql server? : sql server database administration

1084

---

What are system databases in ms sql server?

1024

---

How many types of objects are there?

984

---

What is a database table?

950

---

What is co-related sub query?

1005

---

After removing a table from database, what other related objects have to be dropped explicitly?

1024

---