出自:Oracle认证

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'; To which disks in the disk group will the new value be applicable?（）
A:all disks in the disk group
B:all disks that are currently in OFFLINE mode
C:all disks that are not currently in OFFLINE mode
D:all disks in the disk group only if all of them are ONLINE
View the Exhibit to examine the error that occurred during the database startup. You opened an RMAN sessionfor the database. To repair the failure， you executed the following command as the first RMAN command：RMAN>REPAIR FAILURE； Which statement describes the consequence of this command（）
A:The command performs the recovery and closes the failure.
B:The command only displays the advice and the RMAN script required for recovery.
C:The command executes the RMAN script to repair the failure and remove the entry from the AutomaticDiagnostic Repository （ADR）.
D:The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command
以下关于数据库文件的说法正确的是（）
A:数据库是由数据文件构成的，其它文件是辅助文件
B:数据库中的表，索引以及日志信息都是以数据的形式存储在数据文件中的
C:在线重做日志文件与归档日志文件的区别是：前者在内存中，后者在外存上
D:回滚段是建立在重做日志文件基础之上的，用于存储回滚事务信息。
E:数据块的大小一旦确定，就不能更改了，除非重新设定数据库
Which two statements are true regarding the WebLogic domain?（）
A:A WebLogic domain can have more than one Administration server.
B:A WebLogic domain has at least one WebLogic server.
C:A WebLogic domain can have at the most one cluster.  
D:A WebLogic domain can cross multiple physical machines.  
E:Each WebLogic domain is associated with a different Node Manager.
Given： What is the result？（）
A:1
B:2
C:12
D:Compilation fails.
E:No output is produced.
Which of the following statements is NOT true about RMAN？（）
A:It improves usability by enabling you to reuse the scripts to perform recovery operations.
B:It detects block corruption while restoration and recovery operations.
C:It enables you to perform block media recovery.
D:It is capable to recover through unrecoverable operations， with only full database backups.
You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）
A: One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.
B: One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.
C: One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.
D: One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.
Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.（）
A: Backup retention policy
B: Default backup device type
C: Default destinations for backups
D: Multiple backup device types for single backup
E: Default section size for backups
Why would you use WebLogic Diagnostics Framework （WLDF） instead of Oracle Enterprise Manager （OEM） （）
A: WLDF has better performance than OEM 
B: my organization already has a solution for unified management and monitoring； we need to supplement that with some specific WLS-related capabilities
C: OEM is not certified with latest version of WLS
D: OEM is really focused on the database tier， is not meant to address JEE management and monitoring
Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）
A:INSERT 
B:SELECT 
C:UPDATE 
D:DELETE
下面不属于Oracle 10g产品系列的是（）。
A:Oracle数据库10g标准版
B:Oracle数据库10g企业版
C:Oracle数据库10g网络版
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）
A:It is the time period after which the undo data becomes obsolete.
B:It is the time period after which the committed undo data would be transferred to a temporary tablespace.
C:It is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.
D:It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
Which two statements about sequences are true?（）
A:You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
B:You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
C:You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
D:You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
E:If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
F:You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
What is necessary for your query on an existing view to execute successfully? （）
A:The underlying tables must have data.
B:You need SELECT privileges on the view.
C:The underlying tables must be in the same schema.
D:You need SELECT privileges only on the underlying tables.
Given Which two statements are true？（）
A:Foo.beta（） is a valid invocation of beta（）.
B:Foo.alpha（） is a valid invocation of alpha（）.
C:Method beta（） can directly call method alpha（）.
D:Method alpha（） can directly call method beta（）.
Following a server crash, the automatic recovery of InnoDB fails. How would you begin to manually repair the InnoDB tables?（）
A:Start the server with the – innodb_recover_options option set to FORCE
B:Start the server with the – innodb_force_recovery option set to a non-zero value
C:Start the server as usual, and then execute the REPAIR TABLE command
D:Start the server as usual, and then execute the CHECK TABLE command
当需要为实例设置并发会话的最大数量，需要设置（）初始化参数。
A:DBA_MAX_SESSIONS
B:LICENSE_MAX_SESSIONS
C:MAX_SESSIONS
D:CONNECT_MAX_SESSIONS
You are creating a tabular report for the sales department with a department break group. You need to ensure that if al least six sales records will not fit at the button of a page, the group will start on the next page. Which printing frame property would you alter to achieve these results?（）
A:Source 
B:Print direction 
C:Maximum records per page 
D:Minimum Widow records 
E:Column mode
Which NLS parameter directly governs linguistic searches？（）
A: NLS_SEARCH_L
B: NLS_SORT
C: NLS_SEARCH
D: NLS_SORT_L
E: None of the above
Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?（）
A:SELECT TO_CHAR(SYSDATE,'yyyy')   FROM dual;
B:SELECT TO_DATE(SYSDATE,'yyyy')   FROM dual;
C:SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY')   FROM dual;
D:SELECT DECODE(SUBSTR(SYSDATE, 8), 'year')   FROM dual;
E:SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy')   FROM dual;
Given: What is the result?（）
A:6
B:7
C:10
D:11
E:Compilation fails.
F:An exception is thrown at runtime.
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）
A:Use the DESCRIBE command on the EMP_DEPT_VU view.
B:Use the DEFINE VIEW command on the EMP_DEPT_VU view.
C:Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.
D:Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E:Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F:Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
After the recovery is complete， which command should you execute？（）
A:ALTER DATABASE OPEN；
B:ALTER DATABASE CLEAR LOGFILE；
C:ALTER DATABASE OPEN RESETLOGS；
D:ALTER DATABASE OPEN NORESETLOGS；
Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)
A:As ASM instance mounts an ASM control file
B:An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C:Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
D:An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
Which three statements are true about windows？（） 
A: Only one window can be open at any given time
B: Consumer groups are associated with windows
C: Windows work with job classes to control resource allocation
D: The database service name must be provided during windows creation
E: Windows can automatically start job or change resource allocation among jobs for various time periods.
In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this: 1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow?（） (Choose two.)
A:2, 6, 4, 5, 3
B:1, 2, 4, 5, 3, 6
C:1, 2, 4, 6, 3
D:1, 2, 7, 5, 3, 6
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it.  What action is required for dependent objects when you perform online table redefinition？（）  
A: The dependent materialized view should have a complete refresh performed after the online table redefinition process.
B: Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
C: Referential integrity constraints must be manually enabled after the online table redefinition process.
D: The materialized log should be dropped before the online table redefinition process.
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?（）
A:The two statements produce identical results.
B:The second statement returns a syntax error.
C:There is no need to specify DESC because the results are sorted in descending order by default.
D:The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
Click the Exhibit button Which two statements are true if a NullPointerException is thrown on line 3 of class C？（）
A:The application will crash.
B:The code on line 29 will be executed.
C:The code on line 5 of class A will execute.
D:The code on line 5 of class B will execute.
E:The exception will be propagated back to line 27.
Which statement describes the effect of the execution of the above PL/SQL block?（）
A:The plan baselines are verified with the SQL profiles.
B:All fixed plan baselines are converted into nonfixed plan baselines.
C:All the nonaccepted SQL profiles are accepted into the plan baseline.
D:The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.
首页 <上一页 99 100 101 102 103 下一页> 尾页