最新的Oracle Database 11g認證 11gocmu考試題庫

問題1

What can you determine about the following linguistic sorts based only on their names?
1.GERMAN
2.FRENCH_M

A. Case sensitivity is unknown.

B. Both 1 and 2 are case insensitive.

C. 1 is case insensitive.

D. 2 is a monolingual sort.

E. 1 is a monolingual sort.

正確答案: E

問題2

You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:
ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;
What is the implication of this command?

A. All historical data older than three years is purged from the flashback archive FLA1.

B. The command produces an error because the retention time cannot be reduced.

C. All historical data is purged and the new flashback data archives are maintained for three years.

D. All historical data is retained but the subsequent flashback data archives are maintained for only three years.

正確答案: A

問題3

What is the correct order of steps to perform an online database backup?
a.alter database begin backup;
b.alter database end backup;
c.Back up the database datafiles.
d.Back up the archive log files.
e.alter system switch logfile;

A. a, b, c, d, e

B. a, c, b, d, e

C. a, c, b, e, d

D. d, b, c, a, e

E. e, d, a, b, c

正確答案: C

問題4

Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)

A. This is the correct way to address this problem.

B. The command restores only the missing control file.

C. This is not the correct way to address this problem.

D. The command restores all the control files.

E. The command fails because the database is running.

正確答案: C,E

問題5

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 remains encrypted when it is read into memory.

B. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

C. The data remains encrypted when it is stored in the redo logs.

D. The data is decrypted during SORT and JOIN operations.

正確答案: C

問題6

Which statement is true regarding the VALIDATE DATABASE command?

A. It checks the database for both intrablock and interblock corruptions.

B. It checks the database for intrablock corruptions only.

C. It checks for block corruption in the valid backups of the database.

D. It checks for only those corrupted blocks that are associated with data files.

正確答案: B

問題7

After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:
Select group_number, count(*) from v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?

A. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.

B. The drop disk operation is complete and you can run the undrop disks command if needed.

C. None of the above is true.

D. The drop disk operation is complete and you cannot run the undrop disk command.

E. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.

正確答案: D

問題8

Which of the following tasks does the tool Incident Packaging Service (IPS) perform?

A. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.

B. Displays a high-level view of critical errors on the database home page.

C. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.

D. Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.

正確答案: A

問題9

Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal.
Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.)

A. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.

B. Increase the number of slave database writer processes by setting up a higher value for
DBWR_IO_SLAVES.

C. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

D. Define the POWER option while adding or removing the disks.

正確答案: C,D

問題10

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

A. flashback the database to before the transaction was committed

B. execute the ROLLBACK command with transaction number

C. point-in-time recovery

D. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

正確答案: D

問題11

When you create a backup control file, where is the resulting file written to?

A. The database user dump destination directory

B. To $ORACLE_HOME/rdbms

C. The database diagnostic destination directory

D. To the directory and filename you specify in the command

E. To $ORACLE_HOME/admin

正確答案: D

問題12

If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

A. The alter database archivelog command will succeed.

B. The alter database archivelog command will fail.

C. The alter database archivelog command will ask if you want to make the database consistent first.

D. There is no alter database archivelog command. The correct command is alter database alterlogging.

E. The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG mode.

正確答案: B

問題13

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS,
user_specified_size US
FROM v$memory_dynamic_components
WHERE current_size!=0;
What do you infer from this?

A. The database instance is running with manual shared memory management.

B. The database instance has the MEMORY_TARGET value set to a nonzero value.

C. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

D. The database instance is running with manual PGA management.

正確答案: B

最新的Oracle Database 11g Certified Master Upgrade - 11gocmu免費考試真題

最新更新

站內鏈接

聯系我們