Loading...

SQL Server

What is a view?
  1. A view is a special stored procedure executed when certain event occurs
  2. A view is a virtual table which results of executing a pre-compiled query
  3. A view is a database diagram
  4. None of the Mentioned
Which of the following is not a limitation of view?
  1. ORDER BY Does Not Work
  2. Index Created on View Used Often
  3. Cross Database Queries Not Allowed in Indexed View
  4. Adding Column is Expensive by Joining Table Outside View
Which of the following following statement is true?
  1. Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our needs
  2. Views are virtual tables that are compiled at run time
  3. Creating views can improve query response time
  4. All of the Mentioned
SQL Server has mainly how many types of views?
  1. one
  2. two
  3. three
  4. four
Dynamic Management View is a type of
  1. System Defined Views
  2. User Defined View
  3. Simple View
  4. Complex View
Syntax for creating views is
  1. CREATE VIEW AS SELECT
  2. CREATE VIEW AS UPDATE
  3. DROP VIEW AS SELECT
  4. CREATE VIEW AS UPDATE
You can delete a view with ___________ command.
  1. DROP VIEW
  2. DELETE VIEW
  3. REMOVE VIEW
  4. TRUNCATE VIEW
What is SCHEMABINDING a VIEW?
  1. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
  2. These are stored only in the Master database
  3. These types of view are defined by users on specified schema
  4. These are used to show database self describing information
Which of the following is not a SQL Server INFORMATION_SCHEMA view?
  1. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
  2. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  3. INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  4. sys.dm_exec_connections
___________ is stored only in the Master database.
  1. Database-scoped Dynamic Management View
  2. Complex View
  3. Catalog View
  4. None of the mentioned