You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）

相似题目

• Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and specify the KEEP clause.Which components are backed up when this option is specified?（）

  A . only the control file, the current SPFILE, and data files B . only the current SPFILE and data files if autobackup is disabled C . only the data files and the archived redo logs D . the control file, current SPFILE file, data files, and archived redo log

  查看最佳答案

• You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）

  A .  FRENCH_AI B .  FRENCH_CI C .  AI_FRENCH D .  CI_FRENCH

  查看最佳答案

• Using the command shown here， what time format must you specify to recover the database until a point-in-time？（）  SQL> RECOVER DATABASE UNTIL TIME ’<time format>’；

  A . YYYY-DD-MM:HH24:SS:MI  B . YYYY-DD-MM:HH24:SS:MM  C . YYYY-MM-DD:HH24:MI:SS  D . YYYY-DD-MM:SS:MI:HH24

  查看最佳答案

• You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

  A . Extents would be managed by the freelists. B . The segment would be managed by bitmaps. C . The segment would be managed by the freelists. D . Free space would be managed by the data dictionary.

  查看最佳答案

• When compressing data with the DeflateStream class， how do you specify a stream into which to write compressed data？（）

  A .  Set the BaseStream property with the destination stream， and set the CompressionMode property to Compression. B .  Specify the stream to write into the DeflateStream object is created （for example， in the constructor）. C .  Use the Write method of the DeflateStream class. D .  Register for the BaseSream event of the DeflateStream class.

  查看最佳答案

• You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

  A . a table name which has 100s of records B . a table name which has 10s of records C . a table name which has empty records D . a table name which has 1000s of records E . never use a table name

  查看最佳答案

• You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）

  A .  The location used for control files. B .  The location used for redo log files. C .  The location set by using $ORACLE_BASE D .  The location set by using $ORACLE_HOME E .  The location set by using CORE_DUMP_DEST F .  The location set by using BACKGROUND_DUMP_DEST

  查看最佳答案

• Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）

  A . ROWS B . SKIP C . LOAD D . BINDSIZE

  查看最佳答案

• During the installation of Oracle Database 11g，you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.  How would this environment variable setting affect the installation？（）  

  A .  The installation terminates with an error. B .  The installation proceeds with the default value without warnings and errors. C .  The installation proceeds with the default value but it would not be an OFA-compliant database. D .  The installation proceeds with the default value but a message would be generated in the alert log file.

  查看最佳答案

• Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）

  A .  use DBMS_IJOB package B .  use Oracle Scheduler C .  use DBMS_JOB package D .  use Oracle Data Pump Export and Import

  查看最佳答案

• You are designing a remote administration solution that meets business requirements. You need to specify client or server software that will be required. What should you do？（）

  A . Ensure that all client computers have a graphical Telnet client installed B . Ensure that all client computers have the Remote Desktop Connection client software installed C . Ensure that all server computers have RCONSOLE installed and that it is configured to start automatically D . Ensure that all server computers have Remote Administration （HTML） installed

  查看最佳答案

• You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file？（）

  A .  DB_CREATE_FILE_DEST B .  DB_RECOVERY_FILE_DEST C .  DB_RECOVERY_FILE_DEST_SIZE D .  DB_ONLINE_LOG_DEST_

  查看最佳答案

• You create a Web page that contains the span shown in the following line of code. TextYou need replace the contents of the span with HTML that you download from a URL specified by a global variable named localURL. Which code segment should you use？（）

  A . $.ajax({ type: "GET", url: localURL, dataType: "jsonp", success: function(htmlText { $("#span1").text(htmlText); } });  B . $.ajax( localURL, {}, function(htmlText) { $("#span1").html(htmlText); },"html" );  C . $.ajax({ type: "GET", url: localURL, dataType: "html",success: function(htmlText) { $("#span1").innerHTML = htmlText; }});  D . $.ajax({ type: "GET", url: localURL, success: function(htmlText) { $("#span1").html(htmlText); } })

  查看最佳答案

• You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）

  A . the location used for control files B . the location used for redo log files C . the location set by using $ORACLE_BASE D . the location set by using $ORACLE_HOME E . the location set by using CORE_DUMP_DEST F . the location set by using BACKGROUND_DUMP_DEST

  查看最佳答案

• Which Cisco SDM feature allows you to specify whether you want SDM files installed on your PC or on your router？（）  

  A .  Install Shield Wizard B .  Cisco SDM Express Wizard C .  Cisco SDM Image Manager D .  Create Connection Wizard

  查看最佳答案

• You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

  A .  The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE B .  The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA C .  The database instance starts，but Automatic Memory Management is disabled D .  The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

  查看最佳答案

• During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?（）

  A . The installation terminates with an error. B . The installation proceeds with the default value without warnings and errors. C . The installation proceeds with the default value but it would not be an OFA-compliant database. D . The installation proceeds with the default value but a message would be generated in the alert log file.

  查看最佳答案

• You executed the following command to back up your control file：  ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  Which initialization parameter is used to specify the location of the trace file？（）

  A . USER_DUMP_DEST B . CORE_DUMP_DEST C . TRACE_DUMP_DEST D . BACKUP_DUMP_DEST E . BACKGROUND_DUMP_DEST

  查看最佳答案

• Your database is running in ARCHIVELOG mode， and the database is open. You execute an RMAN backup and specify the KEEP clause.  Which components are backed up when this option is specified？（）  

  A .  only the control file， the current SPFILE， and data files B .  only the current SPFILE and data files if autobackup is disabled C .  only the data files and the archived redo logs D .  the control file，current SPFILE file，data files，and archived redo log

  查看最佳答案

• You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）  

  A .  The database will not start. B .  The database will start but will not retain the undo data in the undo segment. C .  The database will start， and the undo segment will contain the undo data for at least one hour. D .  The database will start， and the undo segment will retain the undo data for at least 15 minutes.

  查看最佳答案

• You have a computer that runs Windows 7. You run Runas and specify the /savecred parameter to start anapplication. You need to delete the stored password. What should you do?（）

  A . Run Del and specify the /p parameter. B . Run Runas and specify the /noprofile parameter. C . From Credential Manager， modify the Windows credentials. D . From Authorization Manager， modify the Authorization Manager options.

  查看最佳答案

• You can give the meaning of a word by specifying what it refers to.

  查看最佳答案

• Summarizing means specifying exactly what you agreed to at the ______ of a negotiation session.

  查看最佳答案

• What information can you specify in a quota arrangement? There are 2 correct answers to this question.()

  A.A quota you want to assign to the source B.An info record number for external procurement requirements C.An outline agreement number for external procurement requirements D.A procurement type for each source 此题为多项选择题。

  查看最佳答案