Renovate 1Z0-053 Dumps For Oracle Database 11g: Administration II Certification

NEW QUESTION 1

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

• A. Only a single partitioning key column can be specified.
• B. All DML statements must use partition-extended syntax.
• C. The same physical attributes must be specified for each partition.
• D. Unique local indexes cannot be created on a system-partitioned table.
• E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: DE

NEW QUESTION 2

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation.
How would this environment variable setting affect the installation?

• A. The installation terminates with an error.
• B. The installation proceeds with the default value without warnings and errors.
• C. The installation proceeds with the default value but it would not be an OFA-compliant database.
• D. The installation proceeds with the default value but a message would be generated in the alert log file.

Answer: D

NEW QUESTION 3

What happens when you run the SQL Tuning Advisor with limited scope?

• A. Access path analysis is not performed for SQL statements.
• B. SQL structure analysis is not performed for SQL statements.
• C. SQL Profile recommendations are not generated for SQL statements.
• D. Staleness and absence of statistics are not checked for the objects in the SQL Tuning Advisor.

Answer: B

NEW QUESTION 4

Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?

• A. SQL Repair Advisor
• B. SQL Optimizer
• C. SQL Access Advisor
• D. SQL Tuning Advisor

Answer: D

NEW QUESTION 5

The following command is executed to create the baseline template:
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE( START_TIME=> TO_TIESTAMP(SYSDATE+2), END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4', TEMPLATE_NAME=>'Mytemp4', EXPIRATION=>NULL);
Which statement is true about the effect of the above command?

• A. It creates a baseline template that never expires.
• B. It produces an error because no snapshot information is provided to create the baseline.
• C. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.
• D. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

Answer: A

NEW QUESTION 6

Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}

• A. The script will fail since you instructed RMAN to back up only one datafile rather than two.
• B. The script will successfully back up datafile 3 without error.
• C. The script will fail since it uses a substitution variable which is not supported.
• D. The execute script command will prompt for the value of and2 since it's not included in the command.
• E. The script will fail because you cannot use the plus archivelog command when backing up database datafiles.

Answer: D

NEW QUESTION 7

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 hr_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 modifyin
• E. block tor the first time.

Answer: CD

Explanation:
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. The ALTER 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.

NEW QUESTION 8

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

Explanation:
DBA_SCHEDULER_JOB_RUN_DETAILS displays log run details for all Scheduler jobs in the database. DBA_SCHEDULER_RUNNING_JOBS displays information about all running Scheduler jobs in the database.
DBA_SCHEDULER_JOBS displays information about all Scheduler jobs in the database. DBA_SCHEDULER_CURRENT_JOBS is INVALID. DBA_SCHEDULER_EXECUTING_JOBS is INVALID.

NEW QUESTION 9

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.
The RVPC user can do which of the following? (Choose all that apply.)

• A. Register databases if granted the register database privilege
• B. See all databases in the recovery-catalog schema
• C. See all database-related metadata in the recovery catalog if they are granted access to that database
• D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
• E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer: AC

NEW QUESTION 10

In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)

• A. Ensure that database is running with version 10.1 compatibility.
• B. Enable Flashback Logging.
• C. Enable Supplemental Logging.
• D. Ensure that the database is running with version 10.0 compatibility.
• E. Ensure that the database is in ARCHIVELOG mode

Answer: CD

NEW QUESTION 11

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:
SQL> startup
ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file
'C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE
\INITORCL.ORA'
Using RMAN, how would you respond to this error?

• A. Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.
• B. Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.
• C. Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.
• D. Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.
• E. Issue the restore spfile from autobackup command from the RMAN prompt.

Answer: C

NEW QUESTION 12

Evaluate the following function code:

Which statement is true regarding the above function?

• A. The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
• B. If the function execution results in an unhandled exception, the exception result is also stored in the cache.
• C. Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
• D. If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.

Answer: A

NEW QUESTION 13

You have the following requirements in relation to the detection of block corruption for your database instance:
✑ Check for logical self-consistency of data blocks when modified in memory.
✑ Checksums are calculated before and after the block change.
✑ Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?

• A. Set the DB_SECUREFILE parameter to PERMITTED.
• B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
• C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
• D. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

Answer: B

Explanation:

C:\Users\albo\Desktop\1-1.jpg Values:
OFF
When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or
DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.
DATA_ONLY
✑ DB_BLOCK_CHECKING will be set to MEDIUM.
✑ DB_LOST_WRITE_PROTECT will be set to TYPICAL.
✑ DB_BLOCK_CHECKSUM will be set to FULL.
DATA_AND_INDEX
DB_BLOCK_CHECKING will be set to FULL. DB_LOST_WRITE_PROTECT will be set to TYPICAL. DB_BLOCK_CHECKSUM will be set to FULL.

C:\Users\albo\Desktop\1-1.jpg Values:
OFF or FALSE
No block checking is performed for blocks in user tablespaces. However, semantic block checking for SYSTEM tablespace blocks is always turned on.
LOW
Basic block header checks are performed after block contents change in memory (for example, after UPDATE or INSERT statements, on-disk reads, or inter-instance block transfers in Oracle RAC).
MEDIUM
All LOW checks and full semantic checks are performed for all objects except indexes (whose contents can be reconstructed by a drop+rebuild on encountering a corruption).
FULL or TRUE
All LOW and MEDIUM checks and full semantic checks are performed for all objects.

NEW QUESTION 14

If a backup is expired, which of the following is true?

• A. It can never be used for a restore/recover operation.
• B. Oracle will remove the backup set pieces from the flash recovery area.
• C. The backup has been used at least once to restore and recover the database.
• D. The backup is no longer valid because of a resetlogs operation.
• E. The physical backup set pieces are missing from the media.

Answer: E

NEW QUESTION 15

Why should you back up a duplicated tablespace after a TSPITR is complete?

• A. The tablespace cannot be duplicated or restored to any point in time after the duplication.
• B. The tablespace cannot be duplicated or restored to the point in time before the duplication.
• C. The entire database cannot be restored after a TSPITR, so a backup is required.
• D. You cannot bring the tablespace online until its been backed up.
• E. There is no requirement to do so, as RMAN will back up the tablespace after the TSPITR.

Answer: B

NEW QUESTION 16

A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take?

• A. Initiate an incomplete recovery operation using RMAN.
• B. Copy the table from a development database.
• C. Advise the user to rekey the data.
• D. Perform a Flashback Drop operation.
• E. Perform a Flashback Recovery operation.

Answer: D

NEW QUESTION 17

You are working in an online transaction processing (OLTP) environment. You use the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?

• A. Restore the backup control file and open the database with RESETLOGS option.
• B. Perform point-in-time recovery because flashback cannot be performed again on this table
• C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
• D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

Answer: D

NEW QUESTION 18

A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.
What happens to the PL/SQL procedure after the online table redefinition?

• A. It remains valid.
• B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.
• C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.
• D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used.

Answer: A

NEW QUESTION 19

Which three elements can a job chain process involve? (Choose three)

• A. an event
• B. a schedule
• C. a program
• D. another chain
• E. a lightweight job

Answer: BDE

Explanation:
Don't really understand the answer so far. Defining Chain Steps
After creating a chain object, you define one or more chain steps. Each step can point to one of the following:
✑ A Scheduler program object (program)
✑ Another chain (a nested chain)
✑ An event schedule, inline event, or file watcher

NEW QUESTION 20

The BOOKINGS table contains online booking information. When a booking is confirmed, the details are transferred to an archival table BOOKINGS_HIST and deleted from the
BOOKINGS table. There is no fixed time interval between each online booking and its confirmation. Because sufficient space is not always available from the delete operations the high-water mark (HWM) is moved up and many rows are inserted below the HWM of the table. The BOOKINGS table has Automatic Segment Space Management (ASSM) and row movement enabled. The table is accessible in 24x7 mode.
What is the most efficient method to reclaim the space released by the delete operations in the BOOKINGS table?

• A. Perform EXPORT, DROP, and IMPORT operations on the BOOKINGS table sequentially
• B. Shrink the BOOKINGS table by using the ALTER TABLE... SHRINK SPACE command
• C. Move the BOOKINGS table to a different location by using the ALTER TABLE... MOVE command
• D. Deallocate the space in the BOOKINGS table by using the ALTER TABLE ... DEALLOCATE UNUSED command

Answer: B

NEW QUESTION 21

Which of the following statements is true regarding the VERSIONS BETWEEN clause?

• A. The VERSIONS BETWEEN clause may be used in DML statements.
• B. The VERSIONS BETWEEN clause may be used in DDL statements.
• C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
• D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

Answer: C

NEW QUESTION 22

Which statement about the enabling of table compression in Oracle Database 11g is true?

• A. Compression can be enabled at the table, tablespace, or partition level for direct loads only.
• B. Compression can be enabled only at the table level for both direct loads and conventional DML.
• C. Compression can be enabled at the table, tablespace, or partition level for conventional DML only.
• D. Compression can be enabled at the table, tablespace, or partition level for both direct loads and conventional DML.

Answer: D

NEW QUESTION 23

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

NEW QUESTION 24
......