Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (391-400)

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

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

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

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

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

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

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/[email protected]
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

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: CD
Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osbackup.htm#BRADV90002
Making User-Managed Backups of Online Read/Write Tablespaces
You must put a read/write tablespace in backup mode to make user-managed data file backups when the tablespace is online and the database is open. TheALTER TABLESPACE … BEGIN BACKUP statement places a tablespace in backup mode. In backup mode, the database copies whole changed data blocks into the redo stream. After you take the tablespace out of backup mode with the ALTER TABLESPACE … END BACKUP or ALTER DATABASE END BACKUP statement, the database advances the data file checkpoint SCN to the current database checkpoint SCN.
When restoring a data file backed up in this way, the database asks for the appropriate set of redo log files to apply if recovery is needed. The redo logs contain all changes required to recover the data files and make them consistent.

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

QUESTION 400
You opened the encryption wallet and then issued the following command:
SQL>CREATE TABLESPACE securespace
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 the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.
What is the outcome?

A.    It creates the table and encrypts the data in it.
B.    It generates an error because the wallet is closed.
C.    It creates the table but does not encrypt the data in it.
D.    It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

Answer: B

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back