What is a view? Why use it?

Answer Posted / srinivasa yadav

VIEW IS A VIRTUAL MEMEORY SPACE WHICH DOES'NT HOLD ANY DATA.
MAINLY VIEW IS USED TO RESTRICT AUTHORIZATION FOR THE
USERS. SO USER CAN ACCESS ONLY PARTICULAR COLUMNS.

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the contents that are a part of dclgen.

651


Explain the contention situations caused by locks?

586


What are the 2 sqlcodes that are returned?

633


What is the maximum size of a char data type in db2?

582


How do we specify index to include or not during bind process.

1672






What is cobol db2?

566


What is query_cache_limit?

541


What is the difference between oracle and db2?

579


How to connect to db2 database from windows command line?

560


What are the benefits of using the db2 database?

658


When the like statement is used?

629


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1889


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2683


How does a cursor work?

554


What are the bind parameters ibm db2?

619