Oracle Database 11g: New Features for Administrators

Question 1

You issued the following RMAN command to back up the database: RMAN> RUN{ ALLOCATE CHANNEL c1 DEVICE TYPE Sbt BACKUP DATABASE TAG quarterly KEEP FOREVER RESTORE POINT FY06Q4;}
Which two statements are true regarding the backup performed? (Choose two.)

A. Archived log files are backed up along with data files, and the archived log files are deleted.

B. Only data files are backed up and a restore point named FY06Q4 is created.

C. The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

D. Archived redo log files are backed up along with data files

Correct Answer: C,D

Question 2

You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?

A. to improve performance by storing a copy of the data from the private SQL area of the PGA

B. to enhance the query performance by creating a cache in the client memory for sorting operations

C. to avoid the storing of query plans and results in the server by creating a cache in the client memory

D. to avoid round trips to the server by enabling caching of query results in client memory

Correct Answer: D

Question 3

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

A. Insert a finding directive for future ADDM tasks.

B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

C. Create and populate a SQL Tuning Set from the AWR on every Monday.

D. Create a repeating baseline template.

Correct Answer: D

Question 4

You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h';
To which disks in the disk group will the new value be applicable?

A. all disks that are not currently in OFFLINE mode

B. all disks in the disk group only if all of them are ONLINE

C. all disks that are currently in OFFLINE mode

D. all disks in the disk group

Correct Answer: A

Question 5

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?

A. the backup becomes eligible for deletion according to the existing retention policy

B. The backup overrides the backup retention policy.

C. The backup is deleted.

D. The backup is marked unavailable.

Correct Answer: A

Question 6

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A. You are not able to start up the database instance because the required database files are missing.

B. The user has dropped an important table that needs to be recovered.

C. The archived log files are missing for which backup is not available.

D. The database files are corrupted when the database is open

Correct Answer: A,D

Question 7

You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

A. Truncate the table.

B. Drop the table.

C. Partition the table

D. Rename a column in the table.

E. Add a column to the table.

Correct Answer: E

Question 8

Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE1;
What is the impact of this setting on the usage of Secure Files?

A. It forces Basic Files to be created even if the SECUREFILE option is specified to create the LOB.

B. It does not allow the creation of Secure Files and generates an error if the SECUREFILE option is specified to create the LOB.

C. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a Basic File.

D. It forces Secure Files to be created even if the BASICFILE option is specified to create the LO

Correct Answer: A

Question 9

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:
SQL> EXECUTE DBMS_STATS .GATHER_TABLE_STATS('SHI ,'SALES1 ,GRANUU\RITY=>'GLOBALl);
You need statistics to be collected more quickly. What can you do to achieve this?

A. Set the INCREMENTAL value to TRUE for the partition table.

B. Set the STATISTICS_LEVEL parameter to BASIC.

C. Set DYNAMIC_SAMPLING to level 4.

D. Increase the value of STALE_PERCENT for the partition table.

Correct Answer: A

Question 10

You are managing an Oracle Database 11 g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk-l -d DATA
Which statement is true regarding the outcome of this command?

A. The command produces an error because the ASM instance is down.

B. The command succeeds but it shows only the status of the ASM instance.

C. The command succeeds but it retrieves only the disk names.

D. The command succeeds and retrieves information by scanning the disk headers based on an ASMJDISKSTRING value.

Correct Answer: D

Question 11

You are managing an Oracle Database 11 g database. You want to take the of size 100 TB on tape drive, but you have tape drives of only 10 GB each, quickly and efficiently?

A. backup with MAXPIECESIZE configured for the channel

B. intrafile parallel backup

C. parallel image copy backup

D. parallel backup with MAXPIECESIZE configured for the channel

Correct Answer: B

Question 12

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:
1) Preprocess the captured workload.
2) Restart the database in RESTRICTED mode.
3) Set up the Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Arrange the steps required in the correct sequence to accomplish this task on the test machine.

A. 1,4, 5, 3 (2 is not required.)

B. 1,2,4,5,3

C. 2, 1,5,3,4

D. 1,4, 3, 5 (2 is not required.)

E. 1, 2,4, 5 (3 is not required.)

Correct Answer: A

Question 13

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

A. Unique local indexes cannot be created on a system-partitioned table.

B. Only a single partitioning key column can be specified.

C. The same physical attributes must be specified for each partition.

D. All DML statements must use partition-extended syntax.

E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Correct Answer: A,E

Question 14

You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recover catalog owned by RC011. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:
RMAN> CONNECT CATALOG rco1 1/password@catdb
RMAN> IMPORT CATALOG rcat1 0/oracle@inst1 DBID=1423241,1423242;
What happens if the RC011 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

A. RMAN renames the global scripts that are imported from the RCAT10 catalog.

B. RMAN renames the local stored scripts in the RC011 catalog.

C. The scripts in the RC011 catalog are overwritten.

D. The RMAN session in which the command is executed aborts.

Correct Answer: A

Question 15

In which two aspects does hot patching differ from conventional patching? (Choose two.)

A. It is not persistent across instance startup and shutdown unlike conventional patching.

B. It takes more time to install or uninstall compared with conventional patching.

C. It can be installed and uninstalled via OPatch unlike conventional patching.

D. It consumes more memory compared with conventional patching.

E. It does not require down time to apply or remove unlike conventional patching.

Correct Answer: D,E

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

Latest Update

Useful Links

Contact Us