Database Analyst Question:

Download Job Interview Questions and Answers PDF

Explain what is a view?

Database Analyst Interview Question
Database Analyst Interview Question

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 QuestionNext Question
Tell us what is your process when you start a new project?Tell us what is the GROUP BY statement used for?