A view is a virtual table made up of data from base tables and other views, but not stored separately.
Latest Answer : View is a vitual table, which do not have physical storage.we can create a view from one or more than one table(s) or view(s).if any modification is done on the base table the view is also get effected.but they are some limitations while creating ...
A synonym is used to reference a table or view by another name. The other name can then be written in the application code pointing to test tables in the development stage and to production entities
Latest Answer : Also, a Synonym is specific to the DB2 subsystem. Synonym can only access the table or view in the subsystem in which it is defined. A synonym is dropped when the table is dropped.An Alias is yet another name for a table or view. But ...
An alias is an alternative to a synonym, designed for a distributed environment to avoid having to use the location qualifier of a table or view. The alias is not dropped when the table is dropped.
Latest Answer : An alias is a logical pointer to an alternate table name. The purpose of an alias is to resolve loops in the paths of joins. In some cases, more than one alias may be necessary for a given table.Cheers,Sithu ...
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
No. The table and its view are created anew, but the programs accessing the view do not need to be changed if the view and attributes accessed remain the same.
A54. The WHENEVER statement is coded once in the host program to control program actions depending on the SQL-CODE returned by each sql statement within the program.
Latest Answer : IT IS USED TO PERFORM THE SPECIFIC USER DIFINED FUCNTION FOR THE PARTICULAR SQL RETURN CODE..For Ex ,Whenever sqlcode = 100 Display "whenever condition returncode is 100"whenever sqlcode = 811 Display 'whenever condition ...
A control structure used by DB2 to communicate with the application program isa.Address spaceb.Authidc.Threadd.Viewe.String
Thread
Which of the following is not a purpose of a View ?a.To simplify the appearance of data to different usersb.To control access to a tablec.To show more meaningful data, such as summaryd.To store data separately
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which can limit read access to the phone_number column?
A table called EMPLOYEE has the following columns: name, department, and phone_number. Which of the following can limit read access to the phone_number column? A. Using a view to access the table B. Using
