Question

Sandeep has multiple applications that need to see the same list of servers in his network. Those servers are a subset of all the data in his SERVERS table. The rules for compiling the list are detailed and change frequently. Which of the following approaches would be most helpful for solving Sandeep’s problem?

	a.	Creating a foreign key
	b.	Creating a table for each application
	c.	Altering the SERVERS table
	d.	Creating a view

Answer 1

ANSWER: OPTION-D

A View is a virtual table and it is based on the results of an SQL Statement.

We can store the list of servers in a view by writing a query and get that list every time in any application.

A View is just like a table with ROWS and COLUMNS. We Can take a subset of the columns from the real table and store them in the VIEW.

So, the best option is to proceed with the VIEWS