📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

    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
    More IT DBMS Questions
    ask-question