Oracle Database 11g: New Features for Administrators

QUESTION NO: 1
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. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted. B. Use Data Pump 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. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace. E. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.

Correct Answer: B,C,D

QUESTION NO: 2
Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose all that apply.)

A. It is used to change failure priority only for HIGH or LOW priorities. B. It is used to execute the advised repair script. C. It is used to change failure priority only for the CRITICAL priority. D. It is used to inform the database about the repair after the repair script executes. E. It is used to explicitly close the open failures.

Correct Answer: A,E

QUESTION NO: 3
Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

A. SecureFile encryption allows for random reads and writes of the encrypted data. B. The amount of undo retained is user controlled. C. Fragmentation is minimized by using variable-sized chunks dynamically. D. SecureFile LOBs can be used only for nonpartitioned tables. E. It automatically detects duplicate LOB data and conserves space by storing only one copy.

Correct Answer: A,C

QUESTION NO: 4
Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

A. It creates jobs without considering the priorities associated with them. B. It determines the list of jobs that must be created for each maintenance window. C. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks. D. It translates tasks into jobs for execution by the scheduler E. It is spawned by the MMON background process at the start of the maintenance window.

Correct Answer: B,D,E

QUESTION NO: 5
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose al that apply.)

A. tuning each SQL statement in the order of importance
F- generating baselines that include candidate SQLs fortuning B. adding tuned SQL plans into the SQL plan baseline C. generating a list of candidate SQLs fortuning D. generating the SQL profile E. testing and accepting the SQL profile

Correct Answer: A,C,D,E

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

A. It shows only the overall impact on workload and not the net SQL impact on workload. B. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs. C. It detects changes in SQL execution plans. D. It produces results that can be used to create the SQL plan baseline. E. The importance of SQL statements is based on the size of the objects accessed.

Correct Answer: B,C,D

QUESTION NO: 7
Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)

A. multiplexing of the control file B. changing the database storage to ASM-managed storage C. adding the redo log member to the database D. database and operating system upgrades

Correct Answer: B,D

QUESTION NO: 8
View the Exhibit to examine the parameters set for your database instance.

You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:
SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, max_latency=>5u,max_iops=>:max_iops, max_mbps=>:max_mbps, actual latency=>: actual_latency);
Which statement describes the consequence?

A. The calibration process runs successfully and populates all the bind variables. B. The calibration process runs successfully but only the latency time is computed. C. The calibration process runs successfully but the latency time is not computed. D. The command produces an error.

Correct Answer: D

QUESTION NO: 9
View the Exhibit to examine the replay settings for replay parameters.
What is the implication for setting the values for replay parameters? (Choose all that apply.)

A. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins. B. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying. C. The COMMIT order in the captured workload is preserved during replay. D. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured. E. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.

Correct Answer: B,C,D

QUESTION NO: 10
In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It consumes more memory compared with conventional patching. B. It does not require down time to apply or remove unlike conventional patching. C. It takes more time to install or uninstall compared with conventional patching. D. It can be installed and uninstalled via OPatch unlike conventional patching. E. It is not persistent across instance startup and shutdown unlike conventional patching.

Correct Answer: A,B

QUESTION NO: 11
ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

A. The data is decrypted during SORT and JOIN operations. B. The data remains encrypted when it is stored in the redo logs. C. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled. D. The data remains encrypted when it is read into memory.

Correct Answer: B

QUESTION NO: 12
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 '/oracIe/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SPILE PARAMETER_VALUE_CONVERT'/oracle/oradata/prod/1, '/scratch/oracIe/oradata/dupdb/1 SET SGA_MAX_SIZE = '300M1 SET SGA_TARGET = '250M' SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/', '/scratch/oracIe/oradata/dupdb/redo/1;
Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The password file must exist for the source database and have the same SYS user password as the target. B. RMAN should be connected to both the instances as SYSDBA C. The target database should be in ARCHIVELOG mode if it is open. D. The target database backups should be copied to the source database backup directories. E. The source database should be open.

Correct Answer: A,B,E

QUESTION NO: 13
View the Exhibit for some of the parameter settings.

You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename)
TABLESPACE users INVISIBLE;
What is the outcome of the above command?

A. The index is not used by the optimizer and is not maintained during DML operations. B. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations. C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations. D. The index is not used by the optimizer but is maintained during DML operations.

Correct Answer: D

QUESTION NO: 14
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(lsh\ 'customers^be1, '(countryjd, cust_state_province)') FROM dual;
Which statement describes the significance of this command?

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

Correct Answer: B

Oracle Database 11g: New Features for Administrators - 1Z1-050 Exam Questions