Oracle 1Z0-045 問題集

質問 1：
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

質問 2：
You need to create a schedule that will run a job on the second Friday of each month. What should the repeat interval of the schedule be set to?
A. FREQ = MONTHLY; BYDAY = 2FRI;
B. FREQ = MONTHLY; BYDAY = -2FRI;
C. FREQ = MONTHLY; BYDAY = FRI(2);
D. FREQ = MONTHLY; BYDAY = FRI2;
正解：A

質問 3：
You enabled Flashback Database with the following command:
ALTER DATABASE FLASHBACK ON;
Which view would you query to determine whether the Flashback Database has been enabled?
A. V$FLASHBACK_DATABASE_LOG
B. V$FLASHBACK_DATABASE_LOGFILE
C. V$FLASHBACK_DATABASE_STAT
D. V$SGA
E. V$INSTANCE
F. V$DATABASE
正解：F

質問 4：
Examine the following command to create an external table from EMPLOYEES and DEPARTMENTS database tables.
1.CREATE TABLE employee_ext
2.(employee_id, first_name, last_name, department_name)
3.ORGANIZATION EXTERNAL
4.(
5.TYPE ORACLE_LOADER
6.DEFAULT DIRECTORY ext_dir
7.LOCATION ('emp1.dmp')
8.)
9.PARALLEL
10.
AS
11.
SELECT e.emplyee_id,e.first_name,e.last_name,d.department_name
12.
FROM employees e, departments d;
Which line of the command would cause an error?
A. line 2, because the column names have been specified
B. line 12, because there is no join defined between EMPLOYEES and DEPARTMENTS tables
C. line 3, because ORGANIZATION EXTERNAL has been specified
D. line 5, because ORACLE_LOADER is not a valid structure for external table creation with the SELECT statement
E. line 9, because the PARALLEL option cannot be specified with one file name
F. line 7, because the file name must have a .dat extension
正解：D

質問 5：
You have the following requirements with respect to optimizer statistics:
The statistics should be generated automatically during weekdays (Monday to Friday) between
10:00 p.m. and 7:00 a.m.
The objects that need updated statistics the most should be processed first.
What would you do?
A. Modify the duration of the default WEEKNIGHT_WINDOW scheduler window to 10:00 p.m.?:00
a.m.
B. Use the DBMS_STATS.GATHER_DATABASE_STATS procedure with the GATHER AUTO option.
C. Modify the AUTO_TASKS_JOB_CLASS Scheduler class.
D. Not make any modifications, because by default the WEEKNIGHT_WINDOW scheduler window automatically generates statistics during weekdays between 10:00 p.m. and 7:00 a.m.
正解：A

質問 6：
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

質問 7：
Which three parameters are ignored when creating an automatic space management segment? (Choose three.)
A. INITRANS
B. FREELISTS Change it to FREELIST
C. MAXTRANS
D. PCTFREE
E. PCTUSED
F. FREELIST GROUPS
正解：B,E,F