出自:Oracle认证

Click the Exhibit button. Which statement is true about the classes and interfaces in the exhibit?（）
A:Compilation will succeed for all classes and interfaces.
B:Compilation of class C will fail because of an error in line 2.
C:Compilation of class C will fail because of an error in line 6.
D:Compilation of class AImpl will fail because of an error in line 2
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）
A:Alice only
B:Alice and Reena
C:Alice, Reena, and Timber
D:Sue, Alice, Reena, and Timber
如果希望在激活约束时不验证表中已有的数据是否满足约束的定义，那么可以使用下列哪个关键字？（）
A:disactive
B:validate
C:active
D:novalidate
Which two scenarios are NOT safe to replace a StringBuffer object with a StringBuilder object?（）
A:When using versions of Java technology earlier than 5.0.
B:When sharing a StringBuffer among multiple threads.
C:When using the java.io class StringBufferInputStream.
D:When you plan to reuse the StringBuffer to build more than one string.
Given: What is the result when the go（　） method is invoked?（）
A:00
B:0001
C:000120
D:00012021
E:Compilation fails.
F:An exception is thrown at runtime.
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?（）
A:issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B:issuing the ALTER SESSION ENABLE RESUMABLE; statement
C:modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D:issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement
DRAG DROP Click the Task button.
Using the command shown here， what time format must you specify to recover the database until a point-in-time？（）  SQL> RECOVER DATABASE UNTIL TIME ’’；
A:YYYY-DD-MM:HH24:SS:MI 
B:YYYY-DD-MM:HH24:SS:MM 
C:YYYY-MM-DD:HH24:MI:SS 
D:YYYY-DD-MM:SS:MI:HH24
A user is running a long update batch file. Many tables are updated and all the  statements are in one transaction. Before the process is finished， the user machine lost power. When the user calls you， what should you do as DBA？（）
A:A
B:B
C:C
D:D
Given: When the doSomething method is called, after which line does the Object created in line 5 become available for garbage collection?（）
A:Line 5
B:Line 6
C:Line 7
D:Line 8
E:Line 9
F:Line 10
Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）
A: The target database must be in NOARCHIVELOG mode.
B: No backup is required of the database before you perform a TSPITR.
C: You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.
D: If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.
E: If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup metadata information. You want to enable the reusable section of the control file to expand itself if the oldest record cannot be reused， and whenever a new record is added to the reusable section of the control file. Which value will you set for the CONTROL_FILE_RECORD_KEEP_TIME parameter？（）
A: Zero
B: One or more
C: NONE
D: DEFAULT
Your database is running in the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas.  What would you do？（）
A:modify the HASH_AREA_SIZE initialization parameter
B:modify the PGA_AGGREGATE_TARGET initialization parameter
C:modify the WORK_AREASIZE_POLICY initialization parameter
D:increase the value of the SGA_TARGET initialization parameter
E:increase the value of the SGA_MAX_SIZE initialization parameter
F:increase the value of the SORT_AREA_SIZE initialization parameter
View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command: SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（）
A:An Automatic Workload Repository snapshot has been taken recently.
B:The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
C:The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
D:The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but notthe threshold alerts related to instance metrics
Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough.What could be a solution to make tape streaming happen during the backup?（）
A:Configure backup optimization
B:Configure the channel to increase MAXOPENFILES
C:Configure the channel to increase the capacity with the RATE parameter
D:Configure the channel to adjust the tape buffer size with the BLKSIZE option
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）
A:It executes successfully and creates an UNDO tablespace in hr_pdb.
B:It falls and reports an error because there can be only one undo tablespace in a cdb.
C:It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.
D:It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.
E:It executes successfully but neither tablespace nor the data file is created.
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows: 1. Mount the CDB. 2. Close all the PDBs. 3. Open the database. 4. Apply the archive redo logs. 5. Restore the data file. 6. Take the SYSAUX tablespace offline. 7. Place the SYSAUX tablespace online. 8. Open all the PDBs with RESETLOGS. 9. Open the database with RESETLOGS. 10. Execute the command SHUTDOWN ABORT. Which option identifies the correct sequence to recover the SYSAUX tablespace?（）
A:6，5，4，7
B:10，1，2，5，8
C:10，1，2，5，4，9，8
D:10，1，5，8，10
You updated the resource plan directive for the resource consumer group， DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement：   SQL>EXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE  （PLAN => ’DSS_PLAN’，   GROUP_OR_SUBPLAN => ’DSS_USERS’，   NEW_CPU_P1 => 80，   NEW_SWITCH_GROUP => ’CANCEL_SQL’，   NEW_SWITCH_ESTIMATE => TRUE，   NEW_SWITCH_TIME => 600）； A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds？（）  
A: The session is killed before starting the operation.
B: The session generates an error before starting the operation.
C: The session switches to the CANCEL_SQL resource consumer group before starting the operation.
D: The session hangs before starting the operation.
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）
A:Cursor cache
B:Stored outline
C:SQL Tuning Set
D:Automatic Workload Repository (AWR) snapshots
In which situation would you use the Oracle Shared Server configuration？（）
A:when performing export and import using Oracle Data Pump
B:when performing backup and recovery operations using Oracle Recovery Manager
C:when performing batch processing and bulk loading operation in a data warehouse environment 
D:in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
DRAG DROP Click the Task button.
You recently created a database and configured the SPFILE with the following parameter settings to ensure that Oracle automatically adjusts the memory for the Program Global Area （PGA）：   SORT_AREA_SIZE = 150M   HASH_AREA_SIZE = 150M   BITMAP_MERGE_AREA_SIZE = 150M   CREATE_BITMAP_AREA_SIZE = 150M   WORKAREA_SIZE_POLICY = AUTO   You have not included the PGA_AGGREGATE_TARGET initialization parameter in the SPFILE and the System Global Area （SGA） is currently sized at 4G.   What is the total PGA memory allocated across all database server processes？（）  
A: 10M
B: 400M
C: 600M
D: 800M
You performed a backup of the flash recovery area by using the following command for the first time： RMAN> BACKUP RECOVERY AREA;  Which files in the flash recovery area are backed up？（）
A:flashback logs
B:current control file
C:control file autobackups
D:incremental backup sets
You have just configured the network interface on systemA . The following information is  From systemB， you test the network connectivity by sending ICMP ECHO_REQUEST packets to  systemA. The following message is displayed： no answer from systemA  What is most likely the problem？（）
A: The interface is not plumbed.
B: The interface is not configured.
C: The interface does not have valid routes configured.
D: The interface is not marked as
You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup？（）
A:ABORT
B:NORMAL
C:IMMEDIATE
D:TRANSACTIONAL
Given： Which three changes should be made to adapt this class to be used safely by multiple threads？（）
A:declare reset（） using the synchronized keyword
B:declare getName（） using the synchronized keyword
C:declare getCount（） using the synchronized keyword
D:declare the constructor using the synchronized keyword
E:declare increment（） using the synchronized keyword
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
A:You must have change tracking enabled in your database
B:Your database must be running in NOARCHIVELOG mode
C:To back up a tablespace, it must be in backup mode
D:To back up a tablespace, it must first be taken offline
Which statement about using RMAN stored scripts is true？（）  
A: To create and execute an RMAN stored script，you must use a recovery catalog.
B: When executing a stored script and a command fails，the remainder of the script is executed，and a message is written to the alert log file.
C: RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
D: When you execute a stored script，it always executes using the persistent channel settings previously set with the CONFIGURE command.
Oracle Fusion Middleware Control runs as：（）
A: a module in Oracle HTTP Server
B: a PL/SQL module in Oracle Database
C: an application in WebLogic Server Administration Server
D: an application in WebLogic Server Managed Server
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes？（）
A: SQL scripts
B: Recovery Manager （RMAN） script
C: Data Pump
D: SQL*Loader
E: Flashback database
首页 <上一页 35 36 37 38 39 下一页> 尾页