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

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


参考解析

解析: 暂无解析

相关考题:

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.

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.

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.

Exhibit:UPDATE EzonexamConsolidatedSET District = ‘Mexico’WHERE RtvID = 45You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.When users run the query in the exhibit above the receive the following error message:Server: Mrh3612, Level 16, Stats 1, Line 1View or function ‘EzonexamConsolidated’ is not updateable because itcontains aggregates:How should you enable the query to run?A.Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.B.The appropriate users should be granted UPDATE permissions on each base table.C.To enable updates on the composite tables create an INSTEAD OF trigger on the view.D.On each base table add a cascading update trigger.

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.

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.

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、MERGEB、SELECT …CROSS JOINC、INSERT ALL …SELECTD、CREATE VIEW …CONSTRAINT

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.

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.

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.

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.

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 whether or not the base tables exist

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.

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.

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.

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.

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 fieldB、View the Windows Server 2008 Event Viewer for TS Gateway connectionsC、View Event Viewer security logD、View the Event Viewer Terminal Services-gateway log

单选题What does the FORCE option for creating a view do? ()Acreates a view with constraintsBcreates a view even if the underlying parent table has constraintsCcreates a view in another schema even if you don't have privilegesDcreates a view regardless of whether or not the base tables exist

单选题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?()AMERGEBSELECT …CROSS JOINCINSERT ALL …SELECTDCREATE VIEW …CONSTRAINT

单选题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?()A The row movement is not enabled on the table.B The first two updates were not explicitly committed.C The Flashback Versions Query lists only the most recent update.D The Flashback Versions Query stops producing rows after it encounters a time in the past when the  table structure was changed.

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

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

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

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

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

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

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

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