单选题The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to 

题目
单选题
The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to determine which rows were flagged in the record group?（）
A

GET_GROUP_ROW_COUNT 

B

GET_GROUP_SELECTION_COUNT 

C

GET_GROUP_SELECTION 

D

FIND_GROUP 

E

FIND_COLUMN 

F

ADD_GROUP_ROW 

相似考题

1.Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member， which is not a member of the current group. How would you recover from the loss of the redo log member？（）A、SMON would automatically restore the lost file.B、You would need to restore the whole database from the last backup.C、You would need to restore the file from the last full database backup.D、You would need to use flashback technology to restore the lost redo log member.E、You would need to use Recovery Manager （RMAN） to restore the lost redo log member.F、You would need to restore the missing log file by copying one of the remaining files from the same group.

2.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.

3.What is a rotating item?（）A、A rotating item is an individual item that is defined with a common item number. An item is designated as rotating because one wants to be able to create individual asset records by using the information (Classification, Specification,and Item Assembly Structure) contained on the item record.B、A rotating item is a set of items that are defined with a specific code. An item is designated as rotating because one does not want to be able to create individual asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the item record.C、A rotating item is a set of kits that are defined with a specific description and GL. An item is designated as rotating because one has the single cost to manage prefers to be able to create individual asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the assembly record.D、A rotating item is an individual item that is defined with a common item number and can be a spare part. An item is designated as rotating because one wants to be able to create multiple asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the item set records.

4.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

更多“单选题The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to ”相关问题

  • 第1题：

    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’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2000   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   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’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2400   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   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’   SQL>UPDATE EMPLOYEE  SET SALARY = 2900   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   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 Drop
    • B、 Flashback Table
    • C、 Flashback Database
    • D、Flashback Version Query

    正确答案:D

  • 第2题：

    You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）

    • A、SALARY form at runtime. 
    • B、SALARY form at design time. 
    • C、COMMISSION form at runtime. 
    • D、COMMISSION form at design time. 

    正确答案:D

  • 第3题：

    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. 

    正确答案:D

  • 第4题：

    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.

    正确答案:A

  • 第5题：

    You install two Exchange Server 2010 Service Pack 1 （SP1） Edge Transport servers named Edge1 and Edge2.You need to ensure that e-mail is sent only to Edge2 if Edge1 fails. What should you do？（）

    • A、Create two CNAME records that have the same name.Create one MX record that uses the FQDN of the CNAME records.Assign a priority of 0 to the MX record.
    • B、Create two MX records.Assign the MX record for Edge1 a priority of 5.Assign the MX record for Edge2 a priority of 1.
    • C、Create two A records that use the same name.Create one MX record that uses the FQDN of the A record.Assign a priority of 0 to the MX record.
    • D、Create two MX records.Assign the MX record for Edge1 a priority of 1.Assign the MX record for Edge2 a priority of 5.

    正确答案:D

  • 第6题：

    单选题
    The record group in the EMP form is populated using a SELECT statement that is constructed programmatically at runtime. Five employee records are displayed at one time, and a user chooses item two from the record group. Which built-in would you use to determine which rows were flagged in the record group?（）
    A

    GET_GROUP_ROW_COUNT 

    B

    GET_GROUP_SELECTION_COUNT 

    C

    GET_GROUP_SELECTION 

    D

    FIND_GROUP 

    E

    FIND_COLUMN 

    F

    ADD_GROUP_ROW 


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

  • 第7题：

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

    B

     Both the Flashback Transaction Query and the Flashback Version Query

    C

     Only the Flashback Drop

    D

     Only the Flashback Version


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

  • 第8题：

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


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

  • 第9题：

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


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

  • 第10题：

    多选题
    Your application requires that you programmatically manipulate a nonquery record group. Which three built-ins can you use?（）
    A

    CREATE_GROUP

    B

    ADD_GROUP_NOW

    C

    POPULATE_GROUP

    D

    ADD_GROUP_COLUMN

    E

    CREATE_GROUP_FROM_QUERY


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

  • 第11题：

    单选题
    You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? （）
    A

    CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);

    B

    CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;

    C

    CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;

    D

    CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);

    E

    CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;


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

  • 第12题：

    单选题
    You install two Exchange Server 2010 Service Pack 1 （SP1） Edge Transport servers named Edge1 and Edge2.You need to ensure that e-mail is sent only to Edge2 if Edge1 fails. What should you do？（）
    A

    Create two CNAME records that have the same name.Create one MX record that uses the FQDN of the CNAME records.Assign a priority of 0 to the MX record.

    B

    Create two MX records.Assign the MX record for Edge1 a priority of 5.Assign the MX record for Edge2 a priority of 1.

    C

    Create two A records that use the same name.Create one MX record that uses the FQDN of the A record.Assign a priority of 0 to the MX record.

    D

    Create two MX records.Assign the MX record for Edge1 a priority of 1.Assign the MX record for Edge2 a priority of 5.


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

  • 第13题：

    Which two are true about aggregate functions? （）

    • A、You can use aggregate functions in any clause of a SELECT statement.
    • B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.
    • C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
    • D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.
    • E、You can use aggregate functions on a table, only by grouping the whole table as one single group.
    • F、You cannot group the rows of a table by more than one column while using aggregate functions.

    正确答案:A,D

  • 第14题：

    Which built-in copies values from a record group into a list item? （）

    • A、POPULATE_LIST 
    • B、POPULATE_GROUP 
    • C、POPULATE_LIST_ITEM 
    • D、POPULATE_LIST_FROM_GROUP 
    • E、POPULATE_LIST_ITEM_FROM_GROUP

    正确答案:A

  • 第15题：

    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

    正确答案:C

  • 第16题：

    You need to create a form for Payroll application that will allow the user to view all information for any employee ID queried. This data should be displayed to the user in a grouped format. The user should be able to choose which information they want to see from a pull down list containing the values PERSONAL and PAYROLL. Which format should you use to create this form?（）

    • A、One content canvas and multiple stacked canvases. 
    • B、One content and one stacked canvas.
    • C、Tab canvas with several tab pages. 
    • D、One content canvas. 
    • E、A horizontal and vertical toolbar.

    正确答案:A

  • 第17题：

    单选题
    What is a rotating item?（）
    A

    A rotating item is an individual item that is defined with a common item number. An item is designated as rotating because one wants to be able to create individual asset records by using the information (Classification, Specification,and Item Assembly Structure) contained on the item record.

    B

    A rotating item is a set of items that are defined with a specific code. An item is designated as rotating because one does not want to be able to create individual asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the item record.

    C

    A rotating item is a set of kits that are defined with a specific description and GL. An item is designated as rotating because one has the single cost to manage prefers to be able to create individual asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the assembly record.

    D

    A rotating item is an individual item that is defined with a common item number and can be a spare part. An item is designated as rotating because one wants to be able to create multiple asset records by using the information (Classification, Specification, and Item Assembly Structure) contained on the item set records.


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

  • 第18题：

    多选题
    Some data storage and transfer media have fixed-length physical records.  When the data records are short， more then one can be stored in a single， physical record to use the storage space efficiently. Consider this data：   1119 Smith 1120 Yvonne 1121 Albert 1130 Thomas   Which two statements can you use to load the data into the EMP table？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第19题：

    单选题
    You are developing the Payroll application that contains the SALARY and COMMISSION forms. When a user invoked the COMMISSION form from the SALARY form, the SAL value should be passed to the COMMISSION form. In which data form and at what time should you define the parameter to accept the value?（）
    A

    SALARY form at runtime. 

    B

    SALARY form at design time. 

    C

    COMMISSION form at runtime. 

    D

    COMMISSION form at design time. 


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

  • 第20题：

    单选题
    Which built-in copies values from a record group into a list item? （）
    A

    POPULATE_LIST 

    B

    POPULATE_GROUP 

    C

    POPULATE_LIST_ITEM 

    D

    POPULATE_LIST_FROM_GROUP 

    E

    POPULATE_LIST_ITEM_FROM_GROUP


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

  • 第21题：

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


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

  • 第22题：

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


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

  • 第23题：

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


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

  • 第24题：

    单选题
    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’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2000   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   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’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2400   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   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’   SQL>UPDATE EMPLOYEE  SET SALARY = 2900   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   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 Drop

    B

     Flashback Table

    C

     Flashback Database

    D

    Flashback Version Query


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

相关内容