单选题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?（）AREF cursor query. BStored function. CFrom clause query. DTransactional trigger.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?() A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery
ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）A、vector B、database view C、database table D、transactional trigger E、PL/SQL table of records F、multi-dimensional array
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
In your web application，you need to execute a block of code whenever the session object is first created. Which design will accomplish this goal？（）A、Create an HttpSessionListener class and implement the sessionInitialized method with that block ofcode.B、Create an HttpSessionActivationListener class and implement the sessionCreated method with thatblock of code.C、Create a Filter class， call the getSession（false） method， and if the result was null， then execute that block of code.D、Create an HttpSessionListener class and implement the sessionCreated method with that block of code.
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery
You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）A、by using triggersB、by using external tablesC、by using anonymous PL/SQL blocksD、by auditing all DML operations on the table
There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） A、the DBNEWID utilityB、the DBVERIFY utilityC、the ANALYZE commandD、the RMAN REPORT commandE、the RMAN CROSSCHECK commandF、the CHECK_OBJECT procedure of the DBMS_REPAIR package
You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis. How would you achieve this（）A、by using triggersB、by using Data PumpC、by using external tablesD、by using anonymous PL/SQL blocks
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.
You create a Data Collector Set (DCS).You need prevent the DCS from logging data if the server has less than 1 GB of available disk space. What should you do？（）A、Create a passive file screen.B、Create an active file screen.C、Modify the Data Manager settings of the DCS.D、Modify the Stop Conditions settings of the DCS.
You have a file server that runs Windows Server 2008. The server has a shared folder. You need to receive a notifcation when a user stores more than 500MB of data int he shared folder. You must allow users to store more than 500MB of data in the shared folder. What should you do（）？ A、Create a soft quotaB、Create a hard quotaC、create an active screening file screenD、create a passive screening file screen
A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A、 Ensure that all statements execute in the same database transaction.B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
单选题You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis. How would you achieve this（）Aby using triggersBby using Data PumpCby using external tablesDby using anonymous PL/SQL blocks
单选题A Windows Azure application stores data in a SQL Azure database. The application will start an operation that includes three insert statements. You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost. What should you recommend？（）A Ensure that all statements execute in the same database transaction.B Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.C Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.D Open a new connection to the database. Use a separate transaction scope to roll back the original operation.
单选题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?（）ASelect 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. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. CChoose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. DSelect 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. ESelect 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.
单选题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 fund code entered. The value needed to generate this summary data are stored in multiple tables. How would you define the data source for this data block without having the DBA create a database object? （）AChoose Tools - Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. CSelect the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually and alter the Query Data Source Columns and Query Data Source Arguments properties to enter the SELECT statement. DSelect 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 'Table', and enter the SELECT statement in the Query Data Source Name property. EChoose Tools - Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. FSelect 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 to 'FROM' clause query', and enter the SELECT statement in the Query Data Source Name property.
单选题There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）Athe DBNEWID utilityBthe DBVERIFY utilityCthe ANALYZE commandDthe RMAN REPORT commandEthe RMAN CROSSCHECK commandFthe CHECK_OBJECT procedure of the DBMS_REPAIR package
单选题You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? （）ASelect the block that contains the data to appear in the pie chart. BSelect the table that contains the data to appear in the pie chart. CSelect the view that contains the data to appear in the pie chart. DNothing. The wizard will automatically create the pie chart based on the highlighted data.
单选题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?（）Ausing only the RMAN SWITCH command to set the new location for the data fileBplacing the database in the MOUNT state for the restore and recovery operations.Cusing an RMAN RUN block with the SET NEWNAME and then the SWITCH command.Dconfiguring two channels: one for the restore operation and the other for the recovery operation
多选题ou need to create a data block for query operations in the RETIRED_EMPLOYEES form module. Which three data sources can you use for this block?（）AvectorBdatabase viewCdatabase tableDtransactional triggerEPL/SQL table of recordsFmulti-dimensional array
单选题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? （）ATab canvas. BPop up canvas. CSpread table canvas. DVertical toolbar canvas.
单选题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?（）Atable Btransactional trigger Cstored procedure DFROM clause query
单选题You suspect unauthorized data manipulation language （DML） operations on a particular table. You want to track users who are performing the transactions and the values used in the transactions. Also， you plan to transfer these values to another table for analysis. How would you achieve this？（）Aby using triggersBby using external tablesCby using anonymous PL/SQL blocksDby auditing all DML operations on the table
单选题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?（）AA table of records is efficient in terms of network traffic. BA table of records improves developer productivity because the database administrator does not have to create a server side view. CA table of records is efficient because the number of records fetched depends on the Array Fetch property value.DYour coding effort is simplified since DML operations are handles by setting form module properties.
单选题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?（）AClick 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. BChoose Tools - Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure. CSelect 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. DSelect 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. ELaunch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
单选题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?（）Ausing only the RMAN SWITCH command to set the new location for the data fileBplacing the database in the MOUNT state for the restore and recovery operations.Cusing an RMAN RUN block with the SET NEWNAME and then the SWITCH command.Dconfiguring two channels: one for the restore operation and the other for the recovery operation
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You design a SQL Server 2008 Analysis Services （SSAS） solution. Customer data is stored in the tables named CustomerDetails and CustomerContact. The solution uses the following two data sources from two different servers： ·Contoso that accesses the CustomerDetails table ·ContosoCRM that accesses the CustomerContact table You plan to create a dimension named DimCustomer to analyze customer data. You need to ensure that the DimCustomer dimension represents the tables as a snowflake schema to include attributes from the two tables. What should you do？（）A Create a data source view named DsvContoso that is associated with the two data sources and add the tables to the data source view.B Create a data source view named DsvContoso that is associated with the two data sources and create a named query in the data source view to merge the tables.C Create a data source view named DsvCustomer that is associated with the Contoso data source and add the CustomerDetails table to the data source view.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and add the CustomerContact table to the data source view.D Create a data source view named DsvCustomer that is associated with the Contoso data source and create a named query in the data source view to select data from the CustomerDetails table.Create a data source view named DsvCustomerContact that is associated with the ContosoCRM data source and create a named query in the data source view to select data from the CustomerContact table.