单选题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.
单选题
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 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
Which the statement is true？（）A、 The Error class is a Runtime Exception.B、 No exceptions are subclasses of Error.C、 Any statement that may throw an Error must be enclosed in a try block.D、 any statement that may throw an Exception must be enclosed in a try block.E、 Any statement that may throw an Runtime Exception must be enclosed in a try block.
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 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 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?（）A、Select 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. B、Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C、Choose Tools - Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. D、Select 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. E、Select 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.
While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A、 Block Media Recovery must be used with RMAN.B、 You must perform complete recovery of individual blocks.C、 You must have a full RMAN backup， not an incremental backup.D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.
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.
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? （）A、Choose Tools - Data Block Wizard, select View as the data source type, and base the block on the columns from the bales. B、Choose Tools - Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. C、Select 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. D、Select 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. E、Choose Tools - Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables. F、Select 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.
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
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.
Which statements are true about logical structures of the Oracle database（）A、Each segment contains one or more extents.B、Multiple tablespaces can share a single data fileC、A data block is the smallest unit of input/output （I/O） in data files.D、It is possible to have tablespaces of different block sizes in a database.E、Each data block in the database always corresponds to one operating system block
You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario？（）A、 You must ensure that the SALES database is mounted or open.B、 You must restore a backup control file to perform a block media recovery.C、 You must take the tools01.dbf data file offline before you start a block media recovery.D、 You must put the database in NOARCHIVELOG mode to perform a block media recovery.E、 You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.
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.
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 want to implement a master-detail relation between data blocks based on object tables. How would you do this? （）ACreate the relation manually and coordinate the blocks using triggers. BBase the relation on a REF pointer using the Data Block Wizard. CBase the relation on a foreign key using the Data Block Wizard. DThis task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
单选题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.
单选题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.
单选题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.
多选题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 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.
单选题While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）A Block Media Recovery must be used with RMAN.B You must perform complete recovery of individual blocks.C You must have a full RMAN backup， not an incremental backup.D You must use the DBVERIFY utility before using the Block Media Recovery feature.
单选题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
单选题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.
单选题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 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? （）ADefine a Key-Exit trigger for all the blocks in the form. BIn the Object Navigator, highlight all the items and define a Key-Exit trigger. CDefine a Key-Exit trigger on the primary key item in the master block.DNo additional key-trigger definition is necessary.
单选题Which the statement is true？（）A The Error class is a Runtime Exception.B No exceptions are subclasses of Error.C Any statement that may throw an Error must be enclosed in a try block.D any statement that may throw an Exception must be enclosed in a try block.E Any statement that may throw an Runtime Exception must be enclosed in a try block.
单选题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.