单选题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 Creat

题目
单选题
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.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.

2.下面所列条目中，_________是错误的SQL语句。A．AL TER TABLEB．AL TER VIEWC．CREATE TABLED．CREATE VIEW

3.______ 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

4.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.

更多“You are granted the CREATE VIEW privilege. What does this al”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）

    • A、 Remove all deterministic function calls from within the view. 
    • B、 Remove all nondeterministic function calls from within the view. 
    • C、 Schema-bind all functions that are called from within the view. 
    • D、 Create the view and specify the WITH CHECK OPTION clause.

    正确答案:B,C

  • 第5题：

    You need to use the Event Viewer window to review the event logs for only critical and error events. You also need the maximum amount of detail for each of these events. What should you do？ （）

    • A、Edit the filter for the Administrative Events view.
    • B、Create a custom view. Enable the Critical， Error， and Information level events. Select all logs.
    • C、Create a custom view. Select the Critical checkbox， Error checkbox， and Verbose checkbox. Select all logs.
    • D、Search for the Critical or Error string by using the Find option of the Administrative Events view.

    正确答案:C

  • 第6题：

    Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?（）

    • A、 Create a FOR trigger. 
    • B、 Create an INSTEAD OF trigger. 
    • C、 Create an AFTER trigger. 
    • D、 Create a DDL trigger.

    正确答案:B

  • 第7题：

    You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?（）

    • A、Create CHECK constraints on the tables. 
    • B、Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 
    • C、Create the view, specifying the WITH SCHEMABINDING option. 
    • D、Create the view, specifying the WITH CHECK option. 

    正确答案:C

  • 第8题：

    You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can view the availability of a company projector.What should you create for the projector？（）

    • A、a distribution group
    • B、a mailbox
    • C、a mail-enabled contact
    • D、a sharing policy

    正确答案:B

  • 第9题：

    单选题
    ou are developing an ASP.NET MVC 2 application. You create a view that will be returned by action methods in multiple controllers. You need to place the view in the appropriate folder. To which subfolder within the Views folder should you add the view？（）
    A

    Master

    B

    Default

    C

    Shared

    D

    Common


    正确答案： A
    解析： 暂无解析

  • 第10题：

    多选题
    TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）
    A

    Remove all deterministic function calls from within the view.

    B

    Remove all nondeterministic function calls from within the view.

    C

    Schema-bind all functions that are called from within the view.

    D

    Create the view and specify the WITH CHECK OPTION clause.


    正确答案： C,A
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    What does the FORCE option for creating a view do?（）
    A

    creates a view with constraints

    B

    creates a view even if the underlying parent table has constraints

    C

    creates a view in another schema even if you don't have privileges

    D

    creates a view regardless of whether or not the base tables exist


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

     You have a server that runs Windows Server 2003 Service Pack 2 (SP2) and Windows Server Update Services (WSUS) 3.0.You need to view the approved WSUS updates that have been superseded by newer updates. You want to achieve this goal by using the minimum amount of administrative effort. What should do you do?（）

    • A、View the WindowsUpdate.log file. 
    • B、Create a new log view in Event Viewer. 
    • C、From Update Services, view the WSUS Updates update view. 
    • D、From Update Services, run an Update Status Summary report.

    正确答案:C

  • 第17题：

    TestKing.com uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce TestKing.coms security policy of abstracting data. Some of these views perform slowly. You create indexes on those views to increase performance， while still maintaining the company’s security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（） function. This view does not allow you to create an index. You need to create an index on the view. Which two actions should you perform？（）

    • A、Remove all deterministic function calls from within the view.
    • B、Remove all nondeterministic function calls from within the view.
    • C、Schema-bind all functions that are called from within the view.
    • D、Create the view and specify the WITH CHECK OPTION clause.

    正确答案:B,C

  • 第18题：

    You have a server that runs Windows Server 2008. you create a new quota template. you apply quotas to 100 folders by using the quota template. you nede to modify the quota settings for al 100 folders. You must achive this goal by using the minimum amount of administrative effort.  What should you do（）？ 

    • A、Modify the quota template
    • B、Delte and recreate the quota template
    • C、Create a new quota template. modify the quota for each folder
    • D、Create a file screen template. Apply the file screen template to the root of the volume that contains the folders.

    正确答案:A

  • 第19题：

    Your network contains a DNS server named DNS1 that runs Windows Server 2008 R2.You need to be notified by e-mail if the DNS service logs errors or warnings. The solution must minimize the number of e-mail notifications you receive. What should you do？（）

    • A、Create an alert in Performance Monitor.
    • B、Run the Configure a DNS Server Wizard.
    • C、Select the DNS Server log from Event Viewer and attach a task to the log.
    • D、Create a custom view from Event Viewer and attach a task to the custom view.

    正确答案:D

  • 第20题：

    单选题
    You are the network administrator for The network consists of a single Active Directory domain named The TestKing Staff department has a Windows 2003 computer that functions as a file server. The computer contains a folder named TestKingData. Auditing is enabled on the TestKingData folder. The TestKing Staff department reports that confidential files were deleted from the folder. You need to identify the user who deleted the confidential files. What should you do?（）
    A

    In Event Viewer, create a new log view from the security log. Filter the log view to display only success audits.

    B

    In Event Viewer, create a new log view from the security log. Filter the log view to display only failure audits.

    C

    In Event Viewer, create a new log view from the system log. Filter the log view to display only success audits.

    D

    In Event Viewer, create a new log view from the system log. Filter the log view to display only failure audits.


    正确答案： A
    解析： 暂无解析

  • 第21题：

    多选题
    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


    正确答案： C,D
    解析： 暂无解析

  • 第22题：

    多选题
    Your company uses SQL Server 2005. You are implementing a series of views that are used in ad hoc queries. The views are used to enforce your companys security policy of abstracting data.  Some of these views perform slowly. You create indexes on those views to increase performance, while still maintaining the companys security policy. One of the views returns the current date as one of the columns. The view returns the current date by using the GETDATE（　） function. This view does not allow you to create an index. You need to create an index on the view.  Which two actions should you perform?（）
    A

    Remove all deterministic function calls from within the view.

    B

    Remove all nondeterministic function calls from within the view.

    C

    Schema-bind all functions that are called from within the view.

    D

    Create the view and specify the WITH CHECK OPTION clause.


    正确答案： D,C
    解析： 暂无解析

  • 第23题：

    单选题
    You have an Exchange Server 2010 organization.You need to ensure that all users in the organization can view the availability of a company projector.What should you create for the projector？（）
    A

    a distribution group

    B

    a mailbox

    C

    a mail-enabled contact

    D

    a sharing policy


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）
    A

     Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.

    B

     Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.

    C

     Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.

    D

     Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.


    正确答案： D
    解析： 暂无解析

相关内容