Live Help (Start Chat)
View Count: 0
Duration: 51 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 13 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Sorry!For this module there is no Sample Code.
Sorry!For this module there is no Assignments.
Question No: 1 of 15
What is a view ? 
Options:
  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
View Answer/Explanation:
b
Explanation:

Question No: 2 of 15
SQL Server has mainly how many types of views ? 
Options:
  1. One
  2. Two
  3. Three
  4. Four
View Answer/Explanation:
b
Explanation:

Question No: 3 of 15
Which of the following following statement is true ? 
Options:
  1. Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our need
  2. Views are virtual tables that are compiled at run time
  3. Creating views can improve query response time
  4. All of the Mentioned
View Answer/Explanation:
d
Explanation:

Question No: 4 of 15
SQL Server has mainly how many types of views ? 
Options:
  1. One
  2. Two
  3. Three
  4. Four
View Answer/Explanation:
b
Explanation:

Question No: 5 of 15
Dynamic Management View is a type of 
Options:
  1. System Defined Views
  2. User Defined View
  3. Simple View
  4. Complex View
View Answer/Explanation:
a
Explanation:

Question No: 6 of 15
Syntax for creating views is 
Options:
  1. CREATE VIEW AS SELECT
  2. CREATE VIEW AS UPDATE
  3. DROP VIEW AS SELECT
  4. CREATE VIEW AS UPDATE
View Answer/Explanation:
a
Explanation:

Question No: 7 of 15
You can delete a view with ___________ command. 
Options:
  1. DROP VIEW
  2. DELETE VIEW
  3. REMOVE VIEW
  4. TRUNCATE VIEW
View Answer/Explanation:
a
Explanation:

Question No: 8 of 15
What is SCHEMABINDING a VIEW ? 
Options:
  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
View Answer/Explanation:
b
Explanation:

Question No: 9 of 15
Which of the following is not a SQL Server INFORMATION_SCHEMA view ? 
Options:
  1. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
  2. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  3. INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  4. sys.dm_exec_connections
View Answer/Explanation:
d
Explanation:

Question No: 10 of 15
___________ is stored only in the Master database. 
Options:
  1. Database-scoped Dynamic Management View
  2. Complex View
  3. Catalog View
  4. None of the above mentioned
View Answer/Explanation:
d
Explanation:

  1