单选题What does the FORCE option for creating a view do?（）A creates a view with constraintsB creates a view even if the underlying parent table has constraintsC creates a view in another schema even if you don't have privilegesD creates a view regardless of

题目

单选题

What does the FORCE option for creating a view do?（）

creates a view with constraints

creates a view even if the underlying parent table has constraints

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

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

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

相似问题和答案

第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题：

What is true about updates through a view? ()

A. You cannot update a view with group functions.

B. When you update a view group functions are automatically computed.

C. When you update a view only the constraints on the underlying table will be in effect.

D. When you update a view the constraints on the views always override the constraints on the underlying tables.

参考答案：A

第4题：

What is necessary for your query on an existing view to execute successfully? （）

A、The underlying tables must have data.
B、You need SELECT privileges on the view.
C、The underlying tables must be in the same schema.
D、You need SELECT privileges only on the underlying tables.

正确答案:B

第5题：

Which version of a view would you use if you just want a quick， easy view within your XPage？（）

A、Data Table Control
B、View Control
C、Repeat Control
D、Filter by category View Control

正确答案:B

第6题：

What is necessary for your query on an existing view to execute successfully? ()

A. The underlying tables must have data.

B. You need SELECT privileges on the view.

C. The underlying tables must be in the same schema.

D. You need SELECT privileges only on the underlying tables.

参考答案：B

第7题：

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

第8题：

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）

A. It creates the table and encrypts the data in it.

B. It generates an error because the wallet is closed.

C. It creates the table but does not encrypt the data in it.

D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

参考答案：B

第9题：

The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）

A、HR can grant the privilege to JIM but without GRANT OPTION.
B、HR can grant the privilege to JIM because HR is the owner of the view.
C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.

正确答案:D

第10题：

What is true about updates through a view? （）

A、You cannot update a view with group functions.
B、When you update a view group functions are automatically computed.
C、When you update a view only the constraints on the underlying table will be in effect.
D、When you update a view the constraints on the views always override the constraints on the underlying tables.

正确答案:A

单选题What does the FORCE option for creating a view do?（）A creates a view with constraintsB creates a view even if the underlying parent table has constraintsC creates a view in another schema even if you don't have privilegesD creates a view regardless of

题目

相似问题和答案

更多相关问题

相关内容