TestInside1Z0-042V3.23（1--10）

1. In your Oracle 10g database , you have scheduled a job to update the optimizer statistics at 05:00 pm

every Friday. The job has successfully completed. Which three pieces of information would you check to

confirm that the statistics have been collected? (Choose three.)

A. average row size 平均行大小

B. last analyzed date 最后分析时间

C. size of table in bytes

D. size of table in database blocks ----表在数据库中占用的块大小

E. number of free blocks in the free list

F. number of extents present in the table

Answer: ABD

2. You are in the middle of a transaction and very crucial data has been modified. Because of a hardware

failure, the instance has shut down before synchronizing all the database files.

Which two statements are true? (Choose two.)

A. On startup, SMON coordinates instance recovery. ----------

系统监控(smon) ：检查数据库的一致性如有必要还会在数据库打开时启动数据库的恢复

B. On startup, CKPT coordinates instance recovery.

C. On startup, use RMAN to perform instance recovery.

D. Uncommitted changes will be rolled back after the database is opened. --------------数据库打开以后，未COMMIT的操作进行ROLLBACK

E. On startup, perform media recovery and then instance recovery.

F. On startup, all the files will be synchronized and you get both committed and uncommitted data.

Answer: AD

3. You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your

database.

Which type of script does the backup scheduler generate?

A. SQL script

B. PL/SQL script

C. Operating System (OS) script

D. Enterprise Manager (EM) script

E. Recovery Manager (RMAN) script

Answer: E ----------------------不明白

4. You executed the following command to export the EMPLOYEES table from a remote machine:

$ EXPDP hr/hr@data.us.oracle.com

DUMPFILE=my_dir:exp_hr.log

LOGFILE=data_pump_dir:log_hr.log

TABLES=employees

What would be the outcome of this command?什么是这个命令的结果？

A. The command would execute successfully and the export dump file would be created in the destination

of the directory object MY_DIR.

B. The command would execute successfully. But log file would not be created as DATA_PUMP_DIR

directory is only accessible to user with SYSDBA privilege.

C. The command fails with an error because DATA_PUMP_DIR directory have higher precedence over

the per­file directory.

D. The command fails with an error because no absolute path is specified for log file and dumpfile.

Answer: A

5. Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in

iSQL*Plus?

A. The user must be granted the database administrator (DBA) privilege.

B. The user must be listed in the password file for the authentication.

C. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

D. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant

the webDba role to the user.

Answer: D ------------------------------------------------------------------------------------------------------

6. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are

correct? (Choose two.)

A. This clause is not valid for a temporary or undo tablespace. -------对UNOD和TEMP表空间无用NOT VALID

B. If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.

C. The tablespace will be in the NOLOGGING mode by default, if not specified while creating a

tablespace.

D. The tablespace­level logging attribute can be overridden by logging specifications at the table, index,

materialized view, materialized view log, and partition levels.

Answer: AD

7. Which two statements are true about the primary key constraint in a table? (Choose two.)

A. It is not possible to disable the primary key constraint. 不能让主键失效，错误

B. It is possible to have more than one primary key constraint in a single table. ------------一个表中可以有多个主键错误

C. The primary key constraint can be referred by only one foreign key constraint. ---------一个主键只能定义一个外键错误

D. The primary key constraint can be imposed by combining more than one column.-----通过多个字段组合主键对

E. The non­deferrable primary key constraint creates an unique index on the primary key column if it is not

already indexed.------如果不存在索引，会建一个唯一性索引在这个主键上

Answer: DE

8. You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is

通过远程的一个机子使用APP_DBA用户，授予了DBA角色，认证这个用户

granted the SYSDBA privilege to perform administrative tasks on the database.

Which file is used by the Oracle database server to authenticate APP_DBA?

A. control file

B. password file

C. listener controller file

D. control file and password file

Answer: B

9. Which three statements are true regarding the logical structure of the Oracle database? (Choose

three.)

A. Each segment contains one or more extents. ---------每个段包含一个或者多个区

B. Multiple tablespaces can share single data file. -多个表空间使用同一个数据文件，不正确

C. A data block is the smallest unit of I/O for data files. 一个数据块是最小的数据文件单位

D. It is possible to have tablespaces of different block sizes in a database. 不通的块大小

E. Each data block in the database always corresponds to one OS block.数据块对应什么操作系统块

Answer: ACD

10. Which is the memory area that is created when a dedicated server process is started, and contains

data and control information for that server process?

A. SGA

B. PGA

C. Shared Pool

D. Streams Pool

Answer: B