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?（）

相似题目

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

  查看最佳答案

• A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A .  Flash back all the tables in the data file， one by one. B .  Restore the data file to a new location and perform a media recovery. C .  Flash back the database， there is no need to restore the data file. D .  Restore the data file from the most recent backup and flash the database.

  查看最佳答案

• You are maintaining your OLTP database in Oracle10g. You have not set the warning level and critical level threshold values for space usage of the DATA1 tablespace. What will be the impact？（）

  A .  No warning level or critical level alert will be generated. B .  A warning level alert will never be generated， but a critical level alert will be generated when 97 percent space of the DATA1 tablespace is used. C .  A critical level alert will never be generated， but a warning level alert will be generated when 85 percent space of the DATA1 tablespace is used. D .  A warning level alert will be generated at 85 percent space usage of the DATA1 tablespace， and a critical level alert is generated at 97 percent space usage of the DATA1 tablespace.

  查看最佳答案

• You work as a database administrator for Certkiller .com. The UNDO_RETENTION parameter in your database is set to 1000 and undoretention is not guaranteed. Which statement regarding retention of undo data is correct？（）

  A . Undo data becomes obsolete after 1，000 seconds. B . Undo data gets refreshed after 1，000 seconds. C . Undo data will be stored permanently after 1，000 seconds. D . Committed undo data would be retained for 1，000 seconds if free undo space is available. E . Undo data will be retained in the UNDOtablespacefor 1，000 seconds， then it gets movedmovedto the TEMPORARYtablespaceto provide read consistency.

  查看最佳答案

• As an experienced technician, you are responsible for Technical Support in your company. One of the trainees is asking you in what might happen if he issues the logging trap information command. Which of the following statement will answer his queston?（）

  A . Informational and debug messages are logged to the syslog server. B . All messages are sent to the logging host, where selections are made. C . An information trap is sent to the SNMP server. D . All messages from emergencies to informational are sent to the logging host.

  查看最佳答案

• Identify two situations in which the block header grows in a data block. （）

  A . when row directories need more row entries B . when there is row migration in the data block C . when there is an increase in the PCTFREE value for the data block D . when more transaction slots are required than are initially configured

  查看最佳答案

• ote the following structures in your database server： 1：Extents 2：OS Blocks 3：Tablespace  4：Segments  5：Oracle Data Block  Which option has the correct arrangement of these structures from the smallest to the largest（）

  A . 2， 5， 1， 4， 3 B . 1， 2， 3， 4， 5 C . 5， 2， 1， 3， 4 D . 2， 1， 5， 4， 3

  查看最佳答案

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

  查看最佳答案

• An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache. How would you guarantee that the blocks for the table never age out?（）

  A . Configure the KEEP buffer pool and alter the table with the corresponding storage clause. B . Increase the database buffer cache size. C . Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause. D . Configure Automata Shared Memory Management. E . Configure Automatic Memory Management

  查看最佳答案

• You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

  A . SYSTEM  B . OUTLN  C . INTERNAL  D . SYS

  查看最佳答案

• You need to change the text of a pop-up menu that appears when a user right clicks the mouse in the EMP_DATA data block. Where could you find the node for the pop-up menu in the Object Navigator?（）

  A . Built-in Packages  B . Menus  C . PL/SQL Libraries  D . Object Libraries  E . Form Module

  查看最佳答案

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

  查看最佳答案

• The datafiles of your database are ASM files. You are performing a check for datafile block corruption by using the DBVERIFY utility.   What is a prerequisite for checking block corruption on an ASM datafile by using the DBVERIFY utility？（）  

  A .  The block change tracking feature must be enabled. B .  OMF must be configured on your database. C .  The database must be in ARCHIVELOG mode. D .  A USERID must be supplied.

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by 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.

  查看最佳答案

• 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 enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file？（）

  A .  RBAL B .  CKPT C .  SMON D .  PMON E .  MMON F .  CTWR G .  DBWR

  查看最佳答案

• A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  A . flash back all the tables in the data file， one by one B . restore the data file to a new location and perform a media recovery C . flash back the database; there is no need to restore the data file D . restore the data file from the most recent backup and flash back the database

  查看最佳答案

• Note the following structures in your database server： 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest（）

  A . 2，5，1，4，3 B . 1，2，3，4，5 C . 5，2，1，3，4 D . 2，1，5，4，3

  查看最佳答案

• A part program is stored in the form of blocks of information, and each block has the numerical data needed to manufacture a segment of the work-piece.

  查看最佳答案

•  A part program is stored in the form of blocks of information, and each block has the numerical data needed to manufacture a segment of the work-piece.

  查看最佳答案

• In Customizing for Logistics Invoice Verification, the following values are defined for the stochastic block:

  Threshold value-10000 Percentage-50 You enter an invoice with a value of 15000 What is the probability that the invoice will be blocked stochastically？ Please choose the correct answer.() A.100% B.5% C.50% D.75%

  查看最佳答案

• Ken is looking for Mr. Anderson. He meets Jane and asks her for directions. Imagine you are Jane. Tell Ken how he might find Mr. Anderson. Fill in the blanks according to the clues given in brackets. Then act it out with your partner. Ken: Jane, where is Mr. Anderson’s office You: 1 （） ____________________.

  查看最佳答案