违法和不良信息举报 联系客服
免费注册 登录

You are granted the CREATE VIEW privilege. What does this al

题目
单选题
You are granted the CREATE VIEW privilege. What does this allow you to do?（）
A

Create a table view.

B

Create a view in any schema.

C

Create a view in your schema.

D

Create a sequence view in any schema.

E

Create a view that is accessible by everyone.

F

Create a view only of it is based on tables that you created.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

下面所列条目中，_________是错误的SQL语句。

A．AL TER TABLE

B．AL TER VIEW

C．CREATE TABLE

D．CREATE VIEW


正确答案：B
解析：在SQL语句中没有ALTERVIEW语句。

第2题：

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

  • A、Create a table view.
  • B、Create a view in any schema.
  • C、Create a view in your schema.
  • D、Create a sequence view in any schema.
  • E、Create a view that is accessible by everyone.
  • F、Create a view only of it is based on tables that you created.

正确答案:C

第3题：

Your network contains a server named Server1 that runs Windows Server 2008 R2.You need to ensure that an administrator is notified by e-mail if the Event Viewer logs any error.What should you do from the Event Viewer console?（）

A. Create a custom view, and then click the Filter Current Custom View action.

B. Create a custom view, and then click the Attach Task to This Custom View action.

C. From the System log, click the Filter Current Log action.

D. From the System log, select an Error event, and then click the Attach Task to This Event action.


参考答案：B

第4题：

You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20.Which SQL statement would you use to create the view EMP_VU?（）

  • A、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
  • B、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;
  • C、CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;
  • D、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20);
  • E、CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;

正确答案:C

第5题：

You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）

  • A、Update the view to use an outer join between the Customers and Sales tables.
  • B、Create a clustered index on the v CustomerSales view.
  • C、Create two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.
  • D、Create a stored procedure for the business analysts that uses the v CustomerSales view.

正确答案:B

第6题：

______ you said is true, there are still other factors to be considered.

A．Supposed that what
B．Supposing what that
C．Granted that what
D．Considered what that

答案：C
解析：
考查句法知识。granted that是一个固定搭配，表示“假定，即使”，what作said的宾语。A项应该是supposing，所以也不正确，B和D两项不符合语法要求，故排除。句意为“假设你说的是真的，还有其他的因素需要考虑”，故选C。

第7题：

You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application. The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do？（）

  • A、Create a custom action and set the NoImpersonate property to true
  • B、Create a custom action and set the NoImpersonate property to false
  • C、Create a manifest and set the RequestedExecutionLevel level attribute to AsInvoker
  • D、Create a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator

正确答案:C

第8题：

You are granted the CREATE VIEW privilege. What does this allow you to do? ()

A. Create a table view.

B. Create a view in any schema.

C. Create a view in your schema.

D. Create a sequence view in any schema.

E. Create a view that is accessible by everyone.

F. Create a view only of it is based on tables that you created.


参考答案：C

第9题：

You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application.The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do？（）

  • A、Create a custom action and set the NoImpersonate property to true
  • B、Create a custom action and set the NoImpersonate property to false
  • C、Create a manifest and set the RequestedExecutionLevel level attribute to AsInvoker.
  • D、Create a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator.

正确答案:C

第10题：

What privileges must be granted to allow an account to create the recovery catalog？（）

  • A、 RECOVERY_CATALOG_OWNER
  • B、 DBA
  • C、 RESOURCE
  • D、 SELECT ANY DICTIONARY
  • E、 CONNECT

正确答案:A,C

更多相关问题
相关内容