Database Developer Question:
Download Job Interview Questions and Answers PDF
Tell us what is a View?
Answer:
A view is like a subset of a table which is stored logically in a database. A view is a virtual table. It contains rows and columns similar to a real table. The fields in the view are fields from one or more real tables. Views do not contain data of their own. They are used to restrict access to the database or to hide data complexity.
CREATE VIEW view_name AS SELECT column_name1, column_name2 FROM table_name WHERE CONDITION;
CREATE VIEW view_name AS SELECT column_name1, column_name2 FROM table_name WHERE CONDITION;
Download Database Developer Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell us what is RDBMS? | Tell us what are the different types of joins? |