出自:Oracle认证

Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 
A: You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B: You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C: You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D: You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation？（）
A:You must configure block change tracking file
B:You must have first level 1 backups for RMAN to restore blocks
C:You must ensure that the SALES database is mounted or open
D:You must have full or level 0 backups for RMAN to restore blocks
E:You must take the tools01.dbf data file offline before you start a block media recovery
Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）  
A: FREE_SPACE indicates only the space that is currently unallocated.
B: ALLOCATED_SPACE indicates only the space currently allocated and in use.
C: FREE_SPACE indicates only the space that is currently allocated and available for reuse.
D: ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
E: FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.
When you use WebLogic Management Pack EE, which three operations are enabled compared to managing WebLogic Server only through web console?（）
A:management of many WebLogic Server Domains from a single web console
B:tracking changes in the configuration of WebLogic Domain
C:automation of provisioning process in the new environment
D:checking compliance with the licenses that a customer has
E:visual creation of JDBC DataSource object to Oracle RAC
You work as a database administrator for Certkiller .com. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）
A:Enable instance failover
B:Configure shared server
C:Enable database failover
D:Enable connect-time failover
E:Enable Transparent Application Failover （TAF）
You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10. You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You executed the following RMAN commands: RMAN> CONNECT CATALOG rco11/password@catdb RMAN> IMPORT CATALOG rcat10/oracle@inst1; What happens when you execute the above commands?（）
A:They deregister all databases registered in the RCAT10 catalog.
B:They import metadata for all registered databases in the RCAT10 database.
C:They register all the RCAT10-catalog registered databases in the RCO11 catalog.
D:They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog.
View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
A: The PRIMARY KEY is created along with a new index.
B: The PRIMARY KEY is created and it would use an existing unique index.
C: The PRIMARY KEY would be created in a disabled state because it is using an existing index.
D: The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.
An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command: SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.Which is the most efficient method of performing this task?（）
A:disabling the index
B:making the index invisible
C:making the index unusable
D:using the MONITORING USAGE clause for the index
While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges？ Which two commands would you use to resolve this error？（）
A: GRANT dba TO dbmgr；
B: GRANT connect TO dbmgr；
C: GRANT resource TO dbmgr；
D: GRANT hs_admin_role TO dmbgr；
E: GRANT manage scheduler TO dbmgr；
Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）
A:You can perform online whole database backups.
B:You can performofflinewhole database backups.
C:You cannot perform schema-level export/import operations.
D:You can perform the backup of only the SYSTEM tablespace when the database is open.
A customer claims that while redeploying a web application in the production system all their  customers are having to log in again. What do you recommend? （）
A:Sessions can't be preserved when redeploying applications. The customer needs to consider redeployment during late nights when the traffic is low.  
B:Change the flag responsible for the development mode of their environment. In the production mode, all sessions are preserved while redeploying application.  
C:Change Hotspot to JRockit. Sessions can't be preserved on HotSpot when redeploying application. 
D:Use flag -version when redeploying the application. This will switch on the Side By Side deployment feature and preserve existing sessions.
E:Open a service request with Oracle Support. This is unexpected behavior. Sessions are  preserved without any extra settings.
View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?（）
A:The text alert log file will be available in Diag Trace
B:A copy alert log file will be kept in Diag Incident for every incident.
C:The XML version of the alert log file will be available in Diag Trace.
D:An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.
View the Exhibit and examine the initialization parameter settings. Which three initialization parameters are to be set manually as they are not automatically tuned（）
A:LOG_BUFFER
B:SORT_AREA_SIZE
C:JAVA_POOL_SIZE
D:STREAMS_POOL_SIZE
E:DB_16K_CACHE_SIZE
F:DB_KEEP_CACHE_SIZE
Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）
A: Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.
B: Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
C: Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
D: Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）
A:UPDATE TABLE
B:CREATE CLUSTER
C:TRUNCATE TABLE
D:ALTER TABLE MOVE
E:INSERT INTO···VALUES
F:ALTER TABLE···DROP COLUMN
G:ALTER TABLE···DROP PARTITION
Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?（）
A:17000.00
B:17000*****
C:****170.00
D:**17000.00
E:an error statement
our database is in the MOUNT state and you execute the following command to open it：  ALTER DATABASE OPEN  What two actions are performed as a result of this command？（）
A:All control files are opened.
B:All redo log files are opened
C:The password file is opened.
D:The parameter file is opened.
E:All online data files are opened.
Examine the following scenario： The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host， using the Recovery Manager （RMAN） duplicate command as follows：   RMAN> RUN { ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK；  DUPLICATE TARGET DATABASE TO auxdb； }   Which statement is true about the duplicate database in this scenario？（）  
A: It contains data till the last backup
B: It contains all data from target database until the current time
C: It contains all data from only the committed transactions in the target database
D: It contains all data except that which is used by the transactions in the current online redo file of target database
Which two statements complete a transaction?（）
A:DELETE employees;
B:DESCRIBE employees;
C:ROLLBACK TO SAVEPOINT C;
D:GRANT SELECT ON employees TO SCOTT;
E:ALTER TABLE employees   SET UNUSED COLUMN sal;
F:Select MAX(sal)   FROM employees   WHERE department_id = 20;
DRAG DROP Click the Task button.
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  
A: Drop the table.
B: Partition the table.
C: Truncate the table.
D: Add a column to the table.
E: Rename a column in the table.
The Log Writer （LGWR） process reads information from the （）and writes it to the online logs.
A:large pool
B:shared pool
C:data buffer cache
D:redo log buffer
E:data dictionary cache
Given: Which four code fragments, inserted independently at line 7, will compile?（）
A:public void m1() { }
B:protected void m1() { }
C:private void m1() { }
D:void m2() { }
E:public void m2() { }
F:protected void m2() { }
G:private void m2() { }
Which two RMAN commands initiate a resynchronization of the recovery catalog with the target database control file？（）
A:COPY
B:BACKUP
C:CHANGE
D:DELETE
E:CATALOG
You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）
A:Oracle Management Agent
B:Enterprise Manager with Grid Control
C:Enterprise Manager with Database Control
D:Operating System Socket for incoming requests
E:Real Application Cluster （RAC） with three instances
F:Enterprise Manager with Generic Database Management
You plan to use static database registration for a new listener when you create it. What could be the two reasons for this？（）
A:More than one database is to be registered with the listener.
B:The users will connect the database by using the host naming method.
C:The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D:The database that is to be registered with the listener is configured in shared server mode.
E:The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
Given the command line java Pass2 and： What is the result？ （）
A: doStuff x = 6 main x = 6
B: Compilation fails.
C: doStuff x = 6 main x = 7
D: An exception is thrown at runtime.
E: doStuff x = 7 main x = 6
F: doStuff x = 7 main x = 7
Given: What is the result when method testIfA is invoked？（）
A:True
B:Not true
C:An exception is thrown at runtime.
D:Compilation fails because of an error at line 12.
E:Compilation fails because of an error at line 19.
Which two statements are true?（）
A:It is possible for more than two threads to deadlock at once.
B:The JVM implementation guarantees that multiple threads cannot enter into a deadlocked state.
C:Deadlocked threads release once their sleep() method's sleep duration has expired.
D:Deadlocking can occur only when the wait(), notify(), and notifyAll() methods are used incorrectly.
E:It is possible for a single-threaded application to deadlock if synchronized blocks are used incorrectly.
F:If a piece of code is capable of deadlocking, you cannot eliminate the possibility of deadlocking by inserting invocations of Thread.yield().
After you back up /export using a file system snapshot， and you have removed the snapshot， you also need to remove the backing store. If the snapshot was created with：  # mkdir /var/tmp/backup-snaps  # fssnap -o  bs=/var/tmp/backup-snaps /export   Which file do you need to remove？ （）
A:A
B:B
C:C
D:D
首页 <上一页 102 103 104 105 106 下一页> 尾页