出自:Oracle认证

Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table：  ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES.While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
A: Drop and re-create the inbox.
B: Coalesce the ORDERS_IND index.
C: Coalesce the INDEXES tablespace.
D: Drop and re-create the ORDERS table.
E: Rebuild the index online and move it to another tablespace.
You want to take a complete database backup using RMAN. The backup should consist onlythe used blocks from your database. Which two statements are true about this backup operation？（） 
A: Backup compression should be enabled
B: Parallelism for the channel should be set to 2
C: All the files must be backed up as backup sets
D: The backup may be stored either on disk or on media with media manager
You issued the following commands to configure setting in RMAN; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
A:The backup will terminate because the FORMAT clause was not configured for the channel
B:It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C:It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D:It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
You are maintaining an OLTP database in Oracle10g. You find that the database is generating a large number of trace files. You decide to disable the trace files generated by the ARCn background process.  Which action will enable you to disable the trace files generated by the ARCn background process？（）  
A: Remove the LOG_ARCHIVE_DEST parameter from the init.ora file.
B: Set the value of the SQL_TRACE parameter to FALSE in the init.ora file.
C: Use the DBMS_MONITOR.SESSION_TRACE_DISABLE procedure.
D: Set the value of the LOG_ARCHIVE_TRACE initialization parameter to zero.
You issued the following statement：   SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1；   Which parameter is NOT overridden by using the above statement？（）  
A: the value of the NLS_LANGUAGE variable
B: the value of the NLS_TERRITORY variable
C: the value of the NLS_CURRENCY variable
D:the character encoding scheme used by the client application
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with one device each. In the parameter file of the production database， the following parameters have been specified：  DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting？（）
A: When a new log group is added， it would have one member in each disk group.
B: When a new log group is added， it would have two members in each disk group.
C: When a new tablespace is added， it would have one data file in each disk group.
D: When a new log file is added， it would have one member spread across the disk groups.
The DB_BLOCK_CHECKING initialization parameter is set to OFF. Which block checking would be performed？（）  
A: The Oracle database will perform block checking for the index blocks only
B: The Oracle database will not perform block checking for any of the data blocks
C: The Oracle database will perform block checking for the default permanent tablespace only
D: The Oracle database will perform block checking for the data blocks in all user tablespaces
E: The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
Which product should be used along with Oracle Enterprise Manager Packs for Fusion Middleware for end-to-end visibility ？（）
A: Oracle Data Masking Pack
B: Oracle Real Application Testing
C: Oracle Byte Code Instrumentation for Java （BCI4J）
D: Oracle Real User Expirience Insight （ORUEI）
Which statement is true regarding the INTERSECT operator?（）
A:It ignores NULL values 
B:Reversing the order of the intersected tables alters the result 
C:The names of columns in all SELECT statements must be identical 
D:The number of columns and data types must be identical for all SELECT statements in the query 
Given： What is the result？（）
A:6
B:7
C:10
D:11
E:Compilation fails
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）
A:generating the SQL profile
B:testing and accepting the SQL profile
C:generating a list of candidate SQLs for tuning
D:adding tuned SQL plans into the SQL plan baseline
E:tuning each SQL statement in the order of importance
F:generating baselines that include candidate SQLs for tuning
How can you configure High Availability for interacting with a non-Oracle database using WebLogic?（）
A:Configure multiple physical data sources and reuse the same JNDI name for each.
B:Use the "compatibility" option of Active GridLink to enable compatibility with non-Oracle  databases.
C:Configure a single physical data source for each node in a database cluster and wrap it using  Multi Data Source.
D:Configure a Data Source Group that contains a physical connection pool to each node in the  database cluster.
Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
A:mount the new disk group in the ASM instance
B:restart the ASM instance and the production database instance
C:register the new disk groups in the production database instance
D:restart the ASM instance without restarting the production database instance
E:include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
A:heap table
B:object table
C:external table
D:clustered table
E:global temporary table
F:index-organized table （IOT）
当需要在数据库运行时修改最大并发使用限制或者警告限制，可以使用如下（）语句。
A:ALTER SYSTEM
B:ATLER TABLE
C:ALTER VIEW
D:ALTER TRIGER
What type of backup is stored in a proprietary RMAN format？（）
A: Backup set
B: Image copy
C: Backup section
D: Backup group
Which two statements are true regarding the ORDER BY clause? （）
A:The sort is in ascending by order by default.
B:The sort is in descending order by default.
C:The ORDER BY clause must precede the WHERE clause.
D:The ORDER BY clause is executed on the client side.
E:The ORDER BY clause comes last in the SELECT statement.
F:The ORDER BY clause is executed first in the query execution.
Your alert log file has the following information： Tue May 25 17：43： 38 2004  ORA-00060： Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）
A:examine the trace file and kill the session that caused the deadlock
B:examine the trace file and kill both the sessions responsible for the deadlock
C:examine the trace file for details and ask the user who caused the deadlock to rollback the transaction
D:examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
E:examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
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;
Which statement is true when you run the SQL Tuning Advisor with limited scope？（）
A:Access path analysis is not performed for the SQL statements.
B:SQL structure analysis is not performed for the SQL statements.
C:SQL Profile recommendations are not generated for the SQL statements.
D:The staleness and absence of the statistics are not checked for the objects in the query supplied to the SQL Tuning Advisor.
Which three statements are true about Flashback Database?（）
A:Flashback logs are written sequentially, and are archived.
B:Flashback Database uses a restored control file to recover a database.
C:The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.
D:Flashback Database can recover a database to the state that it was in before a reset logs operation.
E:Flashback Database can recover a data file that was dropped during the span of time of the flashback.
F:Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
Which is an iSQL*Plus command?（）
A:INSERT
B:UPDATE
C:SELECT
D:DESCRIBE
E:DELETE
F:RENAME
Which of these is an available Oracle WebLogic Message Bridge attribute ？ （）
A: XA Enabled
B: Connection URL
C: Local JNDI name
D: Quality of Service
Click the Exhibit button. What is the result？（）
A:Line 26 prints "a" to System.out.
B:Line 26 prints "b" to System.out.
C:An exception is thrown at line 26 at runtime.
D:Compilation of class A will fail due to an error in line 6.
下列哪一个后台进程和对应的数据库组件能够保证即使用户对数据库所做的修改没有写入数据文件，也不会发生修改内容丢失的情况（）
A:DBWn与数据库缓冲区
B:LGWR与重做日志文件
C:CKPT与控制文件
D:ARCn与归档日志文件
You are maintaining an OLTP database in Oracle10g. You set the value of the LOG_ARCHIVE_TRACE parameter to zero. What is the impact of this setting？ （） 
A: The trace files will be disabled only for a specific session.
B: Tracing will be disabled for a client identifier.
C: Tracing will be disabled only for the ARCn process.
D: The SQL Trace facility will be disabled for the instance.
Your database block size is 4 KB. In this database， you are required to create a tablespace with a block size of 8 KB. Which is the prerequisite for creating this tablespace？（）
A: The parameter DB_CACHE_SIZE must be a multiple of 8.
B: The value of the parameter SGA_MAX_SIZE must be increased.
C: The tablespace must be created with a uniform extent size of 8 KB
D: The parameter DB_8K_CACHE_SIZE must be defined in the parameter file.
Given: Which two statements are true?（）
A:The output could be 8-1 7-2 8-2 7-1
B:The output could be 7-1 7-2 8-1 6-1
C:The output could be 8-1 7-1 7-2 8-2
D:The output could be 8-1 8-2 7-1 7-2
Exhibit： View the Exhibit.You have more than one table in the recycle bin having the same original name， DEPT2. You do not have any table with the nameDEPT2 in your schema. You executed the following command：PURGE TABLE dept2； Which statement is correct in this scenario？（）
A: All the tables having the same original name as DEPT2 will be purged from the recycle bin. 
B: The table with dropscn = 1928151 （oldest dropscn） will be purged from the recycle bin.
C: The table with dropscn = 1937123 （most recent dropscn） will be purged from the recycle bin.
D: None of the tables will be purged because there are multiple entries with the same original name in the recycle bin.
You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files， created in an earlier incarnation of the database，is true？（）
A: The archived redo log files will be overwritten.
B: The archived redo log files are deleted automatically.
C: The archived redo log files should be moved to some other location.
D: The archived redo log files are still maintained because the file names are unique.
首页 <上一页 94 95 96 97 98 下一页> 尾页