出自:Oracle认证

You are working in an online transaction processing （OLTP） environment. You used the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command， the System Change Number （SCN） was 663571. After flashing back the CUSTOMERS table， you realize that the table is not in the correct state and the resultant changes are not what you had desired. So， you need to reverse the effects of the FLASHBACK TABLE command while ensuring that：  a） No other user data in the database is affected.  b） The operation takes the minimum possible time.  Which option would you choose？（）
A:use the ROLLBACK command with SCN 663571
B:perform Flashback Transaction Query with SCN 663571
C:execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
D:execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command： SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno； SCOTT has opened another session to work with the database instance.  Which three operations would waitwhen issued in SCOTT’s second session（）
A:LOCK TABLE emp IN SHARE MODE；
B:LOCK TABLE emp IN EXCLUSIVE MODE；
C:UPDATE emp SET sal=sal*1.2 WHERE job=ANAGER？UPDATE emp SET sal=sal*1.2 WHERE job=？ANAGER？
D:INSERT INTO emp（empno，ename） VALUES （1289，’Harry’）；
E:SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno
Which two commands never trigger an implicit rebalancing within the disk group？（） 
A: ALTER DISKGROUP misc MOUNT
B: ALTER DISKGROUP misc DROP DISK misc2
C: ALTER DISKGROUP misc CHECK ALL NOREPAIR
D: ALTER DISKGROUP misc RESIZE ALL SIZE 1023m
E: ALTER DISKGROUP dgroupA ADD DISK ’/devices/A*’
You plan to configure the new Oracle Database 11g installation by performing these tasks： - Use Automatic Storage Management （ASM） as the storage option.  - Use Oracle Enterprise Manager Database Control to manage the database.  - Provide the same password for SYS， SYSTEM， SYSMAN， and DBSNMP accounts during theinstallation. - Configure the database to send email notifications.  Some tools available to you for installation are：  1：Oracle Universal Installer （OUI）  2：Database Configuration Assistant （DBCA）  3：Database Upgrade Assistant （DBUA）  4：Oracle Net Configuration Assistant  Which tools would you use for this installation（）
A:2
B:3
C:1 and 2
D:3 and 4
E:1，2，and 4
Which statement is true regarding RMAN components？（）
A:Each target database requires its own recover catalog. 
B:RMAN scripts can be stored in the recovery catalog or the target control file. 
C:A channel is a stream of data to a device type and corresponds to one server session. 
D:The RMAN executable interprets sever session commands and establishes connections to the target database.
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
A:Redo logs
B:Control file
C:The latest backup of only the damaged data file
D:The latest backup of all the data file in the USERS tablespace
E:Temporary files of temporary tablespace
F:Archive Logs since the latest backup to point of failure
Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（）
A:Both source and target database must be the same character set
B:Both source and target database must have the same endian format
C:The COMPATIBLE parameter must be the same in the source and target databases.
D:The minimum compatibility level for both the source and target database must be 10.0.0.
E:All read-only and offline data files that belong to the tablespace to be transported must be platform aware.
Which three scenarios are true about Domains?（）
A:Domains can be created using the Configuration Wizard.
B:Domains can be created using WLST.  
C:Domain configuration files are located in the WebLogic home directory.
D:Domains can be created based on a domain template.
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?（）
A:The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
B:The optimizer can re optimize a query only once using cardinality feedback.
C:The optimizer enables monitoring for cardinality feedback after the first execution of a query.
D:The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
E:After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
You work as a database administrator for Certkiller .com. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle Software to take care of all basic settings to optimize the database performance.  Which method would you use to achieve this objective？（）
A:A
B:B
C:C
D:D
E:E
Why should you back up a duplicated tablespace after a TSPITR is complete？（）  
A: The tablespace cannot be duplicated or restored to any point in time after the duplication. 
B: The tablespace cannot be duplicated or restored to the point in time before the duplication. 
C: The entire database cannot be restored after a TSPITR， so a backup is required.
D: You cannot bring the tablespace online until its been backed up.
E: There is no requirement to do so， as RMAN will back up the tablespace after the TSPITR.
Which three functions are performed by the SQL Tuning Advisor？（） 
A: Building the SQL profile
B: Recommending optimization of materialized views
C: Checking query objects for missing and stale statistics
D: Recommending bitmap， function-based， and B-tree indexes
E: Recommending restructuring SQL queries that are using bad plans
Which three statements about subqueries are true? （）
A:A single row subquery can retrieve only one column and one row.
B:A single row subquery can retrieve only one row but many columns.
C:A multiple row subquery can retrieve multiple rows and multiple columns.
D:A multiple row subquery can be compared using the ">" operator.
E:A single row subquery can use the IN operator.
F:A multiple row subquery can use the "=" operator.
You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0;  What would be the result of this command？（）
A:The rebalancing of the disk group would be stopped.
B:The rebalancing of the disk group would be completed as fast as possible.
C:The command would result in an error because the value of POWER cannot be 0.
D:The rebalancing of the disk group would be completed without affecting the disk group DG3. 
E:The command would result in an error because the disk groups cannot be manually rebalanced.
Which WebLogic edition bundles JRockit Real Time?（）
A:WebLogic Server Standard Edition
B:WebLogic Server Enterprise Edition
C:WebLogic Server Suite
D:WebLogic Server Grid Edition
E:WebLogic Server Cloud Edition
What are the two different types of database duplication？（）
A: Active
B: Passive
C: Online
D: Backup-based
E: Failure driven
You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（）
A:A
B:B
C:C
D:D
Your database is in manual archive mode. Your online redo log groups are configured as follows： You discover that DISK 3 has encountered a media failure that has resulted in a loss of all the multiplexed copies of online redo log files.   You decide to delete the REDO01C.LOG， REDO02C.LOG， and REDO3C.LOG files to prevent the LGWR background process from attempting to access these files. When you query the V$LOG dynamic view， you receive the following output： Which sequence of statements should you use to drop the missing online redo log files from the database？（）        1.  ALTER DATABASE DROP LOGFILE MEMBER ’E:///REDO01C.LOG’；        2.  ALTER SYSTEM SWITCH LOGFILE；        3.  ALTER DATABASE DROP LOGFILE MEMBER ’E:///REDO03C.LOG’；        4.  ALTER SYSTEM ARCHIVE LOG GROUP 3；        5.  ALTER DATABASE DROP LOGFILE MEMBER ’E:///REDO02C.LOG’；        6.  ALTER SYSTEM ARCHIVE LOG GROUP 1；
A:  5， 3， 2， and 1
B:  1， 5， 3， and 2
C:  4， 3， 2， 5， 1， and 6
D:  5， 4， 3， 2， 6， and 1
Which correctly describes the tiers of the Oracle Workflow architecture?（）
A:Oracle Database tier and Application server tier only
B:Oracle Database tier, Application server tier, and End-user client tier only
C:Oracle Database tier, Application server tier, and Development client tier only
D:Oracle Database tier, Application server tier, Development client tier, and End-user client tier
假设ABC中的所有列均为字符数据类型，A列的默认值为“VA”，同时还有B列和C列，则执行以下SQL语句：INSERT ABC（A，C）VALUES（‘V’，‘NULL’）后，下列的说法哪一项正确（）。
A:插入B列的值为字符‘NULL’
B:插入A列的值为字符VA
C:插入B列的值空值
D:插入C列的值空值
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）
A:A base catalog exists
B:The recovery catalog is empty
C:The base recovery catalog must be dropped
D:A target database is registered in the recovery catalog
Exhibit One the evening of April 22， you are working on a database created using Oracle Database 10g. This database operates in the ARCHIVELOG mode. You discover that you need crucial data that was dropped from the database at 8：00 a.m. No full backup has been taken after April 15.  What would you do？（）
A:recover the database until April 10
B:recover the database until April 15
C:recover the database until 22 7：59 a.m.
D:recovery is not possible； manually re-create the object
XYZ Corp. is in the business of manufacturing cosmetics. It obtains and pays for raw materials.Which business flow in Oracle E-Business Suite would map to the above activities of obtainingand paying for raw materials?（）
A:Order to Cash
B:Procure to Pay
C:Forecast to Plan
D:Demand to Build
E:Contract to Renewal
比较非归档日志模式和归档日志模式的区别。
The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock.  Which two statements are true regarding the session ofSCOTT in this scenario（）
A:The session is terminated after receiving the error and JIM can continue with his transaction.
B:SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
C:The session is rolled back after receiving the error and JIM can continue with his transaction.
D:SCOTT has to reexecute the last command in the transaction after he commits the transaction.
You receive the following error：   ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit   Identify the reason for receiving the above error message？（）
A: The sort area is very small.
B: There is no more space in the Undo tablespace.
C: The flash recovery area is full.
D: The online redo log file is full.
You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.（） (Choose two.)
A:The data file backup is done with multiple channels
B:The data files is in the read-write mode after being backed up in the read only mode
C:The backup was taken after the data files was taken offline-normal or is in the read only mode
D:The data file backup complies with the back retention policy and the backup duplexing feature
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）
A:Database replay
B:SQL Tuning Advisor
C:SQL Access Advisor
D:SQL Performance Analyzer
E:Automatic Workload Repository compare reports
Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method.You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）
A:Perform Export before TSPITR and Import after TSPITR
B:Move objects to another schema that has the same tablespace assigned
C:Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
D:Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
Click the Exhibit button. Given： Which statement is true if a TestException is thrown on line 3 of class B？（）
A:Line 33 must be called within a try block.
B:The exception thrown by method 1 in class A is not required to be caught.
C:The method declared on line 31 must be declared to throw a runtime exception.
D:On line 5 of class A,the call to method 2 of class B does not need to be placed in a try catch block.
首页 <上一页 150 151 152 153 154 下一页> 尾页