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

题目

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
相似考题

1. 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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line.  In the options below， which utility should you choose to use？（）A、bcp.exe B、dta.exe C、dtexec.exe D、sqlmaint.exe

2.You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）A、On the Oracle server. B、Locally in each form module. C、In an attached PL/SQL library D、On your file network server.

3.You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system （OS） file.D、It is a Recovery Manager （RMAN） script

4.The system analysts have requested heavy use of object features. The database design makes use of PL/SQL8 object types, methods, and LOB types. How do you work with these features on the client?（）A、Write client-side subprograms containing the PL/SQL8 constructs, and move them into an object group. B、Write server-side subprograms, and call the subprograms from the form application. C、Store the PL/SQL8 constructs in a PL/SQL library, and attack the library to each form muddle in your application.

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

  • 第1题：

    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

  • 第2题：

    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 database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）  

    • A、You should run the bulk copy program utility along with an output file and no format file
    • B、You should run the SQLCmd utility and save the output to a file
    • C、You should run the SQL Import and Export Data Wizard and save the output to a file.
    • D、You should run the bulk copy program utility along with a format file and an output file.

    正确答案:C

  • 第3题：

    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

  • 第4题：

    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. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E://drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service.  Which log should you check？ （）

    • A、You should check ERRORLOG
    • B、You should check QL1.log
    • C、You should check SQLAGENT.OUT
    • D、You should check log_xx.trc

    正确答案:C

  • 第5题：

    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. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least.  Which action should you perform？（）

    • A、First， you should import the data from each text file into a staging table. Second， you should write a query to have a HAVING clause contained so as to migrate replicate values before results are inserted into the Product table.
    • B、First， you should make sure that each text file is stored in an Extensible Markup Language （XML） file. Second， you should utilize Extensible Stylesheet Language Transformations （XSLT） to automatically migrate replicates before data is imported into the Product table.
    • C、First， you should make sure that the unique key values for manufacturing part numbers are utilized by each of your company’s trading partners utilizes. Second， you should import the text files into the Product table.
    • D、You should place a unique index on the PartNum column.

    正确答案:A

  • 第6题：

    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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive.  In the options below, which log should you check? （） 

    • A、You should check SQL1.log 
    • B、You should check SQLAGENT.OUT 
    • C、You should check log_xx.trc 
    • D、You should check ERRORLOG 

    正确答案:B

  • 第7题：

    单选题
    You write a procedure that will be called from two level triggers and a database trigger. Where should you store this code? （）
    A

    On the Oracle server. 

    B

    Locally in each form module. 

    C

    In an attached PL/SQL library 

    D

    On your file network server.


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

  • 第8题：

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


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

  • 第9题：

    单选题
    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. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perform this by using the SQL Server Import and Export Wizard. After this， you save the package definition to a file. Now you have to reexecute the package from the command line.  In the options below， which utility should you choose to use？（）
    A

    bcp.exe 

    B

    dta.exe 

    C

    dtexec.exe 

    D

    sqlmaint.exe


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

  • 第10题：

    单选题
    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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?（）
    A

    You should check SQL1.log

    B

    You should check SQLAGENT.OUT

    C

    You should check log_xx.trc

    D

    You should check ERRORLOG


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

  • 第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 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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）
    A

    The SQL Server 2008 Upgrade Advisor should be used. 

    B

    The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 

    C

    A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 

    D

    A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.


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

  • 第13题：

    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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features.  These features will be discontinued. What should you do？ （）

    • A、The SQL Server 2008 Upgrade Advisor should be used. 
    • B、The SQL Server Profiler which captures the SQL:BatchCompleted and Exception event classes should be used. 
    • C、A SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes should be used 
    • D、A SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes should be used.

    正确答案:C

  • 第14题：

    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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check?（）  

    • A、You should check SQL1.log
    • B、You should check SQLAGENT.OUT
    • C、You should check log_xx.trc
    • D、You should check ERRORLOG

    正确答案:B

  • 第15题：

    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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （） 

    • A、You should configure Distributed File System
    • B、You should configure SQL Server
    • C、You should configure SQL Server Full Text
    • D、You should configure SQL Server VSS Writer

    正确答案:B

  • 第16题：

    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 remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance， you capture a workload of the remote instance to a trace table by using SQL Profiler. Now you have to use the Database Engine Tuning Advisor to analyze the workload of the remote SQL Server instance on a local SQL Server instance.  So what action should you perform to achieve this goal？（）

    • A、You should recapture the workload by using the data collector.
    • B、You should enable the XP_MSVER stored procedure on the local server.
    • C、You should enable the XP_MSVER stored procedure on the remote server
    • D、You should recapture the workload to a trace file by using SQL Profiler.

    正确答案:D

  • 第17题：

    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 2002 instance. You upgrade this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a file named Orderdata on a remote network share. A job accesses this Orderdata file by using a CMDExec step. The job step fails to complete execution after the upgrade. You must make sure that the job can complete execution, so you have to configure the job step. What action should you perform? （） 

    • A、You should configure a certificate 
    • B、You should configure the SQL Server Agent service to use the NetworkService account.
    • C、You should configure the job step to use a proxy account 
    • D、You should configure the SQL Server Agent service to use a local Windows account

    正确答案:C

  • 第18题：

    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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （） 

    • A、You should configure SQL Server VSS Writer 
    • B、You should configure Distributed File System 
    • C、You should configure SQL Server 
    • D、You should configure SQL Server Full Text

    正确答案:C

  • 第19题：

    单选题
    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. You intend to configure FILESTREAM data, enabling FILESTREAM for file I/O streaming access and allowing remote client computers to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. In the options below, which service should you configure? （）
    A

    You should configure Distributed File System

    B

    You should configure SQL Server

    C

    You should configure SQL Server Full Text

    D

    You should configure SQL Server VSS Writer


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

  • 第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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? （）
    A

    You should configure SQL Server VSS Writer 

    B

    You should configure Distributed File System 

    C

    You should configure SQL Server 

    D

    You should configure SQL Server Full Text


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

  • 第21题：

    单选题
    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. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E://drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service.  Which log should you check？ （）
    A

    You should check ERRORLOG

    B

    You should check QL1.log

    C

    You should check SQLAGENT.OUT

    D

    You should check log_xx.trc


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

  • 第22题：

    单选题
    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 database named Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）
    A

    You should run the bulk copy program utility along with an output file and no format file

    B

    You should run the SQLCmd utility and save the output to a file

    C

    You should run the SQL Import and Export Data Wizard and save the output to a file.

    D

    You should run the bulk copy program utility along with a format file and an output file.


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

  • 第23题：

    单选题
    You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）
    A

    It is a SQL script.

    B

    It is a PL/SQL file.

    C

    It is an operating system （OS） file.

    D

    It is a Recovery Manager （RMAN） script


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

相关内容