You have a master-detail relationship in the EMPLOYEE form module. You set the Delete Record Behavior property to Cascading. When a user deletes a master record, how does Forms implement the cascade-delete foreign-key rule? ()A、With a Pre-Delete trigger. B、With an On-Delete trigger. C、With a Post-Delete trigger. D、With the On-Check-Delete-Master trigger.
You have a master-detail relationship in the EMPLOYEE form module. You set the Delete Record Behavior property to Cascading. When a user deletes a master record, how does Forms implement the cascade-delete foreign-key rule? ()
- A、With a Pre-Delete trigger.
- B、With an On-Delete trigger.
- C、With a Post-Delete trigger.
- D、With the On-Check-Delete-Master trigger.
相关考题:
You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record, the SQL statement that will undo the deletion, and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks?()A、 Only the Flashback TableB、 Both the Flashback Transaction Query and the Flashback Version QueryC、 Only the Flashback DropD、 Only the Flashback Version
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 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 are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application. The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do?()A、Create a custom action and set the NoImpersonate property to trueB、Create a custom action and set the NoImpersonate property to falseC、Create a manifest and set the RequestedExecutionLevel level attribute to AsInvokerD、Create a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator
You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to create a Windows Installer package for a Windows Forms application.The package will be deployed on Windows Vista computers.You need to ensure that during deployment the installation does not elevate privileges of the user installing the application.What should you do?()A、Create a custom action and set the NoImpersonate property to trueB、Create a custom action and set the NoImpersonate property to falseC、Create a manifest and set the RequestedExecutionLevel level attribute to AsInvoker.D、Create a manifest and set the RequestedExecutionLevel level attribute to AsAdministrator.
You are working as a DBA at NetFx Corporation. A user, Scott, is maintaining the records of all the employees in the EMPLOYEEtable. Initially, the salary of the employee, ’E0025’, was $1800. On 1 May 2004, the salary of the employee, ’E0025’, was increased by $200. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’: SQLUPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’; SQLCOMMIT; On December 1, 2004, the salary of the employee, ’E0025’, was increased by $400. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’: SQLUPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’; SQLCOMMIT; On July 1, 2005, the salary of the employee, ’E0025’, was increased by $500. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’ SQLUPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’; SQLCOMMIT; On July 5, 2005, the HR manager asked you to generate the increment report of the employee, ’E0025’, for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report?()A、 Flashback DropB、 Flashback TableC、 Flashback DatabaseD、Flashback Version Query
You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? ()A、Define a Key-Exit trigger for all the blocks in the form. B、In the Object Navigator, highlight all the items and define a Key-Exit trigger. C、Define a Key-Exit trigger on the primary key item in the master block.D、No additional key-trigger definition is necessary.
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.
You have written a custom menu for a Forms application. You saved the menu module to the file custmenu.mmb. In the Property Palette for the form, you set the Menu Module property to custmenu. When you run the form, the custom menu does not appear. What can you do to fix this problem?()A、Generate the menu module executable. B、Save the menu module as custmenu.mmx. C、In the Property Sheet for the form, set the Starting Menu property to custmenu. D、In the Property Sheet for the form, set the Menu Module property to custmenu.mmb.
At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group populated?()A、When the user navigates to the HOTEL item. B、When the form module successfully compiles. C、After Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. D、When the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES.
You need to allow the user to toggle between automatic query and no automatic query using a pop-up menu. Which built-in would you use in the menu item command to obtain the relationship name? ()A、GET_RELATION_PROPERTY B、SET_RELATION_PROPERTY C、GET_BLOCK_PROPERTY D、GET_FORM_PROPERTY
You are creating a new form for the Order Entry application. You define a record group that will be created when the form is executing this built in: CREATE_GROUP(rg_emplist, global_scope) Which form(s) in the application will have access to this record group?()A、All forms in the application. B、Any forms opened by the user who initiated the record group. C、Only the form issuing the CREATE_GROUP built-in. D、Any forms referenced by the form that contains the procedure.
How can you change the cursor style in your form? ()A、Open the form module property palette and set the Cursor Style property. B、From the Tools menu, select Preferences--Runtime Settings. C、Use the GET_APPLICATION_PROPERTY and SET_APPLICATION_PROPERTY built-ins. D、You cannot change the cursor style.
In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?()A、 The Enforce Primary Key property on the STUDENT block is set to Yes. B、 The Alias property on the COURSES_OFFERED block is set to Student. C、 The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. D、 The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.
You create a Web Form that contains a button named btnCancel that enables users to exit the page. When users click this button, validation must not occur. During testing you learn that clicking the Cancel button does not enable users to exit the page. You need to ensure that users can always exit the page. What should you do?()A、Set the Enabled property of the validation controls on the Web Form to False.B、Set the CausesValidation property of the btnCancel button to False.C、Set the CausesValidation property of the btnCancel button to True.D、Set the Visible property of the validation controls on the Web Form to False.
You work as the enterprise exchange administrator at Xxx .Xxx is using Microsoft Exchange Server 2010 as their messaging solution.You have received instructions from the CIO to enable Autodiscover for Internet users by creating a resource record in DNS.What actions must you take?()A、You must set up recipient filtering.B、You must set up a Host (A).C、You must use a TXT record.D、You must use a Pointer (PTR) record.E、You must use a Mail exchange (MX) record.
You are developing a Windows Forms Application by using the .NET Framework 3.5.You plan to create a customized Print Preview dialog box in the application. You need to ensure that users can preview their documents before printing. Which two actions should you perform?()A、Add a PrintPreviewDialog control to the form.B、Add a PrintPreviewControl control to the form.C、Create and initialize a PrintDocument object on the form and then implement the PrintPage event handler.D、Create and initialize a PrintDocument object on the form and then implement the BeginPrint event handler.E、Set the Document property of the PrintPreviewDialog control to the PrintDocument instance that must be printed.
Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?()A、 Create a FOR trigger. B、 Create an INSTEAD OF trigger. C、 Create an AFTER trigger. D、 Create a DDL trigger.
You work as the enterprise exchange administrator at Xxx .The Xxx network consists of a domain named xxx .Xxx is using Microsoft Exchange Server 2010 as their messaging solution.You have to have the Application Identifier of xxx stored in a DNS record.The Application Identifier is used for the federated trust.What actions must you take on the DNS?()A、You must set up recipient filtering.B、You must set up a Host (A).C、You must use a TXT record.D、You must use a Pointer (PTR) record.E、You must use a Mail exchange (MX) record.
单选题You are employed as a DBA in an organization. You are informed that the record of EMP_NO 1000 is missing from the SCOTT.EMP table. You are required to identify the user who deleted the record, the SQL statement that will undo the deletion, and the transaction ID of the transaction that deleted the employee record. Which feature will you use to perform the tasks?()A Only the Flashback TableB Both the Flashback Transaction Query and the Flashback Version QueryC Only the Flashback DropD Only the Flashback Version
单选题You have a master-detail relationship in the EMPLOYEE form module. You set the Delete Record Behavior property to Cascading. When a user deletes a master record, how does Forms implement the cascade-delete foreign-key rule? ()AWith a Pre-Delete trigger. BWith an On-Delete trigger. CWith a Post-Delete trigger. DWith the On-Check-Delete-Master trigger.
单选题Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?()A Create a FOR trigger. B Create an INSTEAD OF trigger. C Create an AFTER trigger. D Create a DDL trigger.
单选题At design time, you create a query record group for the LOV associated with the HOTEL text item in a form module for the Travel Planner Application. When is the record group deleted?()AWhen the user navigates to the HOTEL item. BWhen the form module successfully compiles. CAfter Form Builder validates the SELECT statement and dismisses the New Record Group dialog box. DWhen the user enters data in the HOTEL item, and the Validate from List property for the HOTEL item is set to YES.
单选题You have written a custom menu for a Forms application. You saved the menu module to the file custmenu.mmb. In the Property Palette for the form, you set the Menu Module property to custmenu. When you run the form, the custom menu does not appear. What can you do to fix this problem?()AGenerate the menu module executable. BSave the menu module as custmenu.mmx. CIn the Property Sheet for the form, set the Starting Menu property to custmenu. DIn the Property Sheet for the form, set the Menu Module property to custmenu.mmb.
单选题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.
单选题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.
单选题In the COURSE_ENROLLMENT form module, you define a master-detail relation between the COURSES_OFFERED data block and the STUDENT data block, respectively. To implement block coordination, which statement must be true?()A The Enforce Primary Key property on the STUDENT block is set to Yes. B The Alias property on the COURSES_OFFERED block is set to Student. C The Copy Value from item property on the foreign key item in the STUDENT blocks is set to the primary key item of the COURSES_OFFERED block. D The Synchronize with item property on the foreign key item in the STUDENT block is set to the primary key item of the COURSES_OFFERED block.