In the Oracle system, sets of SQL statements and control flow statements that have been named, compiled, and stored in the database are referred to as stored()。

相似题目

• You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

  A .  The audit trail is stored in an operating system file. B .  Auditing is disabled for all privileges. C .  The audit trail is stored in the database. D .  Auditing is enabled for all privileges. E .  Auditing is enabled for certain privileges related to database security.

  查看最佳答案

• In setting the valves on a steam-smothering system on a tank vessel，the master control valve to cargo tanks should be（）.

  A . open and individual tank valves open B . open and the individual tank valves closed C . closed and the individual tank valves closed D . closed and the individual tank valves ope

  查看最佳答案

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

  查看最佳答案

• A system must be evaluated and tuned.  In order to use a set of performance evaluation programs （e.g. filemon， svmon， and tprof）， which of the following packages should exist on the system？（）

  A .  bos.rte.control （WLM） B .  bos.perf C .  xlC.rte D .  perfagent.tool

  查看最佳答案

• In setting the valves on a steam-smothering system on a tanker，the master control valve to cargo tanks should be（）.

  A . open and individual tank valves open B . open and the individual tank valves closed C . closed and the individual tank valves closed D . closed and the individual tank valves ope

  查看最佳答案

• Using Oracle Enterprise Manager to set SGA pool values manually， for which of the following pools does Oracle EM offer advice to set the value appropriately？（） 

  A .  DB_CACHE_SIZE B .  SHARED_POOL_SIZE C .  LARGE_POOL_SIZE D .  JAVA_POOL_SIZE E .  SGA_MAX_SIZE F .  SORT_AREA_SIZE

  查看最佳答案

• View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D： \oracle\product\10.2.0\oradata\oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

  A . The tablespace has two data files. B . An error is reported and tablespace creation fails. C . Data files are created with names generated by the instance. D . The tablespace can be extended without specifying the data file. E . Data files belonging to the USERS tablespace cannot be renamed.

  查看最佳答案

• You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to  ’LOG%t_%s_%r.dbf’.  Why is %r used in the file name format？（） 

  A . to uniquely identify the archived log files with the restore operation B . to uniquely identify the archived log files with the redo log group number C . to uniquely identify the archived log files for each incarnation of the database D . to uniquely identify the archived log files with the number of recovery operations performed

  查看最佳答案

• You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• A customer is looking for a low cost System x Server solution that has a fairly robust set of software application workload requirements.  Which tool will assist you in making sure the hardware will match the workload？（）

  A . IBM Configuration & Options Guide （COG） B . IBM Sizing Guides C . IBM xREF Sheets D . IBM ServerProven E . IBM Standalone Solutions Configuration Tool （SSCT）

  查看最佳答案

• You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）

  A .  The au_size disk group attribute determines the size of allocation units in the disk group.  B .  The allocation unit size may vary but the extent size is fixed. C .  The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed. D .  Extent management is completely automated.

  查看最佳答案

• You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？ （） 

  A .  The trace files will be disabled only for a specific session. B .  Tracing will be disabled for a client identifier. C .  Tracing will be disabled only for the ARCn process. D .  The SQL Trace facility will be disabled for the instance.

  查看最佳答案

• Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）

  A .  It does not allow you to change the moving window size. B .  Adaptive threshold functionalities use it by default to compute statistics. C .  It is created by default with the window size being equal to the AWR retention time. D .  It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• In the event of a catastrophic disaster， after which you need to replace the entire UCS blade system （that is， new fabric interconnects， new IOMs， new chassis， and new blades）， what type of backup would provide the most complete set of information？（）

  A .  logical configuration B .  all configuration C .  full state D .  system configuratio

  查看最佳答案

• Which setting enables the baselines by default in Oracle Database 11g？（）  

  A .  setting the STATISTICS_LEVEL parameter to TYPICAL B .  adding filters to the Automatic Database Diagnostic Monitor （ADDM） C .  enabling Automated Maintenance Task using Oracle Enterprise Manager D .  setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

  查看最佳答案

• You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）

  A .  Increase the value of the FAST_START_MTTR_TARGET initialization parameter. B .  Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter. C .  Increase the value of the PGA_AGGREGATE_TARGET initialization parameter. D .  Increase the value of the SGA_TARGET initialization parameter.

  查看最佳答案

• A system must be evaluated and tuned.  In order to use a set of performance evaluation programs （e.g.， filemon， svmon， and tprof） which of the following packages should exist on the system in question？（）

  A .  bos.adt B .  bos.perf C .  Java.adt D .  perfagent.tool

  查看最佳答案

• 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 want to set up the Oracle Database 10g installation to follow the French language， with France as the territory， and the date to be displayed in French for all users’ sessions. Which environmental variable would you set to achieve this objective？（）

  A . NLSLANG B . NLSLENGTHSEMANTICS C . NLSTERRITORY D . NLSLANGUAGE E . NLSCHARACTERSET F . NLSDATELANGUAGE G . NLSNCHARCHARACTERSET

  查看最佳答案

• In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）

  A . the alert log file B . the core dump files C . the change tracking file D . the user session trace files E . the database audit trail files F . the background process trace file

  查看最佳答案

• You have just issued the command user@router save current.conf.Assuming the default settings, where in the file system is current.conf saved？（）

  A．/var/tmp/ B． /var/config/saved/ C． /var/home/user/ D． /config/

  查看最佳答案

• In a direct expansion type multi-box refrigeration system, the compressor is set up to cycle on and off by the_______.

  A.pressurestat B.high pressure cutout C.solenoid valve D.low pressure cutout switch

  查看最佳答案

• When we stay at a room in a house with central air-conditioning system in summer, we should set the thermostat to a higher level in ______.

  查看最佳答案