DataBase Management System › Structured Query Language › Question #2818
Single Choice Not Set

QWhich of these statements is true? (i) The contents of view are derived from already existing relations (ii) View like any other relation forms the part of database schema (iii) A view can be queried, inserted into, deleted from and joined with other relations or views

ID: #2818 Structured Query Language 507 views
Question Info
#2818Q ID
Not SetDifficulty
Structured Query LanguageTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A Only (i) is true ✔ ✖
  • B Only (i) and (iii) are true ✔ ✖
  • C Only (ii) and (iii) are true ✔ ✖
  • D (i), (ii) and (iii) are true ✔ ✖
Correct Answer

Explanation

Only (i) and (iii) are true
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which of the following is the valid SQL statement? (a) SELECT * FROM Employee WHERE email_id IS NULL; Which of the following clauses is used to restrict groups returned by the GROUP BY clause? Which of these keywords is used to eliminate duplicate tuples from the resultant relation? Which of these is the correct command to change "Jon" into "John" in the Name attribute of the Employee relati Which of the following constraints ensures that the foreign key value in the referencing relation must exist i The command that can be used to make changes in the name of publishers in a relation PUBLISHER is____________. Which of the following will return the number of tuples in the Employee relation? The operation that is used to retrieve those tuples present in one relation, and not present in another relati Consider the following SQL statements: (I) DELETE FROM Customer; (II) DROP TABLE Customer; Which of these is the correct command for inserting values in the Employee relation?