Oracle 1Z0-045 問題集

質問 1：
You have three temporary tablespace groups named G1, G2, and G3 in your database.
You are creating a new temporary tablespace as follows:
CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP '';
Which statement regarding the above command is correct?
A. It will create a new group with a system-generated name and add thetablespace TEMP1 to it.
B. It will create thetablespace TEMP1 in the default group.
C. It will create thetablespace TEMP1 in group G1.
D. It will not add thetablespace TEMP1 to any group.
E. It will throw an error with message 'specified group is not available'.
F. It will create thetablespace TEMP1 in group G3.
正解：D

質問 2：
You define the Warning threshold for the tablespace usage metric for the USERS tablespace to be 35%. Because of this, several alerts are being raised. After observing this, you decide to increase the Warning threshold and clear all old alerts related to tablespace usage metric. Where would you find the information about cleared alerts?
A. the V$ACTIVE_SESSION_HISTORY data dictionary table
B. the alert.log file
C. the DBA_OUTSTANDING_ALERTS data dictionary table
D. the DBA_ALERT_ARGUMENTS data dictionary table
E. the DBA_TAB_STATS_HISTORY data dictionary table
F. the DBA_ALERT_HISTORY data dictionary table
正解：F

質問 3：
You executed the following command to drop a user:
DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)
A. Any objects in the Recycle Bin belonging toscott are purged.
B. All the objects ofscott in the Recycle Bin must be purged before executing the DROP command.
C. All the objects ofscott are moved to the Recycle Bin.
D. Any objects in the Recycle Bin belonging toscott will not be affected by the above DROP command.
E. All the objects owned byscott are permanently dropped from the database.
正解：A,E

質問 4：
Examine the following parameter settings from an initialization (init.ora) file:
DB_CREATE_FILE_DEST = '/u01/oradata/' DB_CREATE_ONLINE_LOG_DEST_1 = '/u02/oradata/' DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata/' If you create an Oracle Managed Files (OMF) database using these settings, what is the result?
A. The data files and temp files will be on device /u01; one copy of the control file and one online redo log group will be on device /u02; another copy of the control file and a second redo log group will be on device /u03.
B. The data files, temp files, and control file will be on device /u01; one online redo log group will be on device /u02; another redo log group will be on device /u03.
C. The data files and temp files will be on device /u01; one copy of the control file and the first member in each online redo log group will be on device /u02; another copy of the control file and a second member of each redo log group will be on device /u03.
D. The data files, temp files, online redo log files, and control file will be on device /u01; multiplexed copies of the archive log files will be created: one set on device /u02, and another set on device /u03.
正解：C

質問 5：
Which three statements are true about the privileged connection options available in Oracle 10g? (Choose three.)
A. The listener must be running to make a connection.
B. The CONNECT INTERNAL is disallowed.
C. The use of a remote password login file (orapwd) is unchanged.
D. The Server Manager tool is no longer supplied.
正解：B,C,D

質問 6：
When you are performing a backup, the Flash Recovery Area is low on free space. Under which two circumstances would warnings be issued to you? (Choose two.)
A. When the used space is at 85%, a warning is issued.
B. When the used space is at 90%, a warning is issued.
C. When the used space is at 95%, a warning is issued.
D. When the used space is at 95%, a critical warning is issued.
E. When the used space is at 97%, a critical warning is issued.
F. When the used space is at 99%, a critical warning is issued.
正解：A,E

質問 7：
Oracle provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing the dbms_redefinition.start_redef_table procedure call? (Choose two).
A. invoke thedbms_redefinition.sync_interim_table procedure
B. create any triggers, indexes, or constraints on the interim table
C. create an empty interim table with all the desired characteristics
D. grant privileges on the interim table
E. invoke thedbms_redefinition.can_redef_table procedure
正解：C,E