Database - Introduction to SQL - Discussion

Discussion Forum : Introduction to SQL - General Questions (Q.No. 6)
6.
A view is which of the following?
A virtual table that can be accessed via SQL commands
A virtual table that cannot be accessed via SQL commands
A base table that can be accessed via SQL commands
A base table that cannot be accessed via SQL commands
Answer: Option
Explanation:
No answer description is available. Let's discuss.
Discussion:
20 comments Page 2 of 2.

Arati Sharma said:   1 decade ago
A view always shows up-to-date data! The database engine recreates the data, using the view's SQL statement, every time a user queries a view.

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.

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.

Mini said:   1 decade ago
Virtual table is a temporary which is been viewed by us through the sql commands.

Ex: SELECT *...

Mitali said:   9 years ago
If we delete some info in virtual table will it also get deleted from base table?

Siva said:   1 decade ago
A virtual table is temporary changes in a main database table.

Kishore said:   1 decade ago
View doesn't occupies space it is logical just like a window.

Ritu said:   1 decade ago
Can you explain what is virtual table ?

KETHES said:   1 decade ago
Briefly explain what is a virtual?

Smita said:   1 decade ago
What is virtual table?


Post your comments here:

Your comments will be displayed after verification.