单选题You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）ACreate the relation manually and coordinate the blocks using triggers. BBase the relation on a REF pointer using the Data Block Wizard. CBase the relation on a foreign key using the Data Block Wizard. DThis task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
单选题
You want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）
A
Create the relation manually and coordinate the blocks using triggers.
B
Base the relation on a REF pointer using the Data Block Wizard.
C
Base the relation on a foreign key using the Data Block Wizard.
D
This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
参考解析
解析：
暂无解析
相关考题：
In which case would you use a FULL OUTER JOIN? () A. Both tables have NULL values.B. You want all unmatched data from one table.C. You want all matched data from both tables.D. You want all unmatched data from both tables.E. One of the tables has more data than the other.F. You want all matched and unmatched data from only one table.
You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.
You are the administrator of a SQL Server 2000 computer. The server contains a database that stores financial data. You want to use Data Transformation Services packages to import numeric data from other SQL server computers. The precision and scale values of this data are not defined consistently on the other servers.You want to prevent any loss of data during the import operations. What should you do?A．Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the source tables. Change the data types so that they will use the lowest precision and scale values of the data that will be transferred.B．Use the ALTER COLUMN clause of the ALTER TABLE statement to change data types in the destination tables. Change the data types to reflect the highest precision and scale values involved in data transfer.C．Set a flag on each DTS transformation to require an exact match between source and destination columns.D．Set the maximum error count for each DTS transformation task equal to the number of rows of data you are importing. Use an exception file to store any rows of data that generate errors.E．Write Microsoft ActiveX script. for each DTS transformation. Use the script. to recast data types to the destinations precision and scale values.
What two technologies do SMB customers most often want to implement in the future?() A. MobilityB. OpticalC. TelepresenceD. VoiceE. Data Center
You want your Catalyst switch to implement a switching method that holds a packet in its memory until the data portion of the respected packet reaches the switch.Which method should you employ on your Catalyst switch?（）A. Fast ForwardB. Store and forwardC. Frag-freeD. None of the above
Which of the following data network would you implement if you wanted a wireless network that had a relatively high data rate, but was limited to very short distances?（）A、Broadband personal comm. Service (PCS)B、Broadband circuitC、InfraredD、Spread spectrumE、Cable
You want your Catalyst switch to implement a switching method that holds a packet in its memory until the data portion of the respected packet reaches the switch.Which method should you employ on your Catalyst switch?（）A、Fast ForwardB、Store and forwardC、Frag-freeD、None of the above
In which three cases would you use the USING clause?（）A、You want to create a nonequijoin.B、The tables to be joined have multiple NULL columns.C、The tables to be joined have columns of the same name and different data types.D、The tables to be joined have columns with the same name and compatible data types.E、You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
You discover that the schema changes that were recently made to your SQL Server 2005 database have caused your Web site to stop functioning. It is unclear who made the changes. TestKing.com now mandates that all changes to the database schema be tracked. You need to implement a mechanism that will track schema changes in your database. What should you do？（）A、Implement a stored procedure that writes data about schema changes to a log table.B、Implement DDL AFTER triggers that write user and schema information to a log table.C、Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.D、Implement a DML AFTER trigger that writes data about schema changes to a log table.
What two technologies do SMB customers most often want to implement in the future?（）A、MobilityB、OpticalC、TelepresenceD、VoiceE、Data Center
You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）A、Implement job classesB、Implement Scheduler windowsC、Implement the mapping rule for the consumer groupsD、Set the SWITCH_TIME resource plan directive for both the resource plans
he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）A、Use the Data Block Wizard and base the relation on a REF pointer. B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）A、 The Enforce Primary Key property on the STUDENT block is set to Yes. B、 The Alias property on the COURSES_OFFERED block is set to Student. C、 The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. D、 The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement？（） A、You should create a cached data collectionB、You should create an on-demand non-cached data collection C、You should create a scheduled non-cached data collection D、You should create two different SQL Agent jobs that are scheduled stimultaneously
You have an Exchange Server 2010 organization. The network contains two Mailbox servers that are configured in a database availability group （DAG）. You plan to implement a disaster recovery solution. You need to recommend a solution that ensures that the active mailbox database copy is unaffected bythe backup process. You want to achieve this goal while minimizing costs. What should you recommend？（）A、Windows Server BackupB、Network Attached Storage （NAS） snapshotsC、Microsoft System Center Configuration ManagerD、Microsoft System Center Data Protection Manager
You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure. You need to recommend an approach for ensuring that database connectivity does not degrade. Which two actions should you recommend？（）A、 Implement transactions for database queries.B、 Close database connections in the application.C、 Use Microsoft ADO.NET in the data access layer.D、 Implement a retry policy in the data access layer.
Your SQL Server 2005 database contains a table that has 500 million rows of data. Some of the data is historical and some is current. You need to partition the data on a single server to increase performance and optimize maintenance. What should you do？（）A、Implement horizontal partitioning.B、Implement vertical partitioning.C、Implement a raw partition.D、Implement distributed partitioning.
单选题Which of the following data network would you implement if you wanted a wireless network that had a relatively high data rate, but was limited to very short distances?（）ABroadband personal comm. Service (PCS)BBroadband circuitCInfraredDSpread spectrumECable
单选题In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?（）A The Enforce Primary Key property on the STUDENT block is set to Yes. B The Alias property on the COURSES_OFFERED block is set to Student. C The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. D The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
单选题You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? （）AGET_RELATION_PROPERTY BSET_RELATION_PROPERTY CGET_BLOCK_PROPERTY DGET_FORM_PROPERTY
单选题You are developing a data contract for a Windows Communication Foundation (WCF) service. The data in the data contract must participate in round trips. Strict schema validity is not required. You need to ensure that the contract is forward-compatible and allows new data members to be added to it. Which interface should you implement in the data contract class?（）AICommunicationObjectBIExtensionCIExtensibleObjectDIExtensibleDataObject
单选题You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report， ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation. You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do？（）AUse the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.BUse the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables， specifying the same collation as the Dublin database.CModify the format file to specify the same collation as the Dublin database. Import the table again.DModify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query， specify the same collation as the Dublin database.
单选题You need to base a data block on the EMP table, but you do not want to give the users of the application access privileges on the table. Which type of data source would you use to create the data block?（）Atable Btransactional trigger Cstored procedure DFROM clause query
单选题he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）AUse the Data Block Wizard and base the relation on a REF pointer. BIn the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.CUse the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. DThis task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the management data. You want to implement a data collection process. The process can gather and upload data in the management data warehouse on different schedules. What process should you implement？（）AYou should create a cached data collectionBYou should create an on-demand non-cached data collection CYou should create a scheduled non-cached data collection DYou should create two different SQL Agent jobs that are scheduled stimultaneously
单选题You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity. How would you achieve this？（）A Implement job classesB Implement Scheduler windowsC Implement the mapping rule for the consumer groupsD Set the SWITCH_TIME resource plan directive for both the resource plans
单选题In which case would you use a FULL OUTER JOIN? （）ABoth tables have NULL values.BYou want all unmatched data from one table.CYou want all matched data from both tables.DYou want all unmatched data from both tables.EOne of the tables has more data than the other.FYou want all matched and unmatched data from only one table.