单选题You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the da

题目
单选题
You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）
A

A table of records is efficient in terms of network traffic. 

B

A table of records improves developer productivity because the database administrator does not have to create a server side view. 

C

A table of records is efficient because the number of records fetched depends on the Array Fetch property value.

D

Your coding effort is simplified since DML operations are handles by setting form module properties.

相似考题

1.You are the database administrator for a retail company. The company owns 270 stores. Every month, each store submits approximately 2,000 sales records, which are loaded into a SQL Server 2000 database at the corporate headquarters.A Data Transformation Services (DTS) package transforms the sales records, as they are loaded. The package writes the transformed sales records to the Sales table, which has a column for integer primary key values. The IDENTITY property automatically assigns a key value to each transformed sales record.After loading this month's sales data, you discover that a portion of the data contains errors. You stop loading data, identify the problem records, and delete those records from the database.You want to reuse the key values that were assigned to the records that you deleted. You want to assign the deleted key values to the next sales records you load. You also want to disrupt users' work as little as possible.What should you do?A．Export all records from the Sales table to a temporary table. Truncate the Sales table, and then reload the records from the temporary table.B．Export all records from the Sales table to a text file. Drop the Sales table, and then reload the records from the text file.C．Use the DBCC CHECKIDENT statement to reseed the Sales table's IDENTITY property.D．Set the Sales table's IDENTITY_INSERT property to ON. Add new sales records that have the desired key values.

2.You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.

3.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.

4.The answer for preventing you from falling into a state of subhealth is that you should______.A. work hardB. sleep moreC. take more medicineD. be deep relaxed and form. good living habits

更多“单选题You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the da”相关问题

  • 第1题：

    You work as an application developer at Certkiller .com. You are currently in the process of creating a new application for Certkiller .com. You are required to read compressed data files that has been sent by Certkiller .com‘s sales offices.These data files are less than 4 GB in size, but was compressed without cyclic redundancy. You want to write a method that receives the compressed files and return the uncompressed data as a byte array.What should you do?（）

    A.

    B.

    C.

    D.


    参考答案：A

  • 第2题：

    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）

    • A、using only the RMAN SWITCH command to set the new location for the data file
    • B、placing the database in the MOUNT state for the restore and recovery operations.
    • C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
    • D、configuring two channels: one for the restore operation and the other for the recovery operation

    正确答案:C

  • 第3题：

    You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）

    • A、A table of records is efficient in terms of network traffic. 
    • B、A table of records improves developer productivity because the database administrator does not have to create a server side view. 
    • C、A table of records is efficient because the number of records fetched depends on the Array Fetch property value.
    • D、Your coding effort is simplified since DML operations are handles by setting form module properties.

    正确答案:A

  • 第4题：

    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）

    • A、using only the RMAN SWITCH command to set the new location for the data file
    • B、placing the database in the MOUNT state for the restore and recovery operations.
    • C、using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.
    • D、configuring two channels: one for the restore operation and the other for the recovery operation

    正确答案:C

  • 第5题：

    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.

    正确答案:B

  • 第6题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the d ata file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    You are creating the SAL_INFO data block on the EMP_QUERY form. The SALARY field should only be populated if the logged-on user is a manager. Since this query could potentially return a large amount of records, you have created a stored procedure which uses a ref cursor on which to base the data block. How would you create the data block?（）
    A

    Click the Data Blocks node in the Object Navigator and click the create button. Choose to build the data block manually. Enter the procedure name in the Query Data Source Columns property and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. 

    C

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Alter the Query Data Source Name, Query Data Source Columns, and Query Data Source Arguments properties to create a stored procedure that uses a ref cursor. 

    E

    Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.


    正确答案： A
    解析： 暂无解析

  • 第8题：

    单选题
    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
    A

    Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 

    B

    Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 

    C

    Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 

    D

    Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 

    E

    Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You are creating the CUST_PREMIUM data block in the AUTO_INSURANCE form. A new state law requires that premiums be lowered for drivers with a good driving history. Because this could potentially affect a large number of records, you want to base the data block on a stored procedure returning a table of records. Which statement supports this approach?（）
    A

    A table of records is efficient in terms of network traffic. 

    B

    A table of records improves developer productivity because the database administrator does not have to create a server side view. 

    C

    A table of records is efficient because the number of records fetched depends on the Array Fetch property value.

    D

    Your coding effort is simplified since DML operations are handles by setting form module properties.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    Application in writing (with CV and daytime phone number)To: Mark Burns, Personnel Department.If you want to apply, you should
    A

    send letter.

    B

    telephone Personnel.

    C

    write for an application form.


    正确答案： C
    解析：
    题意：书面申请书(内附个人履历和单位电话号码)。关键词为writing。因此选项A“如果你想申请，请写信给我们”符合题意。

  • 第11题：

    单选题
    You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）
    A

    Tab canvas. 

    B

    Pop up canvas. 

    C

    Spread table canvas. 

    D

    Vertical toolbar canvas.


    正确答案： A
    解析： 暂无解析

  • 第12题：

    单选题
    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）
    A

    MERGE

    B

    INSERT

    C

    UPDATE

    D

    ADD

    E

    ENTER

    F

    You cannot enter the phone numbers for the existing employee records.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）

    • A、Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
    • B、Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
    • C、Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
    • D、Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
    • E、Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.

    正确答案:E

  • 第14题：

    You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）

    • A、BFILE 
    • B、REF column 
    • C、Object table 
    • D、Column object 
    • E、INSTEAD-OF trigger

    正确答案:B,C,D

  • 第15题：

    Which new key architectural element introduced in WebLogic Server l2c should you take  advantage of when designing Disaster Recovery Centers with active - passive mode?（）

    • A、MAN Clusters, because they would allow you to synchronously replicate state in low latency networks 
    • B、WAN Clusters, because they would allow you to asynchronously replicate state in nonlow latency networks.  
    • C、Transaction Log in the database, because you could avoid synchronizing two replication technologies (database and file)  
    • D、Data Guard, because it is the most effective way to replicate a state across locations
    • E、GoldenGate, because it is the most effective way to replicate a state across locations

    正确答案:E

  • 第16题：

    You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform?（）

    • A、MERGE
    • B、INSERT
    • C、UPDATE
    • D、ADD
    • E、ENTER
    • F、You cannot enter the phone numbers for the existing employee records.

    正确答案:C

  • 第17题：

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


    正确答案： A
    解析： 暂无解析

  • 第18题：

    单选题
    You need to create a data block for DML operations in the NEW_EMPLOYEE form module. Which data source can you use for this block?（）
    A

    REF cursor query. 

    B

    Stored function. 

    C

    From clause query. 

    D

    Transactional trigger.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    Which new key architectural element introduced in WebLogic Server l2c should you take  advantage of when designing Disaster Recovery Centers with active - passive mode?（）
    A

    MAN Clusters, because they would allow you to synchronously replicate state in low latency networks 

    B

    WAN Clusters, because they would allow you to asynchronously replicate state in nonlow latency networks.  

    C

    Transaction Log in the database, because you could avoid synchronizing two replication technologies (database and file)  

    D

    Data Guard, because it is the most effective way to replicate a state across locations

    E

    GoldenGate, because it is the most effective way to replicate a state across locations


    正确答案： E
    解析： 暂无解析

  • 第20题：

    单选题
    Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）
    A

    ROWS

    B

    SKIP

    C

    LOAD

    D

    BINDSIZE


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    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?（）
    A

    table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    In Recovery Manager (RMAN), you are taking image copies of the data files of your production database and rolling them forward at regular intervals. You attempt to restart your database. After a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the data file by using the image copy. Because a media failure caused the data file to be damaged, you want to place the data file in a different location while restoring the file. Which option must you consider for this task?（）
    A

    using only the RMAN SWITCH command to set the new location for the data file

    B

    placing the database in the MOUNT state for the restore and recovery operations.

    C

    using an RMAN RUN block with the SET NEWNAME and then the SWITCH command.

    D

    configuring two channels: one for the restore operation and the other for the recovery operation


    正确答案： B
    解析： 暂无解析

  • 第23题：

    多选题
    You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）
    A

    BFILE

    B

    REF column

    C

    Object table

    D

    Column object

    E

    INSTEAD-OF trigger


    正确答案： B,C,D
    解析： 暂无解析

  • 第24题：

    单选题
    A consultant has been asked to do a performance analysis on a database server.  Which subsystem should the consultant first analyze and why？（）
    A

    CPU，because the database replication process requires a considerable amount of CPU time

    B

    Memory，because the buffer cache requires a large amount of memory to maintain the data in system memory

    C

    Disk，because it is important to configure a sufficient number of disks to match the CPU processing power

    D

    Network，because the data returned to the client from the server can be a large subset of the total database


    正确答案： C
    解析： 暂无解析

相关内容