出自:Oracle认证

You notice that a job in a chain has not completed on a nonconstrained RAC database. Which of these are valid reasons why that might occur？（）  
A: The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.
B: The job affinity is to a service and one node in that service is unavailable.
C: The job affinity is to an instance and that instance is unavailable.
D: There is no service affinity.
E: None of the above.
You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error.   SQL> startup ORACLE instance started.  Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted.  ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3  SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1：  ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1： ，，/oracle01/oradata/orcl/redo02a.log   What steps must you take to resolve the error？（） a. Issue the recover database redo logs command.  b. Issue the Startup Mount command to mount the database.  c. Restore the last full database backup.  d. Perform a point-in-time recovery， applying all archived redo logs that are available.  e. Restore all archived redo logs generated during and after the last full database backup.  f. Open the database using the alter database open resetlogs command.  g. Issue the alter database open command.
A:b， a， f
B:e， b， a， f
C:e， b， a， g
D:b， a， g
E:c， e， b， d， f
Assume that you would like to clone an existing WebLogic Domain and enable some  customizations. What scenario would you choose?（）
A:In the Enterprise Manager, find the domain to be cloned. Choose "Clone WebLogic Domain" from the context menu. In the graphical wizard, customize and extend the domain if needed. These steps will only clone only the domain configuration. Binaries with deployments are needed  to be cloned by operation on the file system.  
B:In the Enterprise Manager, find the domain to be cloned. Choose "Clone WebLogic Domain"  from the context menu. In the graphical wizard, customize the domain. These steps clone the  binaries and domain configuration. If the extension is needed, perform it after cloning in the  WebLogic web-based console. 
C:In the Enterprise Manager, find the domain to be cloned. Choose "Clone WebLogic Domain" from the context menu. In the graphical wizard, customize and extend the domain if it is needed. These steps clone the binaries and domain configuration.  
D:In the Enterprise Manager, find the domain to be cloned. Choose "Clone WebLogic Domain"  from the context menu. These steps clone the binaries and domain configuration. If the customization or extension is needed, complete that after cloning in the WebLogic web-based console.  
E:In the file system, copy the domain structure of the configuration directory and paste it in the new location. Modify configuration files for address and port. If further customization is needed, open the WebLogic web-based console and perform these modifications.
You are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment variable. Which command will you issue？（）  
A: setenv ORA_SDTZ ’DB_TZ’
B: setenv ORA_SDTZ ’+10：00’
C: setenv ORA_SDTZ ’OS-TZ’
D: setenv ORA_SDTZ ’Europe/London’
In which scenario will you create a hash cluster？（）
A: when you want the data to be returned automatically in chronological order
B: if the application uses queries joining tables only occasionally
C: if the queries against the clustered table use the equality operator （=） to retrieve the desired row
D: if the full table scan is executed often on only one of the clustered tables
In a Java EE messaging application, one MDB is consuming a lot of memory at high traffic.    What configuration should you use to prevent possible out-of-memory error at high traffic and at the same time not losing messages?（）
A:Configure a Work Manager for the MDB with a Maximum Thread Constraint.
B:Configure a Work Manager for the MDB with a Minimum Thread Constraint.  
C:Configure a Work Manager for the MDB with a Maximum Thread Constraint and a Capacity  Constraint. 
D:Configure a Work Manager for the MDB with a Minimum Thread Constraint and a Capacity Constraint. 
E:Configure a Work Manager for the MDB with both a Maximum Thread Constraint and Minimum Thread Constraint.
In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：  CONFIGURE RETENTION POLICY TO NONE;  What would be the impact of this setting？（）
A:The retention policy is cleared.
B:RMAN does not consider any backup as obsolete.
C:The retention policy is set to its default setting of redundancy 1.
D:The retention policy is set to its default setting of recovery window 7.
For which two actions can you use the TO_DATE function? （）
A:convert any date literal to a date
B:convert any numeric literal to a date
C:convert any date to a character literal
D:format 'January 10 1999' for input
E:format '10-JAN-99' to 'January 10 1999'
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery？（）  
A: You will need to open the database with the resetlogs command.
B: All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.
C: You will use the resetlogs version of the create controlfile command.
D: You will use the noresetlogs version of the create controlfile command.
E: You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
How can an Oracle WebLogic cluster’s capacity be increased ？（）
A: by adding server instances to the cluster on an existing machine
B: by adding machines to host server for more clustered instances
C: by adding machines to the cluster to host the incremental server instances
D: by adding node managers to an existing machine
Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）
A:when ASM disk goes offline
B:when one or more ASM files are dropped
C:when some disks in a disk group are offline
D:when some disks in a failure group for a disk group are rebalancing
Observe the structure of the table employees: The table contains 8475 records. One of the employees wants to know the names of all employees of the company. For this, he fires the following query: SELECT * FROM EMPLOYEES ORDER BY emp_fname; Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation. Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?（）
A:Rollback segment
B:Temporary segment
C:Data segment
D:Index segment
Which command is used to configure RMAN to perform a compressed backup for every backup executed？（）
A: BACKUP AS COMPRESSED BACKUPSET DATABASE
B: BACKUP AS COMPRESSED COPY OF DATABASE
C: CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
D: CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS 
E: BACKUP DATABASE COMPRESS
If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string， what happens to disks that are already a part of the same or another disk group？（）  
A: The command fails unless you specify the FORCE option.
B: The command fails unless you specify the REUSE option.
C: The command must be reissued with a more specific discovery string.
D: The other disks， already part of the disk group，are ignored.
View the Exhibit to examine the details for an incident. Which statement is true regarding the status of the incident（）
A:The DBA is working on the incident and prefers that the incident be kept in the ADR.
B:The incident is now in the Done state and the ADR can select the incident to be purged.
C:The incident has been newly created and is in the process of collecting diagnostic information.
D:The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport.
Which two code fragments are most likely to cause a StackOverflowError?（）
A:
B:
C:
D:
E:
F:
You want to set the following initialization parameters for your database instance：   LOG_ARCHIVE_DEST_1 = ’LOCATION=/disk1/arch’ LOG_ARCHIVE_DEST_2 = ’LOCATION=/disk2/arch’ LOG_ARCHIVE_DEST_3 = ’LOACTION=/disk3/arch’ LOG_ARCHIVE_DEST_4 = ’LOCATION=/disk4/arch MANDATORY’   Identify the statement that correctly describes this setting.（）  
A: The MANDATORY location must be a flash recovery area.
B: The optional destinations may not use the flash recovery area.
C: This setting is not allowed because the first destination is not set as MANDATORY.
D: The online redo log file is not allowed to be overwritten if the archived log cannot be created in the fourth destination.
DRAG DROP Click the Task button.
Which two chart base types can you select using the Chart Wizard?（）
A:Line 
B:Column 
C:Bubble 
D:Flowchart 
E:OHLC candle stock
Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? （　）
A:SUM（start_date）
B:AVG（start_date）
C:COUNT（start_date）
D:AVG（start_date，end_date）
E:MIN（start_date）
F:MAXIMUM（start_date）
You executed the following command to perform a backup of the USERS tablespace：SQL> ALTER TABLESPACE users BEGIN BACKUP；ALTER TABLESPACE users BEGIN BACKUP* ERROR at line 1： ORA-01123： cannot start online backup； media recovery not enabled What could be the reason for this error（）
A:The MTTR Advisor is disabled.
B:The database is in NOARCHIVELOG mode.
C:The tablespace is already in backup mode.
D:The Flash Recovery Area is not configured
（）是Apache的一个开源子项目，是一种实现数据映射的轻量级框架，减少了应用开发的编码数量。
A:iBatis
B:Spring
C:Hibernate
D:JDBC
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.  Which option of IMPDP would you use to accomplish this task（）
A:FULL
B:SCHEMAS
C:TRANSFORM
D:REMAP_SCHEMA
E:REMAP_TABLESPACE
Which Oracle background process is responsible for providing information about the instance name associated with the service handlers and services to the listener？（）
A:PMON
B:SMON
C:LGWR
D:CKRT
INSERT，UPDATE，DELETE等命令属于下列哪类命令（）
A:DCL
B:DDL
C:DML
D:DQL
E:以上所述都不正确
Evaluate these two SQL statements: 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.
View the Exhibit to examine the output for the CROSSCHECK BACKUP command.  Which statement is trueabout the output of the command（）
A:The backup piece is expired as the new backup is available.
B:The backup piece is expired because the operating-system file was not found.
C:The backup piece is expired because the retention period for the backup has expired.
D:The backup piece is expired because the backup set to which it belongs is not complete
Given： When line 11 is reached， how many objects are eligible for garbage collection？（）
A:0
B:1
C:2
D:3
You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）
A:to minimize plan regression due to the use of a new optimizer version
B:to completely avoid the use of new plans generated by a new optimizer version
C:to prevent plan capturing when the SQL statement is executed after the database upgrade
D:to keep the plan in the plan history so that it can be used when the older version of the optimizer is used
What are the two advantages of RMAN Block Media Recovery （BMR） over file/x7flevel recovery？（）
A:BMR lowers the mean time to recover （MTTR）.
B:BMR supports point­in­time recovery of individual data blocks.
C:BMR enables you to use incremental backups for block recovery.
D:BMR enables recovery even when the database is not mounted or open.
E:BMR enables you to use proxy backups to perform block media recovery.
F:BMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
首页 <上一页 103 104 105 106 107 下一页> 尾页