ORACLE 11G OCP 管理2 WorkshopII 1Z0-053 题库300-400之间题 - 图文

QUESTION 300

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this:

1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG;

What is the correct sequence in which the commands have to be executed?

A. 1, 4, 5, 2, 3 B. 1, 4, 3, 2, 5 C. 4, 5, 2, 3, 1 D. 2, 3, 4, 5, 1 E. 1, 4, 2, 3, 5

Answer: B Section: (none)

Explanation/Reference:

QUESTION 301

Which of the following are correct about block media recovery? (Choose all that apply.)

A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION. B. Logical corruptions are repairable by BMR. C. Physical corruptions are repairable by BMR. D. RMAN can use any backup for a BMR restore.

E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore.

Answer: AC Section: (none)

Explanation/Reference:

QUESTION 302

While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block?

A. RECOVER FILE=1201 BLOCK=1968; B. RECOVER CORRUPTION LIST;

C. RECOVER DATAFILE 1201 BLOCK 1968; D. RECOVER BLOCK CORRUPTION LIST; E. None of the above

Answer: BC Section: (none)

QUESTION 303

To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?

A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic

SQL Tuning Advisor

C. EM Database home page, Software and Support, Support Workbench, Advisor Central,

SQL Advisors, Automatic SQL Tuning Advisor D. Either B or C E. All of the above

Answer: D Section: (none)

QUESTION 304

When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

A. Filter versions B. Filter loads C. Filter tasks D. Filter options

Answer: D Section: (none)

QUESTION 305

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?

A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section. B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results. C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results. D. Either B or C.

Answer: A Section: (none)

Explanation/Reference:

QUESTION 306

Which of these appropriately describes the results of a manual SQL Tuning Advisor task?

A. A list of SQL statements and recommendations for tuning

B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics C. Graphs showing the actual performance improvement made by the Advisor after it implemented

the recommended changes D. All of the above

Answer: A Section: (none)

QUESTION 307

Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?

A. Create new indexes. B. Modify existing indexes.

C. Implement partitioning on a nonpartitioned table. D. Create materialized views.

E. All of the above

Answer: E Section: (none)

QUESTION 308

Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?

A. SQL Access Advisor recommendations are automatically implemented.

B. Individual SQL Access Advisor recommendations can be scheduled for implementation.

C. All SQL Access Advisor recommendations for a specific task must be implemented at the same time. D. SQL Access Advisor recommendations are automatically scheduled for implementation during the

maintenance window. E. None of the above.

Answer: B Section: (none)

QUESTION 309

Which of the following represents the correct sequence of events for Database Replay?

A. Capture, analyze, preprocess, replay B. Capture, preprocess, analyze, replay C. Capture, preprocess, replay, analyze D. Analyze, capture, preprocess, replay E. None of the above

Answer: C Section: (none)

Explanation/Reference:

QUESTION 310

Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)

A. Make sure your replay database has the same structure as the capture database, except without data. B. Make sure the replay and capture databases are similar in data content.

C. Perform a clean shutdown and restart of the capture database before beginning a workload capture. D. Start the capture database in UNRESTRICTED mode, then start the capture. E. Define inclusion and exclusion filters.

Answer: BC Section: (none)

QUESTION 311

Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?

A. Workload capture is per instance.

B. You only need to restart one instance to begin workload capture.

C. Specifically in RAC, you shut down all instances, restart them individually, and begin workload

capture with the last instance started.

D. RAC does not support workload capture, but it does support workload replay. E. None of the above.

Answer: E Section: (none)

QUESTION 312

Performance divergence indicated in the Workload Replay report is most likely due to what?

A. DML and SQL statement results that do not match between the capture and replay systems B. When errors that occur in the capture system dont occur in the replay system C. Top SQL statements

D. Infrastructure or system-configuration differences

E. Time-of-day differences between capture and replay systems

Answer: D Section: (none)

QUESTION 313

Which of the following Oracle features is enabled by setting a nonzero value for the

MEMORY_TARGET initialization parameter?

A. Automatic PGA Memory Management B. Automatic SGA Memory Management C. Automatic Shared Memory Management D. Automatic Memory Management E. Manual SGA Memory Management F. None of the above

Answer: D Section: (none)

Explanation/Reference:

QUESTION 314

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

A. Automatic PGA Memory Management B. Automatic SGA Memory Management C. Automatic Shared Memory Management D. Automatic Memory Management E. Manual SGA Memory Management F. None of the above

Answer: C Section: (none)

QUESTION 315

For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory-management features?

A. Automatic PGA Memory Management B. Automatic SGA Memory Management C. Automatic Shared Memory Management D. Automatic Memory Management E. Manual SGA Memory Management F. None of the above

Answer: D Section: (none)

QUESTION 316

To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization parameters? (Choose all that apply.)

A. DB_CACHE_SIZE B. SHARED_POOL_SIZE C. LARGE_POOL_SIZE D. JAVA_POOL_SIZE E. SGA_MAX_SIZE F. SORT_AREA_SIZE

Answer: ABCD Section: (none)

QUESTION 317

When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?

\Oracle 1Z0-053 Exam

A. DB_CACHE_SIZE B. SHARED_POOL_SIZE C. LARGE_POOL_SIZE D. JAVA_POOL_SIZE E. SGA_MAX_SIZE F. SORT_AREA_SIZE

Answer: E Section: (none)

QUESTION 318

Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)

A. DB_CACHE_SIZE B. SHARED_POOL_SIZE C. LARGE_POOL_SIZE D. JAVA_POOL_SIZE E. SGA_MAX_SIZE F. SORT_AREA_SIZE

Answer: AB Section: (none)

QUESTION 319

In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

A. Setting a nonzero value for SGA_TARGET

B. Configuring Automatic Shared Memory Management C. Configuring Automatic Memory Management

D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET E. None of the above

Answer: B Section: (none)

QUESTION 320

Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)

A. SORT_AREA_SIZE B. HASH_AREA_SIZE

C. BITMAP_MERGE_AREA_SIZE D. CREATE_BITMAP_AREA_SIZE E. PGA_AGGREGATE_TARGET

Answer: ABCD Section: (none)

QUESTION 321

When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?

A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you

increase PGA_AGGREGATE_TARGET.

B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will

change if you change the value of PGA_AGGREGATE_TARGET.

C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM

will change if you switch between Manual and Automatic PGA Memory Management.

D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas

if you switch from Manual to Automatic PGA Memory Management.

Answer: A Section: (none)

Explanation/Reference:

QUESTION 322

To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?

A. RESUMABLE_SPACE_TIME B. RESUMABLE_SPACE C. RESUMABLE_TIME D. RESUMABLE_TIMEOUT E. TIME_RESUMABLE

Answer: D Section: (none)

QUESTION 323

Which of the following describes how a distributed resumable transaction behaves?

A. The resumable setting on the initiating session determines the resumable conditions for the entire

distributed transaction.

B. The resumable setting for the initiating instance determines the resumable conditions for the entire

distributed transaction.

C. The resumable setting on the initiating session controls only that part of the transaction that occurs

within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction. D. None of the above.

Answer: C Section: (none)

QUESTION 324

Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?

A. Username, instance number, session ID B. Instance number, username, session ID C. Instance number, session ID, username D. Username, session ID, instance number E. None of the above

Answer: D Section: (none)

Explanation/Reference:

QUESTION 325

Which of the following are included in a transportable tablespace set? (Choose all that apply.)

A. The datafiles that make up a self-contained group of tablespaces required for copy B. The system tablespace

C. An export of the tablespace metadata D. The spfile E. All of the above

Answer: AC Section: (none)

QUESTION 326

The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

select d.platform_name \\

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

Answer: AC Section: (none)

QUESTION 327

When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?

A. Export the tablespaces using data pump.

B. Determine if the transportable set is self-contained. C. Convert the datafiles using RMAN.

D. Copy the datafiles from source to destination.

Answer: B Section: (none)

QUESTION 328

Which of the following are prerequisite steps to transport a database? (Choose all that apply.)

A. Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the

intended destination is listed.

B. Verify that there are no restrictions or limitations that the source or destination database may encounter. C. Verify that the source and destination have the same Oracle version, critical updates, patch-set

version, and patch- set exceptions.

D. Determine if you will perform the conversion on the source or destination platform. E. None of the above.

Answer: ABD Section: (none)

Explanation/Reference:

QUESTION 329

Which of the following supplied functions is used to identify external tables, directories, and BFILES?

A. DBMS_TDB.CHECK_DIRECTORIES B. DBMS_TDB.CHECK_EXTERNAL C. DBMS_TDB.CHECK_BFILE D. DBMS_TDB.CHECK_EXT

Answer: B Section: (none)

QUESTION 330

Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?

A. The database must be in read-write mode. B. The database must have no external files. C. The database must open in read-only mode. D. The database must be mounted but not opened.

Answer: C Section: (none)

QUESTION 331

Which of the following options describes Segment Shrink?

A. Reclaims space above and below the high-water mark without using additional space

B. Moves rows to a new physical location, resetting the high-water mark, but uses additional space

during the operation

C. Deallocates space above the high-water mark that is currently not in use D. None of the above

Answer: A Section: (none)

QUESTION 332

For which of the following can you use Segment Shrink? (Choose all that apply.)

A. Heap tables

B. Tables with function-based indexes C. Indexes

D. Partitions and subpartitions E. None of the above

Answer: ACD Section: (none)

Explanation/Reference:

QUESTION 333

When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

A. INCLUDING DEPENDENCIES

B. INCLUDING DEPENDENCIES CASCADE C. COMPACT D. CASCADE E. None of the above

Answer: D Section: (none)

QUESTION 334

Which of these represent the main components of Database Resource Manager? (Choose all that apply.)

A. Resource consumer groups B. Resource plans C. Resource-plan groups D. Resource-plan directives E. All of the above

Answer: ABD Section: (none)

QUESTION 335

Every resource plan must contain an allocation to which consumer group?

A. LOW_GROUP B. SYS_GROUP C. DEFAULT_GROUP D. BASE_GROUP E. OTHER_GROUPS

Answer: E Section: (none)

QUESTION 336

Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?

A. CREATE_MAPPING_PRIORITY B. SET_MAPPING_PRIORITY C. SET_MAPPING_ORDER D. PRIORITIZE_MAPPING_ORDER

E. This functionality is not available through the DBMS_RESOURCE_MANAGER package.

Answer: B Section: (none)

Explanation/Reference:

QUESTION 337

Within a resource-plan definition, what differentiates a top-level plan from a subplan?

A. A subplan has the PLAN_SUB parameter value set to SUB.

B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the

resource-plan definition.

C. There is no difference in the resource-plan definition.

D. A subplan always has the CPU_MTH parameter value set to RATIO. E. The string TOP_LEVEL is appended to the name of top-level resource plans.

Answer: C Section: (none)

QUESTION 338

When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

A. SET_JOB_ARGUMENT_VALUE B. SET_JOB_VALUE_ANYDATA C. SET_JOB_ANYDATA_VALUE D. SET_SPECIAL_JOB_VALUE E. SET_JOB_ANYTYPE_VALUE

Answer: C Section: (none)

QUESTION 339

Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)

A. ENABLE

B. ENABLE_PROGRAM C. VALIDATE_PROGRAM D. SET_ATTRIBUTE E. SET_ENABLED

Answer: AD

Section: (none)

QUESTION 340

Which of the following is not a valid calendaring syntax element?

A. FREQ B. BYHOUR C. RUNDATE D. INTERVAL E. BYMINUTE

Answer: C Section: (none)

QUESTION 341

Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)

A. DBA_SCHEDULER_JOB_RUN_DETAILS B. DBA_SCHEDULER_RUNNING_JOBS C. DBA_SCHEDULER_CURRENT_JOBS D. DBA_SCHEDULER_JOBS

E. DBA_SCHEDULER_EXECUTING_JOBS

Answer: BD Section: (none)

Explanation/Reference:

QUESTION 342

A schedule defined entirely within the confines of a Scheduler job object is known as a (n) ________________.

A. Fixed schedule B. Inline schedule C. Stored schedule

D. Hard-coded schedule E. None of the above

Answer: B Section: (none)

QUESTION 343

Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

A. SET_ATTRIBUTE_NULL B. ALTER_JOB

C. ALTER_JOB_PARAMETERS D. ALTER

E. SET_ATTRIBUTE

Answer: AE Section: (none)

QUESTION 344

What is the default value for the ENABLED attribute of a job or program when it is created?

A. TRUE B. FALSE

C. There is no default. It must be defined at creation time. D. PENDING E. NULL

Answer: B Section: (none)

QUESTION 345

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used? (Choose all that apply.)

A. LOG_HISTORY B. JOB_LOG_RETENTION C. WINDOW_LOG_RETENTION D. WHICH_LOG E. LOG_NAME

Answer: AD Section: (none)

Explanation/Reference:

QUESTION 346

Consider the following code snippet: BEGIN

DBMS_SCHEDULER.SET_ATTRIBUTE ( name => ,,lne_job1, attribute => ,,job_priority, value => 1); END; /

If this code were executed, which of the following statements would be true?

A. The priority of the lne_job1 job would be set to 1. B. The lne_job1 job would be executed synchronously.

C. The lne_job1 job would run immediately in the users current session. D. The lne_job1 job would retain its current priority.

E. The job will immediately take priority over all running jobs.

Answer: A Section: (none)

QUESTION 347

Which of the following calendaring syntax expressions would evaluate to the last day of every month?

A. FREQ = MONTHLY; BYMONTHDAY = 31 B. FREQ = MONTHLY; BYMONTHDAY = -1

C. FREQ = DAILY; BYDAY = -1 D. FREQ = MONTHLY; BYDAY = 31

E. FREQ = DAILY; BYMONTHDAY = LAST_DAY

Answer: B Section: (none)

QUESTION 348

Which of the following tasks is not performed by the job coordinator?

A. Update job log when a job completes B. Spawn and remove job slaves

C. Write/read job info to/from memory cache D. Query job table

E. Pass job information to job slaves

Answer: A Section: (none)

Explanation/Reference:

QUESTION 349

Which of the following objects can be directly referenced by a window object? (Choose all that apply.)

A. Schedule object B. Program object C. Job object D. Resource plan

E. Resource consumer group

Answer: AD Section: (none)

QUESTION 350

Which of the following are valid program types for a lightweight job? (Choose all that apply.)

A. PLSQL_BLOCK B. EXECUTABLE

C. JAVA_STORED_PROCEDURE D. STORED_PROCEDURE E. EXTERNAL

Answer: AD Section: (none)

QUESTION 351

Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

A. PLSQL_BLOCK

B. JAVA_STORED_PROCEDURE C. STORED_PROCEDURE D. EXECUTABLE

E. None of the above are invalid settings.

Answer: B Section: (none)

QUESTION 352

Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)

A. Schedule objects B. Program arguments C. Job classes D. Job arguments E. All of the above

Answer: ABD Section: (none)

Explanation/Reference:

QUESTION 353

What is the danger associated with stopping a running job by using the STOP_JOB procedure?

A. The job will need to be reenabled before it will execute again. B. The job may hold locks on objects referenced within it. C. All jobs within the job group will also be stopped. D. The job may leave data in an inconsistent state. E. There is no danger in using the STOP_JOB procedure.

Answer: D Section: (none)

QUESTION 354

If a job references a schedule that has been disabled, what will be the result?

A. The job will be automatically disabled. B. The job will never execute.

C. The job will attempt to execute but will fail.

D. The job will inherit the DEFAULT_SCHEDULE schedule. E. A schedule object cannot be disabled.

Answer: E Section: (none)

QUESTION 355

When a job exceeds the date specified in its END_DATE attribute, which of the following will happen? (Choose all that apply.)

A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE. B. The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.

C. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP

attribute is FALSE.

D. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is

TRUE and the value of the CASCADE attribute is TRUE.

E. The STATE column of the job table will be set to COMPLETED for the job.

Answer: ABE Section: (none)

QUESTION 356

Which of the following is true about job chains?

A. They consist of one or more Scheduler programs. B. They are used to implement dependency scheduling. C. They are used to implement time-based scheduling. D. They are used to implement event-based scheduling. E. None of the above.

Answer: B Section: (none)

QUESTION 357

If two windows overlap, which window attribute will determine whether one should be chosen over the other?

A. WINDOW_PRIORITY B. PRIORITY C. PRIORITY_LEVEL

D. WINDOW_PRIORITY_LEVEL E. OVERLAP_RULE

Answer: A Section: (none)

Explanation/Reference:

QUESTION 358

Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?

A. RSTLNE B. NLSRTL C. LISTENER D. NLSSORT E. Linguistic sorts

Answer: B Section: (none)

QUESTION 359

What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)

A. NLS_LANGUAGE B. NLS_SORT C. NLS_CALENDAR D. NLS_CHARACTERSET E. NLS_TERRITORY

Answer: ADE Section: (none)

QUESTION 360

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B? (Choose all that apply.)

A. A must contain all of the characters defined in B. B. A must be Unicode.

C. The encoded values in A must match the encoded values in B for all characters defined in B. D. A must be a multibyte character set.

E. The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B.

Answer: AC Section: (none)

QUESTION 361

The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)

A. WHERE clause B. ORDER BY clause C. BETWEEN clause

D. NLSSORT function E. NLS_SORT function

Answer: AD Section: (none)

Explanation/Reference:

QUESTION 362

Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

A. V$VALID_NLS_VALUES B. NLS_VALID_VALUES C. NLS_VALUE_OPTIONS D. V$NLS_VALUE_OPTIONS E. V$NLS_VALID_VALUES

Answer: E Section: (none)

QUESTION 363

Which of the following datatypes store time-zone information in the database?

A. TIMESTAMP B. DATE

C. TIMESTAMP WITH TIME ZONE D. TIMESTAMP WITH LOCAL TIME ZONE E. DATETIME

Answer: C Section: (none)

QUESTION 364

Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)

A. ASCII B. ANSI C. BINARY D. MONOLINGUAL E. MULTILINGUAL

Answer: BC Section: (none)

QUESTION 365

NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:

A. Default setting

B. Client environment variable C. Explicit ALTER SESSION statement D. Inside SQL function

E. Server initialization parameter F. b, d, e, a, c G. e, a, b, c, d H. d, c, b, e, a I. a, b, d, c, e J. d, c, b, a, e

Answer: C Section: (none)

Explanation/Reference:

QUESTION 366

What can you determine about the following linguistic sorts based only on their names?

1. GERMAN 2. FRENCH_M

A. 1 is a monolingual sort. B. 2 is a monolingual sort. C. 1 is case insensitive.

D. Both 1 and 2 are case insensitive. E. Case sensitivity is unknown.

Answer: A Section: (none)

QUESTION 367

In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?

A. VARCHAR2 B. CHAR C. NVARCHAR2 D. CLOB E. LONG

Answer: C Section: (none)

QUESTION 368

Automatic data conversion will occur if which of the following happens?

A. The client and server have different NLS_LANGUAGE settings.

B. The client and server character sets are not the same, and the database character set is not a strict

superset of the client character set.

C. The client and server are in different time zones. D. The client requests automatic data conversion.

E. The AUTO_CONVERT initialization parameter is set to TRUE.

Answer: B Section: (none)

Explanation/Reference:

QUESTION 369

Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?

A. NLS_SORT = BINARY B. NLS_SORT = BINARY_AI C. NLS_SORT = BINARY_CI D. NLS_SORT = BINARY_AI_CI

E. Binary sorts are case insensitive and accent insensitive by default.

Answer: B Section: (none)

QUESTION 370

Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement?

A. NLS_LANG B. NLS_COMP C. NLS_SORT D. None of the above

Answer: D Section: (none)

QUESTION 371

Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?

A. All objects in the database

B. Tables owned by SYS and SYSTEM C. Data dictionary tables D. NCHAR columns E. CHAR columns

Answer: E Section: (none)

QUESTION 372

Which is not a valid locale definition file type?

A. Language B. Linguistic sort C. Calendar D. Territory E. Character set

Answer: C Section: (none)

QUESTION 373

How many different calendars does Oracle 11g support? A. 22 B. 7 C. 6 D. 15 E. 2

Answer: B Section: (none)

Explanation/Reference:

QUESTION 374

Which NLS parameter directly governs linguistic searches?

A. NLS_SEARCH_L B. NLS_SORT C. NLS_SEARCH D. NLS_SORT_L E. None of the above

Answer: B Section: (none)

QUESTION 375

Case-insensitive sorts are always accent insensitive by default.

A. True B. False

Answer: B Section: (none)

QUESTION 376

What is the name of the file that identifies the set of available locale definitions?

A. locale.def B. lxdef.ora C. lx1boot.nlb D. lx1boot.ora E. lang.def

Answer: C Section: (none)

QUESTION 377

Which of the following is not a valid linguistic sort element?

A. Accent expansion B. Canonical equivalence C. Reverse secondary sorting D. Ignorable characters E. Character rearrangement

Answer: A Section: (none)

Explanation/Reference:

QUESTION 378

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

A. Cursor cache B. Stored outline C. SQL Tuning Set

D. Automatic Workload Repository (AWR) snapshots

Answer: AC Section: (none)

QUESTION 379

Which two statements about workload capture and replay operations are true? (Choose two.)

A. The clients must be created manually on the test machines to perform more realistic testing.

B. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for

workload replay.

C. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state

for capturing the workload.

D. The application state of the capture system must be identical to the application state of the replay system

when the workload replay begins.

Answer: CD Section: (none)

QUESTION 380

View the Exhibit exhibit1 to examine the series of SQL commands.

View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans. B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan. C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan. D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to

FIRST_ROW during its creation.

Answer: B Section: (none)

Explanation/Reference:

QUESTION 381

Which statement is true about a running session that belongs to the online transaction processing (OLTP) group?

A. It permanently switches to the low_group consumer group if the session exceeds 10,000 I/O requests or

2,500 MB of data transfer.

B. It performs the first 10000 I/O requests or 2,500 MB of data transfer in the LOW-GROUP consumer group,

and then switches to the original group.

C. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB

of data transfer and returns to the original group after the operation.

D. It switches to the LOW_GROUP consumer group if the session exceeds 10000 I/O requests or 2500 MB

of data transfer for queries, but not for data manipulation language (DML) operations.

Answer: D Section: (none)

Explanation/Reference:

QUESTION 382

USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

A. Use Data Pump to transfer the existing data to a new encrypted tablespace.

B. Use ALTER TABLE. MOVE to transfer the existing data to a new encrypted tablespace. C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace. D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt

the tablespace.

E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data

in the tablespace is automatically encrypted.

Answer: ABC Section: (none)

QUESTION 383

Evaluate the following block of code:

BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL ( acl =>

'mycompany-com-permissions.xml', principal => 'ACCT_MGR', is_grant => TRUE, privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL ( acl => 'mycompany-com-permissions.xml', host => '*.mycompany.com'); END;

What is the outcome of the above code?

A. It produces an error because a fully qualified host name needs to be specified.

B. It produces an error because the range of ports associated with the hosts has not been specified. C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and

RESOLVE privileges.

D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT

privilege but not the RESOLVE privilege.

Answer: C Section: (none)

QUESTION 384

Which steps are mandatory to enable Direct NFS?

1. Mount all required file systems using the kernel NFS driver.

2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.

3. Replace the ODM library libodm11.so_stub with libodm11.so.

A. 2 and 3 B. 1 and 3 C. 1 and 2 D. 1, 2 and 3

Answer: B Section: (none)

Explanation/Reference:

QUESTION 385

You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the

tape device.

The current consumption of your CPU is approximately 40 percent. Which type of backup should you perform?

A. standard backup set B. image copy C. compressed backup D. user-managed backup

Answer: C Section: (none)

QUESTION 386

You execute the following Recovery Manager (RMAN) commands in (he following order:

BACKUP VALIDATE DATABAE RECOVER CORRUPTION LIST;

Which (two tasks are performed by these commands? (Choose two.)

A. Repair the corrupted blocks. If any. In the backup created.

B. Populate VSCOPV_CORRUPTION with names of files that have corrupted blocks- C. Back up the database after checking whether array of the files have corrupted blocks.

D. Discover any corrupt blocks that are viewable with the VSDATABASE_BI-OCK_CORBUPTION view. E. Repair all corrupted blocks that have been logged in the VSDATABASE_BLOCK_ CORRUPTION

Answer: BC Section: (none)

QUESTION 387

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics.

Which two statements describe the implications of this? (Choose two.)

A. It produces less accurate results of the comparison analysis. B. It automatically calls the SQL Tuning Advisor for recommendations.

C. It shortens the time of execution and reduces the impact on system resources. D. Only the changes in the execution plan, and not performance regression, are detected.

Answer: AC Section: (none)

Explanation/Reference:

QUESTION 388

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.

What configuration would you effect to achieve your objective? (Choose all that apply.)

A. Set the ASM compatibility attribute for the ASM disk group to 11.1.0. B. Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0. C. Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0. D. Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

Answer: AD Section: (none)

QUESTION 389

You executed the following command in the Recovery Manager (RMAN):

RMAN> REPORT NEED BACKUP days 3;

What is the output of this command?

A. A list of files that require a backup within 3 days

B. A list of files requiring more than 3 days of archivelogs to apply

C. A list of files that RMAN recommends be backed up only once in every three days, based on low volatility D. A list of files for which a backup as already been performed in the last three days and which is

required to be backed up again based on the high number of transactions performed on them

Answer: B Section: (none)

QUESTION 390 View the Exhibit.

Examine the following command that is executed for the TRANSPORT table in the SH schema:

SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe', '(country_id, cust_state_province)') FROM dual;

Which statement describes the significance of this command?

A. It collects statistics into the pending area in the data dictionary. B. It creates a virtual hidden column in the CUSTOMERS_OBE table. C. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT. D. It creates a histogram to hold skewed information about the data in the columns.

Answer: B Section: (none)

Explanation/Reference:

QUESTION 391

Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance.

To what value will the MEMORY_MAX_TARGET parameter be set by default?

A. 120M B. 320M C. 480M

D. 600M

Answer: D Section: (none)

QUESTION 392

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:

SQL>@utlu111i.sql

Which statement about the execution of this script is true?

A. It must be executed from the Oracle Database 11g environment.

B. It must be executed only after the SYSAUX tablespace has been created. C. It must be executed from the environment of the database that is being upgraded. D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Answer: C Section: (none)

Explanation/Reference:

QUESTION 393

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

A. It detects changes in SQL execution plans.

B. It produces results that can be used to create the SQL plan baseline.

C. The importance of SQL statements is based on the size of the objects accessed. D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs. E. It shows only the overall impact on workload and not the net SQL impact on workload.

Answer: ABD Section: (none)

QUESTION 394

Which statement about Automatic Memory Management with Oracle 11g is true?

A. You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or

PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file. B. Oracle can reallocate memory between the SGA and PGA automatically as needed.

C. To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET

and MEMORY_MAX_TARGET parameters in your parameter file.

D. You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size

plus the current PGA size.

Answer: B Section: (none)

QUESTION 395

Which statement is true regarding the VALIDATE DATABASE command?

A. It checks the database for intrablock corruptions only.

B. It checks for block corruption in the valid backups of the database. C. It checks the database for both intrablock and interblock corruptions. D. It checks for only those corrupted blocks that are associated with data files.

Answer: A Section: (none)

QUESTION 396

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

A. As ASM instance mounts an ASM control file

B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET

parameter is not set explicitly

D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when

the database instance is started

Answer: CD Section: (none)

Explanation/Reference:

QUESTION 397

You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.

You issued the following RMAN commands to create a duplicate database:

RMAN> CONNECT target sys/sys@APPPROD

RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE DB_FILE_NAME_CONVERT '/oracle/oradata/prod/',

'/scratch/oracle/oradata/dupdb/' SPILE PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/', '/scratch/oracle/oradata/dupdb/' SET

SGA_MAX_SIZE = '300M' SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/',

'/scratch/oracle/oradata/dupdb/redo/';

Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The source database should be open.

B. The target database should be in ARCHIVELOG mode if it is open. C. RMAN should be connected to both the instances as SYSDBA.

D. The target database backups should be copied to the source database backup directories.

E. The password file must exist for the source database and have the same SYS user password as the target.

Answer: BCE Section: (none)

QUESTION 398

The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:

SQL> ALTER TABLESPACE hi_data BEGIN BACKUP;

Which two statements are true in this scenario? (Choose two.)

A. No transaction on the tablespace is allowed but you can perform queries.

B. The tablespace will automatically come out of backup mode when the file copy is complete.

C. The checkpoint change number is frozen in headers of the data files until the file is

removed from backup mode.

D. The database writes the before image of an entire block to the redo stream before modifying.

block tor the first time.

Answer: AC Section: (none)

QUESTION 399

Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository (ADR)?

A. The incident metadata is purged when the problem is resolved and the DBA closes the SR. B. The incident files and dumps are not retained in the ADR for the manually created incidents. C. The incident files are retained but the incident metadata is purged when the problem is resolved

and the DBA closes the SR

D. The default setting is for one year after which the incident metadata is purged from the ADR and

the files are retained for one month.

Answer: D Section: (none)

Explanation/Reference:

本文来源：https://www.bwwdw.com/article/kbdo.html