Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
There are several very large tables in the Hovercraft database. You want to create a database object that users in the India office can issue select queries against that will return only results that have the Country column of the Sales table set to the value India.
Which of the following Transact-SQL statements can you use to accomplish this task
on 11/30/2012 | Category:
Sql Server Interview questions
| Views: 3386 |
Select from following answers:
You should use the CREATE VIEW statement. Users can execute select queries against views. You could create a view on the Sales table that was defined so that the Country column equaled the value India.
You should not use the CREATE PROCEDURE statement. Users cannot execute select queries against stored procedures.
Show Correct Answer
Microsoft Press book | |
< Previous :
You want to generate a ranked list of pay rates fo ...
Next > :
The employees table of the Hovercraft database has ...
Comments or Responses
Login to post response
More Interview Questions by Rajkatie
The employees table of the Hovercraft database has the following colum ...
Which of the following queries that use string functions will return t ...
You are optimizing several Transact-SQL statements. You have determine ...
You want to use the appropriate function to convert a binary value to ...
The Employee table of the AdventureWorks2012 database includes informa ...
You want to remove the Odometer column of the Hovercraft table. This t ...
Recently, systems administrators scaled a web application you designed ...
You recently deployed an ASP.NET web application. Although the applica ...
Latest Interview Questions
You have a Transaction table which is very important table because it ...
Write a C# sharp Program to check wheather the given string is Palindr ...
Which namespace will you use to get the value of connection string def ...
Write a C# program that prints the Prime numbers between 1 and 100 and ...
There is a PDF file which contains "GuideLines" in particul ...
Write a program in C# using Linq that prints count of leap years in 20 ...
Explain how do you differentiate between design pattern and framework ...
What is a design Pattern?