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

题目

单选题

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

On the Oracle server.

Locally in each form module.

In an attached PL/SQL library

On your file network server.

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

第1题

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute thefollowing script:SQL > @utlrp.sqlWhich two actions does the script perform?（）A、Parallel compilation of only the stored PL/SQL codeB、Sequential recompilation of only the stored PL/SQL codeC、Parallel recompilation of any stored PL/SQL codeD、Sequential recompilation of any stored PL/SQL codeE、Parallel recompilation of Java codeF、Sequential recompilation of Java code

点击查看答案
第2题

You are building two forms. Each form has a button and a non-base table field. When the button is pressed, a complicated calculation is executed. The calculation is the same for both forms. The calculation code does not query or change the data in the database. When the calculation completes, it returns a single value to the non-base table field. To optimize performance and maintainability, which PL/SQL structure should be used? （）A、A trigger in each form. B、A subprogram in each form. C、A stored subprogram in the database. D、A subprogram in a library that is attached to each form.

点击查看答案
第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 accountB、You should use network Service accountC、You should use domain accountD、You should use local System account

点击查看答案
第4题

You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases. What should you include in your naming convention（）？ A、For each mailbox database， provide a database name that is unique within the organization.B、For each mailbox database， provide a database name that is unique within the Mailbox server.C、For each mailbox database file， provide a file name that is unique within the organization.D、For each mailbox database file， provide a file name that is unique within the Mailbox server.

点击查看答案
第5题

You have an Exchange Server 2010 organization that contains 20 Mailbox servers. You plan to create 10 mailbox databases on each Mailbox server.You need to create a naming convention for all mailbox databases. What should you include in your naming convention？（）A、For each mailbox database， provide a database name that is unique within the organization.B、For each mailbox database， provide a database name that is unique within the Mailbox server.C、For each mailbox database file， provide a file name that is unique within the organization.D、For each mailbox database file， provide a file name that is unique within the Mailbox server.

点击查看答案
第6题

You are a database administrator for your company. You are responsible for a SQL Server 2005 database that has several indexes. You need to write a stored procedure that checks the indexes for fragmentation. Which Transact-SQL statement should you use？（）A、DBCC DBREINDEXB、SELECT * FROM sys.dm_db_index_physical_statsC、DBCC INDEXDEFRAGD、SELECT * FROM sys.indexes

点击查看答案
第7题

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.

点击查看答案

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

题目

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

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容