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

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

相似考题

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

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

3.The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）A、database table B、transactional trigger C、stored procedure D、FROM clause query E、client-side procedure

4. Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A、Join the two servers by using the four-part syntax of server.database.schema.table.B、Reference SQL2 by using an alias.C、Add SQL2 as a remote server to SQL1.D、Add SQL2 as a linked server to SQL1.

更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY   BEGIN TRANSACTION   DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY   BEGIN CATCH   DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH；      You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）

    • A、Add a COMMIT TRANSACTION command to the CATCH block.
    • B、Remove the COMMIT TRANSACTION command from the TRY block.
    • C、Add a ROLLBACK TRANSACTION command to the CATCH block.
    • D、Add a ROLLBACK TRANSACTION command to the TRY block.

    正确答案:C

  • 第3题：

    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 stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）

    • A、You should create a job which is assigned to the Database Maintenance category
    • B、You should create an Alert which will run another to delete the maintenance job.
    • C、You should create a job. You schedule the job to run only once.
    • D、You should create a job. The job uses the Automatically delete job option

    正确答案:D

  • 第4题：

    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?（）  

    • A、A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand. 
    • B、A policy should be created. The policy targets the name of the stored procedure that is evaluated on change. 
    • C、A condition should be created. The condition targets the name of the stored procedure that is evaluated on change 
    • D、A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.

    正确答案:B

  • 第5题：

    单选题
    The accounting manager wants you to create a form that when queried will display a calculated total of year-to-date actual expenditures for the found code entered. The values needed to generate this summary data are stored in multiple tables. Which data source type can you assign to the data block for this form without having the DBA create a database object?（）
    A

    database table 

    B

    transactional trigger 

    C

    stored procedure 

    D

    FROM clause query 

    E

    client-side procedure


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

  • 第6题：

    单选题
    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
    解析： 暂无解析

  • 第7题：

    单选题
    You are creating an online catalog application that will display product information on the company Web site. The product data is stored in a SQL Server 2005 database. The data is stored as relational data but must be passed to the application as an XML document by using FOR XML. You test your application and notice that not all of the items matching your query appear in the XML document. Only those products that have values for all elements in the schema appear.   You need to modify your Transact-SQL statement so that all products matching your query appear in the XML document. What should you do？（）
    A

    Add an XML index to the table that contains the product data.

    B

    Add the XSINIL argument to the ELEMENTS directive in the query.

    C

    Add a HAVING clause to the query.

    D

    Add the replace value of clause to the query.


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

  • 第8题：

    单选题
    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 stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）
    A

    You should create a job which is assigned to the Database Maintenance category

    B

    You should create an Alert which will run another to delete the maintenance job.

    C

    You should create a job. You schedule the job to run only once.

    D

    You should create a job. The job uses the Automatically delete job option


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

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    单选题
    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
    解析： 暂无解析

  • 第11题：

    单选题
    Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）
    A

    Join the two servers by using the four-part syntax of server.database.schema.table.

    B

    Reference SQL2 by using an alias.

    C

    Add SQL2 as a remote server to SQL1.

    D

    Add SQL2 as a linked server to SQL1.


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

  • 第12题：

    单选题
    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）
    A

    A primary XML index should be created on the XML column.

    B

    Statistics should be created on the nvarchar columns.

    C

    A view should be created， and only the four columns that the query utilizes are contained by a view.

    D

    A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.


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

  • 第13题：

    You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）

    • A、SALARY form at runtime. 
    • B、SALARY form at design time. 
    • C、COMMISSION form at runtime. 
    • D、COMMISSION form at design time. 

    正确答案:D

  • 第14题：

    You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 application is utilized by the company. A query is executed by the application to return three columns of the nvarchar data type and one column of the XML data type. A WHERE clause is utilized by the query， and all three of the nvarchar columns are contained by the WHERE clause. 5 million rows are included by the table， and 50，000 rows are returned by the query. The performance of the query should be enhanced. Which action should be performed to achieve the goal？（）

    • A、A primary XML index should be created on the XML column.
    • B、Statistics should be created on the nvarchar columns.
    • C、A view should be created， and only the four columns that the query utilizes are contained by a view.
    • D、A composite index should be created on the three nvarchar columns， and INCLUDE should be specified for the XML column.

    正确答案:D

  • 第15题：

    You are developing an ASP.NET Web application. The application must pass an object that contains user-specific data between multiple pages. The object ismore than 100 KB in size when serialized.You need to minimize the amount of data is sent to the user. What should you do？（）

    • A、Pass the object data in a hidden field.
    • B、Store the object instance in a session variable.
    • C、Use a cookie that contains the object data.
    • D、Encode the object data and pass it in a query string parameter.

    正确答案:B

  • 第16题：

    You work in a company which is named Wiikigo Corp. The company 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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）  

    • A、You should configure the database for Read Committed Snapshot isolation. 
    • B、You should modify the stored procedure to use the Snapshot isolation level 
    • C、You should configure the database for Auto Update Statistics asynchronously 
    • D、You should modify the stored procedure to use the Repeatable Read isolation level

    正确答案:B

  • 第17题：

    单选题
    jim has created a field hint for the address field. Users tell him this text disappears when they click in the address field. which one of the following is most likely reason?（）
    A

     the address field is computed 

    B

     jim should have used a text popup       

    C

     jim stored the field hint in the database    

    D

     field hint only display when the user has not clicked in the field （field hint）


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

  • 第18题：

    单选题
    You are creating a stored procedure that will delete data from the Contact table in a SQL Server 2005 database. The stored procedure includes the following Transact-SQL statement to handle any errors that occur. BEGIN TRY   BEGIN TRANSACTION   DELETE FROM Person.Contact WHERE ContactID = @ContactID COMMIT TRANSACTION END TRY   BEGIN CATCH   DECLARE @ErrorMessage nvarchar（2000） DECLARE @ErrorSeverity int DECLARE @ErrorState int SELECT @ErrorMessage = ERROR MESSAGE（），@ErrorSeverity=ERROR SEVERITY（），@ErrorState = ERROR STATE（） RAISERROR （@ErrorMessage， @ErrorSeverity， @ErrorState） END CATCH；      You test the stored procedure and discover that it leaves open transactions. You need to modify the stored procedure so that it properly handles the open transactions. What should you do？（）
    A

    Add a COMMIT TRANSACTION command to the CATCH block.

    B

    Remove the COMMIT TRANSACTION command from the TRY block.

    C

    Add a ROLLBACK TRANSACTION command to the CATCH block.

    D

    Add a ROLLBACK TRANSACTION command to the TRY block.


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

  • 第19题：

    单选题
    You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）
    A

    SALARY form at runtime. 

    B

    SALARY form at design time. 

    C

    COMMISSION form at runtime. 

    D

    COMMISSION form at design time. 


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

  • 第20题：

    单选题
    You work in a company which is named Wiikigo Corp. The company 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 report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）
    A

    You should configure the database for Read Committed Snapshot isolation. 

    B

    You should modify the stored procedure to use the Snapshot isolation level 

    C

    You should configure the database for Auto Update Statistics asynchronously 

    D

    You should modify the stored procedure to use the Repeatable Read isolation level


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

  • 第21题：

    单选题
    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
    解析： 暂无解析

  • 第22题：

    单选题
    You are developing an ASP.NET Web application. The application must pass an object that contains user-specific data between multiple pages. The object ismore than 100 KB in size when serialized.You need to minimize the amount of data is sent to the user. What should you do？（）
    A

    Pass the object data in a hidden field.

    B

    Store the object instance in a session variable.

    C

    Use a cookie that contains the object data.

    D

    Encode the object data and pass it in a query string parameter.


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

  • 第23题：

    单选题
    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 are user-defined stored procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not contain this prefix cannot be created by you.  So what should you do to ensure this two?（）
    A

    You should create a policy that targets the name of the stored procedure that is evaluated on change. 

    B

    You should create a policy that targets the name of the stored procedure that is evaluated on demand.

    C

    You should create a condition that targets the name of stored procedure that is evaluated on demand. 

    D

    You should create a condition that targets the name of the stored procedure that isevaluated on change. 


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

  • 第24题：

    单选题
    You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?（）
    A

    A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand. 

    B

    A policy should be created. The policy targets the name of the stored procedure that is evaluated on change. 

    C

    A condition should be created. The condition targets the name of the stored procedure that is evaluated on change 

    D

    A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.


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

相关内容