单选题The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）AREF cursor. BInstead Of trigger. CStored procedure that returns object values. DThe underlying view cannot be modified because DML on a view is not supported.
单选题
The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）
A
REF cursor.
B
Instead Of trigger.
C
Stored procedure that returns object values.
D
The underlying view cannot be modified because DML on a view is not supported.
参考解析
解析：
暂无解析
相关考题：
You are granted the CREATE VIEW privilege. What does this allow you to do? () A. Create a table view.B. Create a view in any schema.C. Create a view in your schema.D. Create a sequence view in any schema.E. Create a view that is accessible by everyone.F. Create a view only of it is based on tables that you created.
NET is both a business strategy from Microsoft and its(6)of(7)support for what are known as Web services, the ability to use the Web rather than your own computer for various services. Microsoft's goal is to provide individual and business users with a(8)interoperable and Web-enabled interface for applications and computing devices and to make computing activities increasingly Web browser-oriented. The NET(9)includes servers; building-block services, such as Web-based data storage; and device software. It also includes Passport, Microsoft's fill-in-the-form-only-once identity(10)service.A．individualB．collectionC．setD．unit
Based on your 2209 fix，which would be a warning that you are being set down on Block Island Sound South Entrance Obstruction Lighted BIS Buoy ________．A.Decreasing loran readings on 9960-WB.Visual bearings of Montauk Point Lt．changing to the leftC.Increasing bearings of Southeast Point LightD.Decreasing soundings
They bought the land in order to build a new office block.A:with a purpose to B:with a view toC:with a goal to D:with a reason to
You are granted the CREATE VIEW privilege. What does this allow you to do?（）A、Create a table view.B、Create a view in any schema.C、Create a view in your schema.D、Create a sequence view in any schema.E、Create a view that is accessible by everyone.F、Create a view only of it is based on tables that you created.
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 create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）A、It is created as a nondisplay item. B、The Lock Record property is set to Yes. C、It cannot be referenced in item level triggers. D、It is placed on the canvas with the highest sequence number.
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）A、The Query Only property is set to Yes. B、The Conceal Data property is set to Yes. C、The Insert Allowed property is set to Yes. D、The Update Allowed property is set to Yes.
he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）A、Use the Data Block Wizard and base the relation on a REF pointer. B、In the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.C、Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. D、This task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
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.
单选题You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）AIt is created as a nondisplay item. BThe Lock Record property is set to Yes. CIt cannot be referenced in item level triggers. DIt is placed on the canvas with the highest sequence number.
单选题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.
单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows?（）ACREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);BCREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);CCREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;DCREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;
单选题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.
单选题Your x86-based server will not boot Solaris 10 OS. You discover that you need to restore your pboot and boot block on the / （root） slice located on disk c0d0. You first boot off of the CD-ROM or DVD into single user mode. What commands should you run to restore the pboot and boot block on the slice？（）A AB BC CD D
单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）AUse the DESCRIBE command in the EMP_DEPT VU view.BUse the DEFINE VIEW command on the EMP_DEPT VU view.CUse the DESCRIBE VIEW command on the EMP_DEPT VU view.DQuery the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.EQuery the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.FQuery the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
单选题You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）AALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);BMODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);CALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;DMODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;ECREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;FYou must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
单选题A sales analyst reviews the first draft on your Sales application, and requests that the application graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How would you incorporate this graphic in your form? （）AInvoke the Chart Wizard and create a chart based on the ORDER block. BCreate a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block. CInvoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes. DSelect the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette.
单选题When configuring role-based CLI on a Cisco router，which action will be taken first ？（）ACreate a parser view called root view.BLog in to the router as the root user.CEnable the root view on the router.DEnable role-based CLI globally on the router using the privileged EXEC mode Cisco IOS command.
单选题he data blocks in your form module are based on object tables. How would you create a master-detail relationship between two of these blocks?（）AUse the Data Block Wizard and base the relation on a REF pointer. BIn the Object Navigator, select the Relation node under the master block and click the Create icon. Build the relation manually and coordinate the blocks using triggers.CUse the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database. DThis task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
单选题The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）AREF cursor. BInstead Of trigger. CStored procedure that returns object values. DThe underlying view cannot be modified because DML on a view is not supported.
单选题Which of the following is based on the communicative view of language？AStructural syllabus.BSkill-based syllabus.CGenre-based syllabus.DFunctional-notional syllabus.
单选题Based on your 2209 fix，which would be a warning that you are being set down on Block Island Sound South Entrance Obstruction Lighted BIS Buoy? （）ADecreasing loran readings on 9960-WBVisual bearings of Montauk Point Lt. changing to the leftCIncreasing bearings of Southeast Point LightDDecreasing soundings
单选题You are granted the CREATE VIEW privilege. What does this allow you to do?（）ACreate a table view.BCreate a view in any schema.CCreate a view in your schema.DCreate a sequence view in any schema.ECreate a view that is accessible by everyone.FCreate a view only of it is based on tables that you created.
单选题You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）AThe Query Only property is set to Yes. BThe Conceal Data property is set to Yes. CThe Insert Allowed property is set to Yes. DThe Update Allowed property is set to Yes.
单选题Which dynamic view displays the status of block-change tracking?（）AV$BLOCK_CHANGE BV$BLOCK_CHANGE_TRACKING CV$BLOCKCHANGE DV$BLOCK_TRACKING