Database - Introduction to SQL - Discussion
Discussion Forum : Introduction to SQL - General Questions (Q.No. 6)
6.
A view is which of the following?
Discussion:
20 comments Page 1 of 2.
Smita said:
1 decade ago
What is virtual table?
Siva said:
1 decade ago
A virtual table is temporary changes in a main database table.
Ritu said:
1 decade ago
Can you explain what is virtual table ?
Mini said:
1 decade ago
Virtual table is a temporary which is been viewed by us through the sql commands.
Ex: SELECT *...
Ex: SELECT *...
Shobhit said:
1 decade ago
Instead putting the whole db into main memory sql engine provides required rows and columns that is called vrtual table.
Ruthvik said:
1 decade ago
YA virtual table is a temparory table that can be only viewed by using commands, that means we can't alter that table by view command.
Manche Shekhar said:
1 decade ago
View is virtual database table, we can retrive the data from view by using sql commands.
By using view we can provide confidential to our data.
By using view we can provide confidential to our data.
KETHES said:
1 decade ago
Briefly explain what is a virtual?
Mvp said:
1 decade ago
A view is a virtual table which means, whose rows are not explicitly stored in the database but computed as needed.
For ex: Consider a student and course relations. Suppose we are often interested in finding the names of students who have joined in a particular course, we can define a view for this purpose
CREATE VIEW myview (name, sid, course)
AS SELECT S.sname, S.sid, C.course
FROM student S, course C;
For ex: Consider a student and course relations. Suppose we are often interested in finding the names of students who have joined in a particular course, we can define a view for this purpose
CREATE VIEW myview (name, sid, course)
AS SELECT S.sname, S.sid, C.course
FROM student S, course C;
Kishore said:
1 decade ago
View doesn't occupies space it is logical just like a window.
Post your comments here:
Quick links
Quantitative Aptitude
Verbal (English)
Reasoning
Programming
Interview
Placement Papers