Oracle 1Z0-053 問題集

質問 1：
You perform a backup using the following BACKUP command:
RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE;
Which statement is true of this command?
A. A different procedure is required to restore a database from compressed backups
B. Using this command to create backups minimizes the bandwidth consumed
C. Using this command to create backups improves the performance of the backup process
D. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.
正解：B

質問 2：
What will be the result of the following configuration?
Log_archive_dest_1 = 'location=c:\oracle\arch\mydb'
Log_archive_dest_2 = 'location=z:\oracle\arch\mydb'
A. Archived redo logs will be created in two different locations by the LGWR process.
B. An error will occur during database startup since you are trying to create archived redo logs in two different locations.
C. Neither parameter setting is valid, so the database will not start up.
D. Archived redo logs will be created in two different locations by the ARCH process.
E. An error will occur during database startup because the second parameter is not valid.
正解：D

質問 3：
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.
You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?
A. None of the tables are recovered from the Recycle Bin, and the statement returns an error.
B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
C. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
D. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
正解：B

質問 4：
What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)
A. NLS_SORT
B. NLS_LANGUAGE
C. NLS_CHARACTERSET
D. NLS_TERRITORY
E. NLS_CALENDAR
正解：B,C,D

質問 5：
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 enhance the query performance by creating a cache in the client memory for sorting operations
B. to avoid the storing of query plans and results in the server by creating a cache in the client memory
C. to avoid round trips to the server by enabling caching of query results in client memory
D. to improve performance by storing a copy of the data from the private SQL area of the PGA
正解：C

質問 6：
A user performs an update on a table. Shortly after committing the transaction, they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state?
A. Flashback Transaction Query
B. Flashback Drop
C. Flashback Query
D. Flashback Versions Query
E. Flashback Table
正解：E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which of the following represents the correct sequence of events for Database Replay?
A. Analyze, capture, preprocess, replay
B. Capture, preprocess, analyze, replay
C. Capture, preprocess, replay, analyze
D. Capture, analyze, preprocess, replay
E. None of the above
正解：C
解説: (Topexam メンバーにのみ表示されます)