Database Analyst Question:
Download Job Interview Questions and Answers PDF
Explain what is a view?
Answer:
A view is a virtual table that consists of a subset of data from a table. The content of a view is defined by the query. A view takes up little space because it doesn’t copy all data from the given table but only a subset of data as defined by the view. Note that a view can also display a combination of data from one or more tables. Views allow you to hide the complexity of large data and instead narrow in on areas of interest.
Download Database Analyst Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell us what is your process when you start a new project? | Tell us what is the GROUP BY statement used for? |