πŸ“’ Too many exams? Don’t know which one suits you best? Book Your Free Expert πŸ‘‰ call Now!

  • google app store apple app store
  • βœ–

      Question

      What is the purpose of a "View" in a database?

      A To physically store a subset of data from a table. Correct Answer Incorrect Answer
      B To provide a virtual table based on the result-set of an SQL statement. Correct Answer Incorrect Answer
      C To enforce data integrity constraints. Correct Answer Incorrect Answer
      D To define a new data type. Correct Answer Incorrect Answer
      E To optimize query performance by pre-calculating results. Correct Answer Incorrect Answer

      Solution

      Answer: B) To provide a virtual table based on the result-set of an SQL statement.

      Practice Next
      ask-question