【多选题】The user HR receives the following error while inserting data into the TTK table:ERROR at line 1: ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SM...
A.
Add a data file to the SMD tablespace.
B.
Add a data file to the temporary tablespace associated with the user HR.
C.
Resize the data file associated with the SMD tablespace to make it larger.
D.
Alter the data file associated with the SMD tablespace to grow automatically.
E.
Change the segment space management for the SMD tablespace to automatic
【单选题】You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to ...
A.
Modify the UPDATE statement in the OLE DB Command transform to use the PAGLOCK table hint.
B.
Modify the UPDATE statement in the OLE DB Command transform to use the TABLOCK table hint.
C.
Stage the data in the data flow. Replace the OLE DB Command transform in the data flow with an Execute SQL task in the control flow.
D.
Stage the data in the data flow. Replace the UPDATE statement in the OLE DB Command transform with a DELETE statement followed by an INSERT statement.
【单选题】You are developing a client application that uses the following code to consume a Windows Communication Foundation (WCF) service.(Line numbers are included for reference only.) 01 BasicHttpBinding myB...
A.
var channelFactory = new ChannelFactory ();
B.
var channelFactory = new ChannelFactory (myBinding);
C.
var channelFactory = new ChannelFactory (myBinding, myEndpointAddress);
D.
var channelFactory = new ChannelFactory ("http://contoso.com/TaxService.svc");