单选题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 W
题目
You cannot update a view with group functions.
When you update a view group functions are automatically computed.
When you update a view only the constraints on the underlying table will be in effect.
When you update a view the constraints on the views always override the constraints on the underlying tables.
相似考题
更多“单选题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 W”相关问题
-
第1题：
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 -
第2题：
You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
- A、MERGE
- B、SELECT …CROSS JOIN
- C、INSERT ALL …SELECT
- D、CREATE VIEW …CONSTRAINT
正确答案:A -
第3题：
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 -
第4题：
Which two statements about views are true?（）
- A、A view can be created as read only.
- B、A view can be created as a join on two or more tables.
- C、A view cannot have an ORDER BY clause in the SELECT statement.
- D、A view cannot be created with a GROUP BY clause in the SELECT statement.
- E、A view must have aliases defined for the column names in the SELECT statement.
正确答案:A,B -
第5题：
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 -
第6题：
You have a computer that runs Windows 7. The computer is configured to use an intranet Microsoft updateservice location. You need to view the name of the intranet service location. What should you do?（）
- A、At a command prompt， run Wusa.exe.
- B、Open Event Viewer and examine the Application log.
- C、Open Windows Update and click View update history.
- D、R.eview the contents of the C:///windows/windowsupdate.log file.
正确答案:D -
第7题：
You are an Administrator at Cer-tech .com. you manage a member server that runs Windows Server 2008.The Terminal Server Gateway （TS Gateway） is also installed on the member server. You want to find outwhether a group of users have ever connected to their workstations remotely through TS Gateway server. What should you do to achieve this task？（）
- A、Open the TS gateway console and view the events in the monitoring field
- B、View the Windows Server 2008 Event Viewer for TS Gateway connections
- C、View Event Viewer security log
- D、View the Event Viewer Terminal Services-gateway log
正确答案:D -
第8题：
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）AMERGE
BSELECT …CROSS JOIN
CINSERT ALL …SELECT
DCREATE VIEW …CONSTRAINT
正确答案： A解析： 暂无解析 -
第9题：
单选题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?（）AView the WindowsUpdate.log file.
BCreate a new log view in Event Viewer.
CFrom Update Services, view the WSUS Updates update view.
DFrom Update Services, run an Update Status Summary report.
正确答案： A解析： 暂无解析 -
第10题：
单选题What is true about updates through a view?（）AYou cannot update a view with group functions.
BWhen you update a view group functions are automatically computed.
CWhen you update a view only the constraints on the underlying table will be in effect.
DWhen you update a view the constraints on the views always override the constraints on the underlying tables.
正确答案： B解析： 暂无解析 -
第11题：
单选题The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）AREF cursor.
BInstead Of trigger.
CStored procedure that returns object values.
DThe underlying view cannot be modified because DML on a view is not supported.
正确答案： A解析： 暂无解析 -
第12题：
单选题You are granted the CREATE VIEW privilege. What does this allow you to do?（）ACreate a table view.
BCreate a view in any schema.
CCreate a view in your schema.
DCreate a sequence view in any schema.
ECreate a view that is accessible by everyone.
FCreate a view only of it is based on tables that you created.
正确答案： D解析： 暂无解析 -
第13题：
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 -
第14题：
The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）
- A、REF cursor.
- B、Instead Of trigger.
- C、Stored procedure that returns object values.
- D、The underlying view cannot be modified because DML on a view is not supported.
正确答案:B -
第15题：
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 -
第16题：
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
正确答案:D -
第17题：
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）
- A、 Use a Dynamic Management View to check for locks.
- B、 Use a Dynamic Management View to check for blocked queries.
- C、 Use a Dynamic Management View to check for long-running queries.
- D、 Use a Dynamic Management View to check the size and maximum size of the database.
正确答案:D -
第18题：
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 -
第19题：
单选题What does the FORCE option for creating a view do? （）Acreates a view with constraints
Bcreates a view even if the underlying parent table has constraints
Ccreates a view in another schema even if you don't have privileges
Dcreates a view regardless of whether or not the base tables exist
正确答案： A解析： 暂无解析 -
第20题：
单选题View the Exhibits. You performed operations on the DEPT4 table as shown in the Exhibit. When you perform the FlashbackVersions Query， you find that the first two updates are not listed. What could be the reason？（）AThe row movement is not enabled on the table.
BThe first two updates were not explicitly committed.
CThe Flashback Versions Query lists only the most recent update.
DThe Flashback Versions Query stops producing rows after it encounters a time in the past when the table structure was changed.
正确答案： D解析： 暂无解析 -
第21题：
单选题You have a computer that runs Windows 7. The computer is configured to use an intranet Microsoft updateservice location. You need to view the name of the intranet service location. What should you do?（）AAt a command prompt， run Wusa.exe.
BOpen Event Viewer and examine the Application log.
COpen Windows Update and click View update history.
DR.eview the contents of the C:///windows/windowsupdate.log file.
正确答案： D解析： 暂无解析 -
第22题：
多选题Which two statements about views are true?（）AA view can be created as read only.
BA view can be created as a join on two or more tables.
CA view cannot have an ORDER BY clause in the SELECT statement.
DA view cannot be created with a GROUP BY clause in the SELECT statement.
EA view must have aliases defined for the column names in the SELECT statement.
正确答案： D,E解析： 暂无解析 -
第23题：
单选题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?（）ACreate CHECK constraints on the tables.
BCreate a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view.
CCreate the view, specifying the WITH SCHEMABINDING option.
DCreate the view, specifying the WITH CHECK option.
正确答案： C解析： 暂无解析 -
第24题：
单选题A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend？（）AUse a Dynamic Management View to check for locks.
BUse a Dynamic Management View to check for blocked queries.
CUse a Dynamic Management View to check for long-running queries.
DUse a Dynamic Management View to check the size and maximum size of the database.
正确答案： A解析： 暂无解析