RDBMS MCQ : Relational DB Design - Views : Link4
RDBMS MCQ & Answers
Are you worried about the answers to Relational Database Management System questions-Relational Database Design : Views problems? We have arranged the Show Answer button under the each question. Candidates can click on it to know the right option among the given alternatives. Furthermore, the applicants can check our web portal @ www.totalmcq.com to take part in more MCQ on various subject. Wish, the given information about the Relational Database Management System MCQ will helpful to the advance and can learn the various types of questions and answers.
Q.1. Which one is not applicable while querying on a view?
A. From
B. SELECT
C. Order By
D. Where
Q.2. Refer below query which leads to create a view named employee.
CREATE worker VIEW
AS
SELECT nothing
FROM dbo.Employee
WHERE ID < 100
Which of the following statement is true about the above view.
A. Above query is correct.
B. View name must be after keyword view and ‘nothing’ is not a keyword , so should be replaced with *.
C. Replace nothing with view name.
D. Replace nothing with column names.
Q.3. How can you drop more than one View in single command?
A. Drop viewname1 + viewname2 + viewname(n);
B. Drop viewname1; Drop viewname2; Drop viewname(n);
C. Drop viewname1; viewname2; viewname(n);
D. Drop viewname1, viewname2,viewname(n);
Q.4. Which of the following statements is true about views
A. View never references actual table for which it is created.
B. View can’t use JOIN in it’s query.
C. The performance of the view degrades if they are based on other views.
D. Only option to safeguard data integrity.
Q.5. What is a view?
A. A view is a special stored procedure executed when certain event occurs
B. A view is a virtual table which results of executing a pre-compiled query
C. A view is a database diagram
D. None of the Mentioned
Q.6. Which of the following is not a limitation of view?
A. ORDER BY Does Not Work
B. Index Created on View Used Often
C. Cross Database Queries Not Allowed in Indexed View
D. Adding Column is Expensive by Joining Table Outside View
Q.7. Views are also called as ----------.
A. Complex tables
B. Simple tables
C. Virtual tables
D. Actual Tables
Q.8. Syntax for creating views is -------
A. CREATE VIEW view_name AS SELECT
B. CREATE VIEW view_name AS UPDATE
C. CREATE VIEW AS UPDATE
D. DROP VIEW view_name AS SELECT
Q.9. Delete a view using ------ command.
A. DROP VIEW
B. REMOVE VIEW
C. TRUNCATE VIEW
D. DELETE VIEW
Q.10. What is SCHEMABINDING VIEW?
A. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
B. These are stored only in the Master database
C. These types of view are defined by users on a specified schema
D. These are used to show database self describing information