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

相似题目

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

  查看最佳答案

• The database has the data block size set to 8 KB. You need to import a tablespace with a 4 KB block size into the database. Which additional memory parameter（s） should be configured to perform a transportable tablespace import？（）

  A .  DB_4K_CACHE_SIZE only B .  DB_8K_CACHE_SIZE only C .  DB_BLOCK_SIZE and DB_4K_CACHE_SIZE D .  DB_BLOCK_SIZE and DB_8K_CACHE_SIZE E .  SGA_TARGET and DB_4K_CACHE_SIZE F .  DB_CACHE_SIZE only

  查看最佳答案

• There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）

  A .  the DBNEWID utility B .  the DBVERIFY utility C .  the ANALYZE command D .  the RMAN REPORT command E .  the RMAN CROSSCHECK command F .  the CHECK_OBJECT procedure of the DBMS_REPAIR package

  查看最佳答案

• You create a Data Collector Set (DCS).You need prevent the DCS from logging data if the server has less than 1 GB of available disk space. What should you do？（）

  A . Create a passive file screen. B . Create an active file screen. C . Modify the Data Manager settings of the DCS. D . Modify the Stop Conditions settings of the DCS.

  查看最佳答案

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

  查看最佳答案

• In your web application，you need to execute a block of code whenever the session object is first created. Which design will accomplish this goal？（）

  A . Create an HttpSessionListener class and implement the sessionInitialized method with that block ofcode. B . Create an HttpSessionActivationListener class and implement the sessionCreated method with thatblock of code. C . Create a Filter class， call the getSession（false） method， and if the result was null， then execute that block of code. D . Create an HttpSessionListener class and implement the sessionCreated method with that block of code.

  查看最佳答案

• 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 form that will access an Oracle8 database. On which three sources can you base a data block?（）

  A . BFILE  B . REF column  C . Object table  D . Column object  E . INSTEAD-OF trigger

  查看最佳答案

• You are in the process of creating a new application. This new application has to be able to read all data from a text file. What should you do?（）

  A .https://assets.asklib.com/images/image2/2018072715444624617.jpg B .https://assets.asklib.com/images/image2/2018072715445068298.jpg C .https://assets.asklib.com/images/image2/2018072715445464634.jpg D .https://assets.asklib.com/images/image2/2018072715445747977.jpg

  查看最佳答案

• 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 want to check all the data blocks being written to the datafiles by analyzing the data on each block every time the DBWn process writes.   Which action will you perform to check the data blocks？（）

  A .  Set the value of the DB_BLOCK_CHECKING initialization parameter to TRUE B .  Use the ANALYZE utility. C .  Use the DBVERIFY utility. D .  Use the DBMS_REPAIR package.

  查看最佳答案

• You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

  A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded inbitmapblocks. E . The space utilization description of the data blocks in segments is managed through free lists.MANUAL

  查看最佳答案

• While deploying a new switch， you accidently connect ports 3/12 and 3/18 together， creating a loop. STP detected it and placed port 3/18 in blocking mode. Why did STP not place port 3/12 in blocking mode instead？ （）

  A .  Port 3/12 was already up and forwarding before the loop was created. B .  Port priority is based on lowest priority and lowest port number. C .  You connected the wire on port 3/18 last. D .  None of the above， it is purely random.

  查看最佳答案

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

  查看最佳答案

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

  A . table  B . transactional trigger  C . stored procedure  D . FROM 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?（）

  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.&e

  查看最佳答案

• 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

  查看最佳答案

• You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）

  A . Tab canvas.  B . Pop up canvas.  C . Spread table canvas.  D . Vertical toolbar canvas.

  查看最佳答案

• 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 executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

  A . The database automatically determines the extent-sizing policy for the tablespace. B . The segments are automatically shrunk when the contents are removed from them. C . The allocation of extents within the tablespace is managed through the dictionary tables. D . The space utilization description of the data blocks in segments is recorded in bitmap blocks. E . The space utilization description of the data blocks in segments is managed through free lists.

  查看最佳答案

• 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

  查看最佳答案

• While deploying a new switch， you accidently connect ports 3/12 and 3/18 together， creating a loop. STP detected it and placed port 3/18 in blocking mode. Why did STP not place port 3/12 in blocking mode instead？（）

  A . Port 3/12 was already up and forwarding before the loop was created. B . Port priority is based on lowest priority and lowest port number. C . You connected the wire on port 3/18 last. D . None of the above， it is purely random.

  查看最佳答案

• There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（） 

  A . the DBNEWID utility B . the DBVERIFY utility C . the ANALYZE command D . the RMAN REPORT command E . the RMAN CROSSCHECK command F . the CHECK_OBJECT procedure of the DBMS_REPAIR package

  查看最佳答案

• You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.

  You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails. What should you do？ A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails. B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails. C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails. D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.

  查看最佳答案