单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）A functionB packageC procedureD database triggerE anonymous PL/SQL block

题目
单选题
Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）
A

function

B

package

C

procedure

D

database trigger

E

anonymous PL/SQL block

相似考题

1. You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler（）A、XML scriptB、PL/SQL scriptC、Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.comD、Recovery Manager （RMAN） script

2.In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）A、The source PL/SQL code will be stored in native machine code.B、The source PL/SQL code will be stored in interpreted byte code.C、The compiled PL/SQL code will be stored in native machine code.D、The compiled PL/SQL code will be stored in interpreted byte code.

3.The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）A、Programme units. B、PL/SQL libraries. C、Database object. D、Built in packages.

4.You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）A、 .SQL B、 .PLL C、 .PLDD、 .PRT

更多“Which type of PL/SQL construct would you use to automaticall”相关问题

  • 第1题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？ （）

    • A、function
    • B、package
    • C、procedure
    • D、database trigger
    • E、anonymous PL/SQL block

    正确答案:D

  • 第2题：

    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）

    • A、 functions
    • B、 package
    • C、 procedure
    • D、 database trigger
    • E、 anonymous PL/SQL block

    正确答案:D

  • 第3题：

    You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）

    • A、An object type is a user-defined composite data type. 
    • B、The attributes of an object type can be those of other object types. 
    • C、A PL/SQL table of records is an example of a nested object type. 
    • D、An object type must be declared as a type before the actual object itself can be declared.

    正确答案:A,B,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. There is a computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （） 

    • A、You should use local Service account
    • B、You should use network Service account
    • C、You should use domain account
    • D、You should use local System account

    正确答案:C

  • 第5题：

    单选题
    In your Supportcenter.cn database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）
    A

    The source PL/SQL code will be stored in native machine code.

    B

    The source PL/SQL code will be stored in interpreted byte code.

    C

    The compiled PL/SQL code will be stored in native machine code.

    D

    The compiled PL/SQL code will be stored in interpreted byte code.


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

  • 第6题：

    单选题
    You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）
    A

    MERGE

    B

    SELECT …CROSS JOIN

    C

    INSERT ALL …SELECT

    D

    CREATE VIEW …CONSTRAINT


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

  • 第7题：

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


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

  • 第8题：

    单选题
    What type of stopper would you use on a nylon mooring line? （）
    A

    Chain

    B

    Nylon

    C

    Manila

    D

    Wire


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

  • 第9题：

    单选题
    You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
    A

    DBMS_STATS 

    B

    DBMS_ALERT 

    C

    DBMS_SPACE 

    D

    DBMS_MONITOR 

    E

    DBMS_SERVER_ALERT

    F

    DBMS_SPACE_ADMIN


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

  • 第10题：

    单选题
    Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）
    A

     functions

    B

     package

    C

     procedure

    D

     database trigger

    E

     anonymous PL/SQL block


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

  • 第11题：

    单选题
    You have forgotten the name of binary PL/SQL library saved to the operating system. This file contains the PL/SQL constricts you created for the inventory report. For which file extension should you reach?（）
    A

     .SQL 

    B

     .PLL 

    C

     .PLD

    D

     .PRT


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

  • 第12题：

    多选题
    You want to make use of the object features available in the database for the form module you are developing. Which three statements about object types are true? （）
    A

    An object type is a user-defined composite data type.

    B

    The attributes of an object type can be those of other object types.

    C

    A PL/SQL table of records is an example of a nested object type.

    D

    An object type must be declared as a type before the actual object itself can be declared.


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

  • 第13题：

    You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports. Which command type must you use to identify the parent menu item as a submenu? （）

    • A、Menu 
    • B、Plus 
    • C、Macro
    • D、PL/SQL

    正确答案:A

  • 第14题：

    You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

    • A、the XML script
    • B、the PL/SQL script
    • C、the DBMS_SCHEDULER package
    • D、Enterprise Manager to schedule the backup

    正确答案:D

  • 第15题：

    You are using the backup scheduler in Enterprise Manager （EM） to schedule a backup of your database. Which type of script does the backup scheduler generate？（）

    • A、SQL script
    • B、PL/SQL script
    • C、Operating System （OS） script
    • D、Enterprise Manager （EM） script
    • E、Recovery Manager （RMAN） script

    正确答案:E

  • 第16题：

    You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）

    • A、one that uses an internal SQL Server Web service endpoint
    • B、one that runs a SQL Server Integration Services （SSIS） package
    • C、one that uses Service Broker
    • D、one that runs a user-defined function

    正确答案:C

  • 第17题：

    单选题
    In your Certkiller .com database server the parameter PLSQL_CODE_TYPE has been set to NATIVE. Which object would be achieved by the setting？（）
    A

    The source PL/SQL code will be stored in native machine code.

    B

    The source PL/SQL code will be stored in interpreted byte code.

    C

    The compiled PL/SQL code will be stored in native machine code.

    D

    The compiled PL/SQL code will be stored in interpreted byte code.


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

  • 第18题：

    单选题
    You observe that in your PROD database， customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use to accomplish this task？（）
    A

    functions

    B

    packages

    C

    procedures

    D

    database triggers

    E

    anonymous PL/SQL block


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

  • 第19题：

    单选题
    The CALC function is used several times within the sales report. To simplify maintenance you want to store the function in one place and call it from within your PL/SQL trigger code. Which node would you use in object navigator to create a report level programme unit to store the function?（）
    A

    Programme units. 

    B

    PL/SQL libraries. 

    C

    Database object. 

    D

    Built in packages.


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

  • 第20题：

    单选题
    You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）
    A

    the XML script

    B

    the PL/SQL script

    C

    the DBMS_SCHEDULER package

    D

    Enterprise Manager to schedule the backup


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

  • 第21题：

    单选题
    You want to configure and schedule offline database backups to run automatically.  Which tool or utility wouldyou use to achieve this（）
    A

    The XML script

    B

    The PL/SQL script

    C

    The DBMS_SCHEDULER package

    D

    Enterprise Manager to schedule the backup


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

  • 第22题：

    单选题
    You want to access employee details contained in flat files as part of the EMPLOYEE table. You planto add a new column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column（）
    A

    CLOB

    B

    BLOB

    C

    BFILE

    D

    LONG RAW


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

  • 第23题：

    单选题
    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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? （）
    A

    You should use local Service account

    B

    You should use network Service account

    C

    You should use domain account

    D

    You should use local System account


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

相关内容