其他
Insert Subscriber Data发生在以下什么设备之间?()A.MS---SGSNB.SGSN---HLRC.SGSN---GGSND.SGSN---MSC
题目
A.MS---SGSN
B.SGSN---HLR
C.SGSN---GGSN
D.SGSN---MSC
相似问题和答案
第1题：
A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom
第2题：
A.SEND ROUTING INFORMATION
B.SEND PARAMETERS （取鉴权参数）
C.INSERT SUBSCRIBER DATA （位置更新）
D.PROVIDE ROAMING NUMBER
第3题：
You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:
BULK INSERT finance.dbo.customers
FROM ‘di\bulk\accts143_10141000.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You want to ensure that response times do not slow when new account information is added to the database. What should you do?
A．Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.
B．Remove the TABLOCK option from the BULK INSERT statement.
C．Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
D．Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.
解析：Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.
Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior. that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.
Incorrect Answers:
A: The recommendation to perform. the bulk copy operation with the indexes in place depends on the amount of data to be copied into the table compared to the amount of existing data already in the table. The large the amount of data to be loaded into a table, relative to the amount of data already in the table, the more efficient it is to drop all indexes on the table, perform. the bulk copy operation, and then re-create the indexes after the data is loaded
C: The BATCHSIZE option of the BULK INSERT statement is used to specify that SQL Server 2000 must treat each batch of rows inserted into the table as a separate transaction. This is useful when errors occur in the bulk copy operation, which would cause the transaction to be rolled back. By specifying the BATCHSIZE option, only the current transaction will be rolled back if an error occurs and the destination table still contains the other batches of rows that were successfully inserted.
D: The ROWS_PER_BATCH option of the BULK INSERT statement SQL Server can be used to
indicate the approximate number of rows in a batch. SQL Server 2000 then optimizes the load automatically, according to the batch size value, which may result in better performance. Although accuracy in the clause is not critical, the larger the batch size is, the better the performance of the bulk copy operation.
第4题：
IMSI（International Mobile Subscriber Identity）存在于哪些设备中（）
- A、SIM
- B、VLR
- C、HLR
- D、BSC
正确答案:A,B,C
第5题：
下列关于Insert Surfaces命令说法正确的是（）。
- A、Insert Surfaces命令可以在曲面与曲面之间生成新的相交曲面
- B、Insert Surfaces命令可以在曲面与曲面之间生成新的相交曲线
- C、Insert Surfaces命令不可以得到独立的相交曲线
- D、Insert Surfaces命令不可以得到曲面曲线
正确答案:B
第6题：
在UE 执行TA update，HSS通过哪条消息将用户签约数据下发给MME?()
A. Insert Subscriber data
B. Update Location answer
C. Modify bearer request
D. Create session Request
第7题：
MS在不同VLR区域漫游做位置更新时，可能从PVLR获取IMSI，也可能从MS获取IMSI，以下哪个消息仅存在于从PVLR获取IMSI的流程中（）。
- A、MAP_SEND_IDENTIFICATION
- B、MAP_INSERT_SUBSCRIBER_DATA
- C、MAP_CANCEL_LOCATION
- D、MAP_UPDATE_LOCATION
正确答案:A
第8题：
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.
解析：Explanation:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.However,transformationscannotbeperformedonthedatawhileitismovedfromthesourcefiletothetableorview,asthiswouldslowdownthedatacopyprocess.ThusthetextfilemustbeformattedbeforetheBulkInsertTaskisused.TheformatfileprovidesthedefaultinformationusedeithertobulkcopythedatainthedatafileintoaninstanceofSQLServer2000ortobulkcopydataoutfromthetable.TheformatfilealsoprovidesawaytobulkcopydataselectivelyfromadatafiletoaninstanceofSQLServer.Thisallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.IncorrectAnswers:A:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.Itthusmakestheneedtofirstimportthedataintoatemporarytableobsolete.C:TheTransform.Datataskisusedtocopydatabetweenasourceanddestinationandtooptionallyapplycolumn-leveltransformationstothedata.TheTransform.DatataskisthemostbasicimplementationofthedatapumpengineinDataTransformationServices(DTS)andisoptimizedforinsert-basedcopyingandtransformingofcolumn-leveldatabetweencommercialdatabases,spreadsheets,andtextfiles.However,theBulkInserttaskprovidesthebestperformanceforbulkinsertingtextfilesintoSQLServer2000,althoughitcannotbeusedtotransform.data.D:TheBulkInsertTaskisthefastestmechanismforcopyinglargeamountsofdataintoaSQLServer2000tableorview.Itcanmakeuseofaformatfilethatallowsforthetransferofdatatoatablewhenthereisamismatchbetweenfieldsinthedatafileandcolumnsinthetable.Byusingaformatfile,itispossibletobulkcopydataintoaninstanceofSQLServerwithouthavingtoaddordeleteunnecessarydata,orreorderexistingdata,inthedatafile.
第9题：
请选出移动终端进行位置更新操作的MAP信令正确信令顺序（）a.Insert subscriber data（Request）b.Insert subscriber data（Response）c.Update Location（Request）d.Update Location（Response）e.Send Parameters（Request）f.Send Parameters（Response）
- A、abcdef
- B、cabefd
- C、efcabd
- D、cefabd
正确答案:C
第10题：
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）
- A、Use the external table population.
- B、Use the Oracle Data Pump export and import utility.
- C、Use the conventional path data load of the SQL*Loader utility.
- D、Use the INSERT INTO...SELECT command to load the data
正确答案:C