OCP 1Z0-023 学习讨论区

feng_xin

最初由 33281 发布
[B]实验环境：
OS：WIN98II
DB：ORACLE PERSON EDITION 8
CONNECT SYS/CHANGE_ON_INSTALL
.....
[/B]

很显然答案不对

Hollie

Why should INITAL and NEXT be set "DB_BLOCK_SIZE+(n*SORT_AREA_SIZE)" when defining DEFAULT STORAGE for a TEMPORARY tablespace?

Hollie

1. What is Wrapped Database Package Utility do?

A. Hide data blocks
B. Organizes PL/SQL packages, Procedures, and Packages  
C. Hide application PL/SQL code for Specification
D. Hide application PL/SQL code for Body

2. Which variable required when creating a database when a character set other than US7ASCII 7-bit character set?

A. Varying-width
B. Fixed-Width
C. ORA-NLS33
D. UNICODE
E. NLS_SORT

请问以上两题应选什么？

33281

请问：
1此参数是initial parameter吗？
2它是如何触发CKPT的？
3请前辈们讲讲它的用法
谢谢

on323

最初由 Hollie 发布
[B]1. What is Wrapped Database Package Utility do?

A. Hide data blocks
B. Organizes PL/SQL packages, Procedures, and Packages  
C. Hide application PL/SQL code for Specification
D. Hide application PL/SQL code for Body

d 不是很肯定

2. Which variable required when creating a database when a character set other than US7ASCII 7-bit character set?

A. Varying-width
B. Fixed-Width
C. ORA-NLS33
D. UNICODE
E. NLS_SORT

肯定是C

请问以上两题应选什么？ [/B]

Hollie

1. Which two files are used by the SQL*Loader? (Choose two.)
A. log file *
B. data file *
C. init.ora file
D. password file
E. background process trace file
为什么不选 c 呢？init.ora 不是parameter file吗？

2. When you created a tablespace,
   you overestimated the size of one of the datafiles.
   Several objects were stored in the datafile.
   Some, but not all of the objects were dropped subsequently.
   To which point will you be able to decrease the size of the datafile?
A. to zero
B. to the size of the datafile header
C. to the last block of the last object  *
D. It is not possible to decrease the size of a datafile.
为什么选 c 呢？

3. Which two commands can cause a database event trigger to fire? (Choose two.)
A. DROP USER   *
B. ALTER VIEW  *
C. CALL PROCEDURE
D. CREATE DATABASE
我的选择正确吗？

4. Which statement about organizing tablespaces and segments is true?
A. You should mix segments with short and long life spans in the same tablespace.
B. You should keep good control over space allocation and define storage limits for users.  *
C. You should use the aotuextend feature on tablespaces that hava a high update, delete, and insert activity.
D. Data that is accessed by multiple users should be stored in tablespaces that reside on the same disk for easier management.
a,c,d为什么不对呢？

5.When creating rollback segments, what is the recommended value for the MINEXTENT minimize dynamic extension?

A. 15
B. 20 *
C. five
D. ten per transaction
E. number_of_users*25

6.How does a DBA specify multiple control files?

A. With the ADD CONTROLFILE command.
B. By using the files in the STARTUP command.
C. With the MULTIPLEX control file command.
D. By listing the files in the CONTROL_FILES parameter. *

7. Which statement about an Oracle instance is true?

A. An Oracle instance can access multiple databases at one time only. *
B. An Oracle instance has a minimum of three background processes.
C. An Oracle instance consists of the shared pool and the redo log files.
D. The memory allocated by an Oracle instance is shareable by the database processes.

5,6,7的选择正确吗？

Hollie

1. self_contained 的含义是什么？
    Why the set of tablespace transported in each run must be
    self_contained.

2. 如何理解profile,profile 如果用中文的话如何翻译?

3. password_grace_time 是指的什么？

4. 如何理解教材中的这句话？
   Because the roles must be granted before they can be made
    defaults,you can't set default role with create user.

5. 能否解释一下 reverse key index,什么时候用reverse key   index.


谢谢各位啦！

cainiao_606

10. What is Wrapped Database Package Utility do?

A. Hide data blocks
B. Organizes PL/SQL packages, Procedures, and Packages
C. Hide application PL/SQL code for Specification
D. Hide application PL/SQL code for Body

21. Which two dynamic performance views could you join to determine the number of extents being used by an active sort?

A. V$SESSION
B. V$ROLLSTAT
C. V$TRANSACTION
D. V$SORT_USUAGE
E. V$SORT_SEGMENT

32. Which data dictionary view would you query to determine the number of empty blocks in a table after issuing the ANALYZE TABLE command?

A. DBA_TABLE
B. DBA_TABLES
C. DBA_OBJECT
D. DBA_OBJECTS
E. DBA_EXTENT
F. DBA_EXTENTS

35. Which statement about ALTER INDEX REBUILD command is true?

A. Sorts are needed when an index is built using an existing index
B. The old is index is kept even though new index is built
C. Change a reverse key index to a normal B-tree index.
D. Moving index into a same tablespaces

52. Which statement is true about roles?

A. Users can have more than one default roles
B. A role cannot be temporary revoked from a user by disabling the role
C. A user’s default role is enabled when the user logs on
D. ALTER ROLE command enables and disables roles

我的答案是： 10 b   21 bc 32 b 35 c 52 c   如有不对请大家指出！谢谢！！

Hollie

10.c 拿不准 ,21.ad可以肯定，其他与你一样。

cainiao_606

为什么？能不能说的详细一点，谢谢！！