Do You Know Views In SQL Server?

5 Questions | By SQLSERVERQUEST | Last updated: Dec 3, 2014 | Total Attempts: 236

SQL Server View Knowledge Testing

Questions and Answers

1.

Can we use Order by in SQL Server Views?
- A.
  
  NO
- B.
  
  YES
- C.
  
  Some Cases Yes
2.

Can we create index on View ?
- A.
  
  True
- B.
  
  False
3.

In updatable view the number of tables which got affected ?
- A.
  
  Only one base table
- B.
  
  All base table
- C.
  
  No base table
- D.
  
  Update is not possible in view
4.

View can reference temporary tables ?
- A.
  
  True
- B.
  
  False
5.

Derived columns are updatable in SQL Server View?
- A.
  
  True
- B.
  
  False

Related Topics

More Sql Server Quizzes

Microsoft SQL Server Quiz

Questions: 25 | Attempts: 3821 | Last updated: Dec 30, 2020

Sample Question
Assuming UserProfile is a table containing a column Proession which accepts NULL value. What is the result of the below query. SET ANSI_NULLS OFF SELECT Profession FROM UserProfile WHERE (Profession <> NULL)

Gives an error.

Returns all Professions which has not null values.

is not an operator in SQL Server.

None of the above.

Ssdo Quiz For Aptech (SQL Server 2005)

How to learn well SSDO

Questions: 84 | Attempts: 1766 | Last updated: Dec 13, 2012

Sample Question
The Stored Procedure - 2 true choices.

Is a set of pre-compiled T-SQL statements executed as a single unit.

Is a set of T-SQL that are executed as a single block of code that performs a specific task.

Is used in database Administrative and information activities.

Can be created to carry out repetitive

All of about.

Microsoft SQL Server Quiz For Beginners!

SQL Server is a Relational Database Management system(DBMS) software which is developed by Microsoft and offers a wide variety of transaction processing, business intelligence and analytics applications. This quiz has been...

Questions: 10 | Attempts: 885 | Last updated: Jun 29, 2019

Sample Question
You are designing for a large grocery store chain. The partial database schema is shown in the Partial Database Schema Exhibit. The script that was used to create the Customers table is shown in the Script for Customers Table Exhibit. The store managers want to track customer demographics so they can target advertisements and coupon promotions to customers. These advertisements and promotions will be based on the past purchases of existing customers. The advertisements and promotions will target buying patterns by one or more of these demographics: gender, age, postal code, and region. Most of the promotions will be based on gender and age. Queries will be used to retrieve the customer demographics information. You want the query response time to be as fast as possible. What should you do?

Add indexes on the PostalCode, State, and DateOfBirth columns of the Customers table.

Denormalize the Customers table

Create a view on the Customers, SalesLineItem, State, and Product tables.

Create a function to return the required data from the Customers table.

More Sql Server Quizzes

Featured Quizzes

What is The Perfect Gift for Your Best Friend Quiz What is The Perfect Gift for Your Best Friend Quiz

Which TikToker Are You Quiz Which TikToker Are You Quiz

Hunter x Hunter Nen Test: What is Your Nen Personality? Hunter x Hunter Nen Test: What is Your Nen Personality?

Pottermore Sorting Hat Quiz Pottermore Sorting Hat Quiz

Are You Ready For IQ Quiz Are You Ready For IQ Quiz

What Anime Character Do I Look Like Quiz What Anime Character Do I Look Like Quiz

Back to top