451.Which of the following is not avalid setting for the PROGRAM_TYPE parameter in a program object or theJOB_TYPE parameter in a job object?

[if !supportLists]A.  [endif]PLSQL_BLOCK

[if !supportLists]B.  [endif]JAVA_STORED_PROCEDURE

[if !supportLists]C.  [endif]STORED_PROCEDURE

[if !supportLists]D.  [endif]EXECUTABLE

[if !supportLists]E.  [endif]None of the above are invalid settings.

Answer:B

452.Which of the followingScheduler elements encourage object reuse? (Choose all that apply.)

[if !supportLists]A.  [endif]Schedule objects

[if !supportLists]B.  [endif]Program arguments

[if !supportLists]C.  [endif]Job classes

[if !supportLists]D.  [endif]Job arguments

[if !supportLists]E.  [endif]All of the above

Answer:ABD

453.What is the danger associatedwith stopping a running job by using the STOP_JOB procedure? A. The job willneed to be reenabled before it will execute again.

[if !supportLists]B.  [endif]The job may hold locks on objects referenced within it.

[if !supportLists]C.  [endif]All jobs within the job group will also be stopped.

[if !supportLists]D.  [endif]The job may leave data in an inconsistent state.

[if !supportLists]E.  [endif]There is no danger in using the STOP_JOB procedure.

Answer:D

454.If a job references a schedulethat has been disabled, what will be the result? A. The job will beautomatically disabled.

[if !supportLists]B.  [endif]The job will never execute.

[if !supportLists]C.  [endif]The job will attempt to execute but will fail.

[if !supportLists]D.  [endif]The job will inherit the DEFAULT_SCHEDULE schedule.

[if !supportLists]E.  [endif]A schedule object cannot be disabled.

Answer:E

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

A. The job will be droppedautomatically if the value of the AUTO_DROP attribute is TRUE. B. The job willonly be disabled if the value of the AUTO_DROP attribute is FALSE. 

[if !supportLists]C. [endif]The STATE attribute of the job will be set to COMPLETED if the valueof the AUTO_DROP attribute is FALSE. 

[if !supportLists]D. [endif]All objects referenced by the job will be dropped if the value ofthe AUTO_DROP attribute is TRUE and the value of the CASCADE attribute isTRUE. 

[if !supportLists]E.  [endif]The STATE column of the job table will be set to COMPLETED for thejob.

Answer:ABE

456.Which of the following is trueabout job chains?

[if !supportLists]A.  [endif]They consist of one or more Scheduler programs.

[if !supportLists]B.  [endif]They are used to implement dependency scheduling.

[if !supportLists]C.  [endif]They are used to implement time-based scheduling.

[if !supportLists]D.  [endif]They are used to implement event-based scheduling.

[if !supportLists]E.  [endif]None of the above.

Answer:B

457.If two windows overlap, whichwindow attribute will determine whether one should be chosen over the other?

[if !supportLists]A.  [endif]WINDOW_PRIORITY

[if !supportLists]B.  [endif]PRIORITY

[if !supportLists]C.  [endif]PRIORITY_LEVEL

[if !supportLists]D.  [endif]WINDOW_PRIORITY_LEVEL

[if !supportLists]E.  [endif]OVERLAP_RULE

Answer:A

458.Globalization support isimplemented through the text- and character-processing functions provided bywhich Oracle feature?

[if !supportLists]A.  [endif]RSTLNE

[if !supportLists]B.  [endif]NLSRTL

[if !supportLists]C.  [endif]LISTENER

[if !supportLists]D.  [endif]NLSSORT

[if !supportLists]E.  [endif]Linguistic sorts

Answer:B

459.What elements of globalizationcan be explicitly defined using the NLS_LANG environment variable? (Choose allthat apply.)

[if !supportLists]A.  [endif]NLS_LANGUAGE

[if !supportLists]B.  [endif]NLS_SORT

[if !supportLists]C.  [endif]NLS_CALENDAR

[if !supportLists]D.  [endif]NLS_CHARACTERSET

[if !supportLists]E.  [endif]NLS_TERRITORY

Answer:ADE

460.Given two different charactersets (A and B), which of the following must be true for A to be considered astrict superset of B? (Choose all that apply.) A. A must contain all of thecharacters defined in B. 

[if !supportLists]B.  [endif]A must be Unicode.

[if !supportLists]C.  [endif]The encoded values in A must match the encoded values in B for allcharacters defined in B. 

[if !supportLists]D.  [endif]A must be a multibyte character set.

[if !supportLists]E.  [endif]The encoded values in A must match the encoded values in B for allnumeric and alphabetic characters in B. 

Answer:AC

461.The NLS_SORT parameter sets thedefault sort method for which of the following operations?(Choose all thatapply.)

[if !supportLists]A.  [endif]WHERE clause

[if !supportLists]B.  [endif]ORDER BY clause

[if !supportLists]C.  [endif]BETWEEN clause

[if !supportLists]D.  [endif]NLSSORT function

[if !supportLists]E.  [endif]NLS_SORT function

Answer:AD

462.Which view shows all validvalues for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSETparameters?

[if !supportLists]A.  [endif]V$VALID_NLS_VALUES

[if !supportLists]B.  [endif]NLS_VALID_VALUES

[if !supportLists]C.  [endif]NLS_VALUE_OPTIONS

[if !supportLists]D.  [endif]V$NLS_VALUE_OPTIONS

[if !supportLists]E.  [endif]V$NLS_VALID_VALUES

Answer:E

463.Which of the followingdatatypes store time-zone information in the database?

[if !supportLists]A.  [endif]TIMESTAMP

[if !supportLists]B.  [endif]DATE

[if !supportLists]C.  [endif]TIMESTAMP WITH TIME ZONE

[if !supportLists]D.  [endif]TIMESTAMP WITH LOCAL TIME ZONE

[if !supportLists]E.  [endif]DATETIME

Answer:C

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

[if !supportLists]A.  [endif]ASCII

[if !supportLists]B.  [endif]ANSI

[if !supportLists]C.  [endif]BINARY

[if !supportLists]D.  [endif]MONOLINGUAL

[if !supportLists]E.  [endif]MULTILINGUAL

Answer:BC

465.NLS parameters can be set usingthe five methods listed. Put the methods in order from highest to lowestaccording to Oracles order of precedence:

[if !supportLists]A.  [endif]Default setting

[if !supportLists]B.  [endif]Client environment variable

[if !supportLists]C.  [endif]Explicit ALTER SESSION statement

[if !supportLists]D.  [endif]Inside SQL function

[if !supportLists]E.  [endif]Server initialization parameter

[if !supportLists]F.  [endif]b, d, e, a, c

[if !supportLists]G.  [endif]e, a, b, c, d

[if !supportLists]H.  [endif]d, c, b, e, a

[if !supportLists]I.   [endif]a, b, d, c, e

[if !supportLists]J.  [endif]d, c, b, a, e

Answer:C

466.What can you determine aboutthe following linguistic sorts based only on their names?

[if !supportLists]1.  [endif]GERMAN

[if !supportLists]2.  [endif]FRENCH_M

[if !supportLists]A.  [endif]1 is a monolingual sort.

[if !supportLists]B.  [endif]2 is a monolingual sort.

[if !supportLists]C.  [endif]1 is case insensitive.

[if !supportLists]D.  [endif]Both 1 and 2 are case insensitive.

[if !supportLists]E.  [endif]Case sensitivity is unknown.

Answer:A

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

[if !supportLists]A.  [endif]VARCHAR2

[if !supportLists]B.  [endif]CHAR

[if !supportLists]C.  [endif]NVARCHAR2

[if !supportLists]D.  [endif]CLOB

[if !supportLists]E.  [endif]LONG

Answer:C

468.Automatic data conversion willoccur if which of the following happens? A. The client and server havedifferent NLS_LANGUAGE settings.

[if !supportLists]B.  [endif]The client and server character sets are not the same, and thedatabase character set is not a strict superset of the client character set.

[if !supportLists]C.  [endif]The client and server are in different time zones.

[if !supportLists]D.  [endif]The client requests automatic data conversion.

[if !supportLists]E.  [endif]The AUTO_CONVERT initialization parameter is set to TRUE. 

Answer:B

469.Which of the following NLS_SORTparameter values would result in case-insensitive and accent-insensitive binarysorts?

[if !supportLists]A.  [endif]NLS_SORT = BINARY

[if !supportLists]B.  [endif]NLS_SORT = BINARY_AI

[if !supportLists]C.  [endif]NLS_SORT = BINARY_CI

[if !supportLists]D.  [endif]NLS_SORT = BINARY_AI_CI

[if !supportLists]E.  [endif]Binary sorts are case insensitive and accent insensitive by default.

Answer:B

470.Which NLS parameter can be usedto change the default Oracle sort method from binary to linguistic for the SQLSELECT statement?

[if !supportLists]A.  [endif]NLS_LANG

[if !supportLists]B.  [endif]NLS_COMP

[if !supportLists]C.  [endif]NLS_SORT

[if !supportLists]D.  [endif]None of the above

Answer:D

471.Which of the following would beaffected by setting NLS_LENGTH_SEMANTICS=CHAR?

[if !supportLists]A.  [endif]All objects in the database

[if !supportLists]B.  [endif]Tables owned by SYS and SYSTEM

[if !supportLists]C.  [endif]Data dictionary tables

[if !supportLists]D.  [endif]NCHAR columns

[if !supportLists]E.  [endif]CHAR columns

Answer:E

472.Which is not a valid localedefinition file type?

[if !supportLists]A.  [endif]Language

[if !supportLists]B.  [endif]Linguistic sort

[if !supportLists]C.  [endif]Calendar

[if !supportLists]D.  [endif]Territory

[if !supportLists]E.  [endif]Character set

Answer:C

473.How many different calendarsdoes Oracle 11g support?

[if !supportLists]A.  [endif]22

[if !supportLists]B.  [endif]7

[if !supportLists]C.  [endif]6

[if !supportLists]D.  [endif]15

[if !supportLists]E.  [endif]2

Answer:B

474.Which NLS parameter directlygoverns linguistic searches?

[if !supportLists]A.  [endif]NLS_SEARCH_L

[if !supportLists]B.  [endif]NLS_SORT

[if !supportLists]C.  [endif]NLS_SEARCH

[if !supportLists]D.  [endif]NLS_SORT_L

[if !supportLists]E.  [endif]None of the above

Answer:B

475.Case-insensitive sorts arealways accent insensitive by default.

[if !supportLists]A.  [endif]True

[if !supportLists]B.  [endif]False

Answer:B

476.What is the name of the filethat identifies the set of available locale definitions?

[if !supportLists]A.  [endif]locale.def

[if !supportLists]B.  [endif]lxdef.ora

[if !supportLists]C.  [endif]lx1boot.nlb

[if !supportLists]D.  [endif]lx1boot.ora

[if !supportLists]E.  [endif]lang.def

Answer:C

477.Which of the following is not avalid linguistic sort element?

[if !supportLists]A.  [endif]Accent expansion

[if !supportLists]B.  [endif]Canonical equivalence

[if !supportLists]C.  [endif]Reverse secondary sorting

[if !supportLists]D.  [endif]Ignorable characters

[if !supportLists]E.  [endif]Character rearrangement

Answer:A

478.Identify the two direct sourcesfrom where SQL plans can be loaded into the SQL plan baselines.

(Choose two.)

[if !supportLists]A.  [endif]Cursor cache

[if !supportLists]B.  [endif]Stored outline

[if !supportLists]C.  [endif]SQL Tuning Set

[if !supportLists]D.  [endif]Automatic Workload Repository (AWR) snapshots

Answer:AC

479.Which two statements aboutworkload capture and replay operations are true? (Choose two.)

[if !supportLists]A.  [endif]The clients must be created manually on the test machines to performmore realistic testing.

[if !supportLists]B.  [endif]Restart the database in RESTRICTED mode before beginning workload replayto enable a clean state for workload replay.

[if !supportLists]C. [endif]Restart the database in RESTRICTED mode before beginning workloadcapture to enable a clean state for capturing the workload.

[if !supportLists]D. [endif]The application state of the capture system must be identical to theapplication state of the replay system when the workload replay begins.

Answer:CD

480.View the Exhibit exhibit1 toexamine the series of SQL commands.

View the Exhibit exhibit2 toexamine the plans available in the SQL plan baseline. The baseline in the firstrow of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.  Which statement is true if the SQL query inexhibit1 is executed again when the value of OPTIMIZER_MODE is set toFIRST_ROWS?

[if !vml]

[endif] 

[if !supportLists]A.  [endif]The optimizer uses a new plan because none of the plans in theexhibit2 are fixed plans.

[if !supportLists]B.  [endif]The optimizer uses the plan in the second row of the exhibit2because it is an accepted plan.

[if !supportLists]C.  [endif]The optimizer uses the plan in the first row of the exhibit2 becauseit is the latest generated plan.

[if !supportLists]D.  [endif]The optimizer uses the plan in the first row of the exhibit2 becauseOPTIMIZER_MODE was set to FIRST_ROW during its creation.

Answer:B

481.Which statement is true about arunning session that belongs to the online transaction processing (OLTP) group?

[if !vml]

[endif] 

[if !supportLists]A.     [endif]It permanently switches to thelow_group consumer group if the session exceeds 10,000 I/O requests or 2,500 MBof data transfer.

[if !supportLists]B.     [endif]It performs the first 10000 I/Orequests or 2,500 MB of data transfer in the LOW-GROUP consumer group, and thenswitches to the original group.

[if !supportLists]C.     [endif]It switches to the LOW_GROUPconsumer group if the session exceeds 10000 I/O requests or 2500 MB of datatransfer and returns to the original group after the operation.

[if !supportLists]D.     [endif]It switches to the LOW_GROUPconsumer group if the session exceeds 10000 I/O requests or 2500 MB of datatransfer for queries, but not for data manipulation language (DML) operations.Answer: D

482.USER_DATA is a nonencryptedtablespace that contains a set of tables with data. You want to convert allexisting data in the USER_DATA tablespace and the new data into the encryptedformat.

Which methods would you use toachieve this? (Choose all that apply.)

A. Use Data Pump to transfer theexisting data to a new encrypted tablespace. B. Use ALTER TABL

E. MOVE to transfer the existingdata to a new encrypted tablespace.

[if !supportLists]C.  [endif]Use CREATE TABLE AS SELECT to transfer the existing data to a newencrypted tablespace.

[if !supportLists]D.  [endif]Enable row movement for each table to be encrypted and then useALTER TABLESPACE to encrypt the tablespace.

[if !supportLists]E.  [endif]Encrypt the USER_DATA tablespace using the ALTER TABLESPACEstatement so that all the data in the tablespace is automatically encrypted.

Answer:ABC

483.Evaluate the following block ofcode:

BEGINDBMS_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 abovecode?

[if !supportLists]A.  [endif]It produces an error because a fully qualified host name needs to bespecified.

[if !supportLists]B.  [endif]It produces an error because the range of ports associated with thehosts has not been specified. C. It creates an access control list (ACL) withthe 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 RESOLVEprivilege.

Answer:C

484.Which steps are mandatory toenable Direct NFS?

[if !supportLists]1.  [endif]Mount all required file systems using the kernel NFS driver.

[if !supportLists]2.  [endif]Create an oranfstab file containing the attributes for each NFSserver to be accessed using Direct NFS.

[if !supportLists]3.  [endif]Replace the ODM library libodm11.so_stub with libodm11.so.

[if !supportLists]A.  [endif]2 and 3

[if !supportLists]B.  [endif]1 and 3

[if !supportLists]C.  [endif]1 and 2

[if !supportLists]D.  [endif]1, 2 and 3

Answer:B

485.You want to back up your 100-GBdatabase on a remote tape device. You are required to ensure that minimumnetwork bandwidth is consumed while transferring the backups to the tapedevice.

The current consumption of your CPUis approximately 40 percent.

Which type of backup should youperform?

A. standard backup set B. imagecopy

[if !supportLists]C.  [endif]compressed backup

[if !supportLists]D.  [endif]user-managed backup

Answer:C

486.You execute the followingRecovery Manager (RMAN) commands in (he following order:

BACKUP VALIDATE DATABAE

RECOVER CORRUPTION LIST;

Which (two tasks are performed bythese commands? (Choose two.) A. Repair the corrupted blocks. If any. In thebackup created.

B. Populate VSCOPV_CORRUPTION withnames of files that have corrupted blocks- C. Back up the database afterchecking whether array of the files have corrupted blocks.

[if !supportLists]D.  [endif]Discover any corrupt blocks that are viewable with theVSDATABASE_BI-OCK_CORBUPTION view.

[if !supportLists]E.  [endif]Repair all corrupted blocks that have been logged in theVSDATABASE_BLOCK_ CORRUPTIONAnswer: BC

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

Which two statements describe theimplications of this? (Choose two.) A. It produces less accurate results of thecomparison analysis.

[if !supportLists]B.  [endif]It automatically calls the SQL Tuning Advisor for recommendations.

[if !supportLists]C.  [endif]It shortens the time of execution and reduces the impact on systemresources.

[if !supportLists]D.  [endif]Only the changes in the execution plan, and not performanceregression, are detected.Answer: AC

488.You are managing an OracleDatabase 11g database with the ASM storage. The database is having big filetablespaces. You want files to open faster and less memory to be used in theshared pool to manage the extent maps.

What configuration would you effectto achieve your objective? (Choose all that apply.) A. Set the ASMcompatibility attribute for the ASM disk group to 11.1.0.

[if !supportLists]B.  [endif]Set the RDBMS compatibility attribute for the ASM disk group to11.1.0.

[if !supportLists]C.  [endif]Set the COMPATIBLE initialization parameter for the ASM instance to11.1.0.

[if !supportLists]D.  [endif]Set the COMPATIBLE initialization parameter for the databaseinstance to 11.1.0.Answer: AD

489.For which two database objectscan the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)

A.views

B.fixed tables

C.heap tables

D.external tables

E.temporary tables

F.index-organized tables (IOT)

Answer:CF

490.View the Exhibit.

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

SQL> SELECTDBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe',

'(country_id,cust_state_province)') FROM dual;

Which statement describes thesignificance of this command?

[if !vml]

[endif] 

[if !supportLists]A.  [endif]It collects statistics into the pending area in the data dictionary.

[if !supportLists]B.  [endif]It creates a virtual hidden column in the CUSTOMERS_OBE table.

[if !supportLists]C.  [endif]It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.

[if !supportLists]D.  [endif]It creates a histogram to hold skewed information about the data inthe columns.Answer: B

491.Examine the exhibit to view theparameters set in your parameter file. (Click the Exhibit(s) button.) Yourestart the instance.

To what value will theMEMORY_MAX_TARGET parameter be set by default?

[if !supportLists]A.  [endif]120M

[if !supportLists]B.  [endif]320M

[if !supportLists]C.  [endif]480M

[if !supportLists]D.  [endif]600M

Answer:D

492.You installed Oracle Database11g and are performing a manual upgrade of the Oracle9i database. As a part ofthe upgrade process, you execute the following script:

SQL>@utlu111i.sql

Which statement about the executionof this script is true?

[if !supportLists]A.  [endif]It must be executed from the Oracle Database 11g environment.

[if !supportLists]B.  [endif]It must be executed only after the SYSAUX tablespace has beencreated.

[if !supportLists]C.  [endif]It must be executed from the environment of the database that isbeing upgraded.

[if !supportLists]D.  [endif]It must be executed only after AUTOEXTEND is set to ON for allexisting tablespaces.

[if !supportLists]E.  [endif]It must be executed from both the Oracle Database 11g and OracleDatabase 9i environments.Answer: C

493.Which three statements aboutperformance analysis by SQL Performance Analyzer are true?

(Choose three.)

[if !supportLists]A.  [endif]It detects changes in SQL execution plans.

[if !supportLists]B.  [endif]It produces results that can be used to create the SQL planbaseline.

[if !supportLists]C.  [endif]The importance of SQL statements is based on the size of the objectsaccessed.

[if !supportLists]D.  [endif]It generates recommendations to run SQL Tuning Advisor to tuneregressed SQLs.

[if !supportLists]E.  [endif]It shows only the overall impact on workload and not the net SQLimpact on workload.Answer: ABD

494.Which statement about AutomaticMemory Management with Oracle 11g is true?

A. You cannot specify MEMORY_TARGETif you explicitly specify SGA_TARGET or PGA_AGGREGATE_ TARGET values that aregreater than zero in your parameter file. B. Oracle can reallocate memorybetween the SGA and PGA automatically as needed.

[if !supportLists]C.     [endif]To use Automatic MemoryManagement, you must explicitly set both the MEMORY_TARGET andMEMORY_MAX_TARGET parameters in your parameter file.

[if !supportLists]D.     [endif]You can set the MEMORY_TARGETparameter to a maximum value of the current SGA size plus the current PGA size.

Answer:B

495.Which statement is trueregarding the VALIDATE DATABASE command? A. It checks the database forintrablock corruptions only.

[if !supportLists]B.  [endif]It checks for block corruption in the valid backups of the database.

[if !supportLists]C.  [endif]It checks the database for both intrablock and interblockcorruptions.

[if !supportLists]D.  [endif]It checks for only those corrupted blocks that are associated withdata files.

Answer:A

496.Which two statements are trueregarding an Automatic Storage Management (ASM) instance?

(Choose two.)

[if !supportLists]A.  [endif]As ASM instance mounts an ASM control file

[if !supportLists]B.  [endif]An ASM instance uses the ASMB process for rebalancing of diskswithin a disk group

[if !supportLists]C. [endif]Automatic Memory Management is enabled in an ASM instance even whenthe MEMORY_TARGET parameter is not set explicitly

[if !supportLists]D. [endif]An RDBMS instance gets connected to an ASM instance using ASMB as aforeground process when the database instance is started

Answer:CD

497.You are managing the APPPRODdatabase as a DBA. You plan to duplicate this database in the same system withthe name DUPDB. You issued the following RMAN commands to create a duplicatedatabase:

RMAN> CONNECT targetsys/sys@APPPROD

RMAN> DUPLICATE TARGET DATABASETO 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' SETSGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT

'/oracle/oradata/prod/redo/',

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

Which three are the prerequisitesfor the successful execution of the above command? (Choose three.) A. Thesource database should be open.

[if !supportLists]B.  [endif]The target database should be in ARCHIVELOG mode if it is open.

[if !supportLists]C.  [endif]RMAN should be connected to both the instances as SYSDBA. 

[if !supportLists]D.  [endif]The target database backups should be copied to the source databasebackup directories.

[if !supportLists]E.  [endif]The password file must exist for the source database and have thesame SYS user password as the target.

Answer:BCE

498.The database Is configured inARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform usermanaged backup for the data files of the HR_DATA tablespace. To accomplish thetask, you issued the following command:

SQL> ALTER TABLESPACE hi_dataBEGIN BACKUP;

Which two statements are true inthis scenario? (Choose two.)

[if !supportLists]A.  [endif]No transaction on the tablespace is allowed but you can performqueries.

[if !supportLists]B.  [endif]The tablespace will automatically come out of backup mode when thefile copy is complete.

[if !supportLists]C.  [endif]The checkpoint change number is frozen in headers of the data filesuntil the file is removed from backup mode.

[if !supportLists]D.  [endif]The database writes the before image of an entire block to the redostream before modifying. block tor the first time.

Answer:AC

499.Which statement is trueregarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?

[if !supportLists]A.  [endif]The incident metadata is purged when the problem is resolved and theDBA closes the SR.

[if !supportLists]B.  [endif]The incident files and dumps are not retained in the ADR for themanually created incidents.

[if !supportLists]C. [endif]The incident files are retained but the incident metadata is purgedwhen the problem is resolved and the DBA closes the SR

[if !supportLists]D. [endif]The default setting is for one year after which the incidentmetadata is purged from the ADR and the files are retained for one month.

Answer:D

500.You opened the encryptionwallet and then issued the following command:

SQL>CREATE TABLESPACEsecurespace

DATAFILE'/home/user/oradata/secure01.dbf'

SIZE 150M

ENCRYPTION USING '3DES168'

DEFAULT STORAGE(ENCRYPT);

Then you closed the wallet. Later,you issued the following command to create the EMPLOYEES table in theSECURESPACE tablespace and you use the NO SALT option for the EMPID column.

What is the outcome?

[if !supportLists]A.  [endif]It creates the table and encrypts the data in it.

[if !supportLists]B.  [endif]It generates an error because the wallet is closed.

[if !supportLists]C.  [endif]It creates the table but does not encrypt the data in it.

[if !supportLists]D.  [endif]It generates an error because the NO SALT option cannot be used withthe ENCRYPT option.Answer: B