Answer Posted / nithya.r

A view is a virtual table. A view serves as a security
mechanism. If we have several tables in a database and we
want to view only specific columns from specific tables we
can go for views. Using view we can avoid the complex
queries.

What are the components of dbms?

954

---

Explain sub-query?

955

---

Tell me about builtinadministrator?

1001

---

Do you know exporting and importing utility?

1039

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

961

---

what is memory-optimized nonclustered indexes

1016

---

How to change parameter value inside the report?

164

---

How to use column default values in insert statements in ms sql server?

1031

---

What are the requirements for sql server 2016?

882

---

Can you edit the .rdl code associated with a linked report?

163

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1120

---

What is the difference between seek predicate and predicate?

1060

---

How to enter date and time literals in ms sql server?

1016

---

How to generate create view script on an existing view?

988

---

What is the sql profiler?

940

---