Create the relation manually and coordinate the blocks using triggers.
Base the relation on a REF pointer using the Data Block Wizard.
Base the relation on a foreign key using the Data Block Wizard.
This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
第1题:
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?()
第2题:
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? ()
第3题:
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? ()
第4题:
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()
第5题:
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?()
第6题:
Choose Tools -> Data Block Wizard, select View as the data source type, and base the block on the columns from the bales.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
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.
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.
Choose Tools -> Data Block Wizard, select Stored Procedure as the data source type, and base the block on the columns the tables.
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.
第7题:
by using the ANALYZE utility
by using the DBVERIFY utility
by using the DB_BLOCK_CHECKING parameter
by using the DBMS_REPAIR package
第8题:
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.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables.
Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables.
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.
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.
第9题:
table
transactional trigger
stored procedure
FROM clause query
第10题:
Use the Data Block Wizard and base the relation on a REF pointer.
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.
Use the Data Block Wizard, and base the relation on the primary key-foreign key relationship in the database.
This task is not possible because master-detail relations can be implemented only for blocks based on relational tables.
第11题:
It is created as a nondisplay item.
The Lock Record property is set to Yes.
It cannot be referenced in item level triggers.
It is placed on the canvas with the highest sequence number.
第12题:
Define a Key-Exit trigger for all the blocks in the form.
In the Object Navigator, highlight all the items and define a Key-Exit trigger.
Define a Key-Exit trigger on the primary key item in the master block.
No additional key-trigger definition is necessary.
第13题:
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? ()
第14题:
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?()
第15题:
You have the following requirements in relation to the detection of block corruption for your database instance: Check for logical self-consistency of data blocks when modified in memory. Checksums are calculated before and after the block change. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically?()
第16题:
You want to implement a master-detail relation between data blocks based on object tables. How would you do this? ()
第17题:
Create the relation manually and coordinate the blocks using triggers.
Base the relation on a REF pointer using the Data Block Wizard.
Base the relation on a foreign key using the Data Block Wizard.
This task is not possible because master-detail relations can be implemented only for blocks based on relation tables.
第18题:
Click 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.
Choose Tools -> Data Block Wizard, select Table as the data source type, and base the data block on the columns included in the procedure.
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 'Ref cursor', and enter the name of the procedure in the Query Data Source Name property.
Select 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.
Launch the Data Block Wizard, select Stored Procedures as the data source type, and base the block on the procedure.
第19题:
GET_RELATION_PROPERTY
SET_RELATION_PROPERTY
GET_BLOCK_PROPERTY
GET_FORM_PROPERTY
第20题:
Block Media Recovery must be used with RMAN.
You must perform complete recovery of individual blocks.
You must have a full RMAN backup, not an incremental backup.
You must use the DBVERIFY utility before using the Block Media Recovery feature.
第21题:
Set the DB_SECUREFILE parameter to PERMITTED
Set the DB_ULTRA_SAFE parameter to DATA_ONLY
Set the DB_LOCK_CHECKSUM parameter to TYPICAL
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL
第22题:
Select the block that contains the data to appear in the pie chart.
Select the table that contains the data to appear in the pie chart.
Select the view that contains the data to appear in the pie chart.
Nothing. The wizard will automatically create the pie chart based on the highlighted data.
第23题:
by using triggers
by using Data Pump
by using external tables
by using anonymous PL/SQL blocks
第24题:
The Enforce Primary Key property on the STUDENT block is set to Yes.
The Alias property on the COURSES_OFFERED block is set to Student.
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.
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.