Oracle认证 - 自考题库

出自:Oracle认证

Which of the following methods can be used to detect block corruption？（）
A: ANALYZE operations
B: dbv
C: SQL queries that access the potentially corrupt block
D: RMAN
E: All of the above

If class Donkey is invoked twice, the first time without assertions enabled, and the second time with assertions enabled, what are the results?（）
A:no output
B:no output assert is on
C:assert is on
D:no output An AssertionError is thrown.
E:assert is on An AssertionError is thrown

You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option？（）
A:This operation resets the SCN for the database.
B:This operation creates a new incarnation of the database.
C:This operation moves all the redo log files to a different location.
D:This operation deletes the old redo log files and creates new redo log files.
E:This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

The following query will provide what information about transportable tablespaces for the current database？（） select d.platform_name "Source"， t.platform_name "Compatible Targets"， endian_format from v$transportable_platform t， v$database d where t.endian_format = （select endian_format from v$transportable_platform t， v$database d where d.platform_name = platform_name）；
A: The list of target platforms having the same endian format as the source database
B: The list of target platforms requiring endian conversion
C: The list of target platforms that will not require endian conversion
D: The list of all target platforms that can receive transportable tablespaces from the source database
E: None of the above

You work as a database administrator for Certkiller .com. You started the instance using theinit.orafile. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file. Which file is the appropriate way to perform this task？（）
A:Shut down the instance， copy the control file to the third location and open the database.
B:Abort the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
C:Copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile， restart the instance and open the database.
D:Shut down the instance， copy the control file to the third location， modify the CONTROL_FILES parameter in theinit.orafile and open the database.
E:Shut down the instance， startup in the mount state， copy the control file to the third location， modify the CONTROL_FILES parameter ininit.oraand open the database.

Which three are true regarding the use of outer joins?（）
A:You cannot use IN operator in a condition that involves an outerjoin.
B:You use (+) on both sides of the WHERE condition to perform an outerjoin.
C:You use (*) on both sides of the WHERE condition to perform an outerjoin.
D:You use an outerjoin to see only the rows that do not meet the join condition.
E:In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F:You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）
A:The standby database is protected against write operations.
B:The primary database is protected against write operations.
C:The primary database is protected against data loss and data divergence.
D:The standby database is protected against data loss and data divergence.

Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?（）
A:ADD DIRECTORY
B:DROP DISK
C:RESIZE DISK
D:REBALANCE
E:ADD FAILGROUP

At the end of the financial year， an accounts accumulation batch is run. This batch updates the company’s accounting records. During the batch run process， some incorrect entries were inserted into the ACCOUNT table. You identified the bug and immediately stopped the batch run process， but 3000 incorrect records were inserted into the ACCOUNT table before the batch process was stopped. You want to recover the table to the state it was at 11：50 P.M. Which flashback feature will you use？（）
A: Flashback Drop
B: Flashback Database
C: Flashback Table
D: Flashback Version Query

You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（）
A:Memory Advisor
B:Segment Advisor
C:SQL Tuning Advisor
D:SQL Access Advisor
E:Automatic Database Diagnostic Monitor （ADDM）

Using a bitmap structure to manage database object space has several benefits over using freelist structures. Which three are benefits of managing space using automatic-segment-space managed objects？（）
A:It readily responds to dynamic changes for concurrent access.
B:It improves performance and space utilization in a multiple-instance environment.
C:It requires fewer space related options then freelist managed structures.
D:It improves performance for SYSTEM tablespaces where a high degree of concurrency is required.

Which client requests to the database can be captured as a part of the workload capture？（）
A: flashback query
B: distributed transactions
C: logging in and logging out of sessions
D: all DDL statements having bind variables
E: direct path load of data from external files

Which two methods， inserted independently at line 17， correctly complete the Sales class？（）
A:double getSalesAmount（） { return 1230.45； }
B:public double getSalesAmount（） { return 1230.45； }
C:private double getSalesAmount（） { return 1230.45； }
D:protected double getSalesAmount（） { return 1230.45； }

View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table， and the constraint is not deferred. Which two statements are true in this scenario？（）
A:No index would be created or used in this case.
B:A unique index on the empno column would be created.
C:A CHECK constraint would be enforced on the empno column.
D:A NOT NULL constraint would be enforced on the empno column.
E:A bitmap unique index would be created on the empno column.

In your database，the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory （OID）. SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command：$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first？（）
A: authentication by password file
B: authentication by using certificates over SSL
C: authentication by using the Oracle Internet Directory
D: authentication by using the local OS of the database server

Which Oracle WebLogic Server feature would you recommend to your clients to enable a stand-alone message producer， or a group of producers acting as one with respect to the processing order ？（）
A: Connecting Factory
B: Message Bridge
C: Unit-of-Order
D: Store-and-Forward

Which two statements are true regarding the USING and ON clauses in table joins?（）
A:Both USING and ON clauses can be used for equijoins and nonequijoins
B:Amaximum of one pair of columns can be joined between two tables using the ON clause
C:The ON clause can be used to join tables on columns that have different names but compatible data types
D:The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause

Which backup option defines a user-defined name for a backup? （）
A:FORMAT
B:NAME
C:TAG
D:FORMAT U%

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）
A: Top SQL
B: snapshots
C: SQL Tuning sets
D: index access path
E: optimizer statistics
F: materialized view logs

在命令行中启动SQL*Plus，使用如下（）命令。
A:SQLPLUS
B:SQL*PLUS
C:SQL
D:SPLUS

Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run？（）
A: use DBMS_IJOB package
B: use Oracle Scheduler
C: use DBMS_JOB package
D: use Oracle Data Pump Export and Import

You are maintaining your database in Oracle10g. You want to store the information about the backup of the database in the control file. You issue the following statement： SQL>ALTER SYSTEM SET CONTROL_FILE_RECORD_KEEP_TIME=400； What is the outcome of this statement？（）
A: The statement will not execute successfully.
B: The statement will execute successfully， and the backups metadata will be maintained in the control file for 400 days
C: The statement will execute successfully， and the backups metadata will be maintained in the recovery catalog for 400 days.
D: Backups will be deleted from the media after 400 days.

PL/SQL的循环控制语句LOOP包括以下（）类型。
A:LOOP
B:WHILE…LOOP
C:IF…LOOP
D:FOR…LOOP

Which two statements are true about the Oracle Enterprise Manager （OEM）？（）
A: OEM can do management and monitoring across multiple WLS Domains
B: OE is a unified solution for management and monitoring across entire architecture - Web Tier， App Tier & DB Tier
C: OEM is focused solely on Oracle solutions， cannot manage 3rd party products
D: OEM includes tools to configure the operating system

哪种表空间可以被设置为脱机状态（）。
A:系统表空间
B:撤销表空间
C:临时表空间
D:用户表空间

What is the result when the programmer attempts to compile the code and run it with the command java Converter 12?（）
A:It is true that j==i.
B:It is false that j==i.
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 13.

What is the result?（）
A:2
B:3
C:4
D:6
E:7
F:Compilation fails.

Which statements are true regarding listeners（）
A:Listeners use only the TCP/IP protocol.
B:Multiple listener processes can run simultaneously on a host.
C:Multiple database instances can be registered with a single listener.
D:The listener-related errors can be traced only at the administrative level.
E:Only one database instance can be registered with a single listener at any time

What is the result？（）
A:[1， 2， 3， 5]
B:[2， 1， 3， 5]
C:[2， 5， 3， 1]
D:[5， 3， 2， 1]
E:[1， 3， 5， 2]

You create a master-detail form. The users need to be able to exit the form quickly, adhering to default transaction processing, regardless of the cursor location. You believe you can achieve this using a Key-Exit trigger. What do you need to do to implement this request? （）
A:Define a Key-Exit trigger for all the blocks in the form.
B:In the Object Navigator, highlight all the items and define a Key-Exit trigger.
C:Define a Key-Exit trigger on the primary key item in the master block.
D:No additional key-trigger definition is necessary.

首页 <上一页 100 101 102 103 104 下一页> 尾页