OCP 1Z0-023 学习讨论区

cainiao_606

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

ningshumin

10.d  21 d e. i am sure of that since there is a mark in the book: Sort segment information is available from V$SORT_SEGMENT and current sort activity from V$SORT_USAGE.

bluce-c

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 是很肯定,student guide 有

bluce-c

最初由 33281 发布
[B]请问：
1此参数是initial parameter吗？
2它是如何触发CKPT的？
3请前辈们讲讲它的用法
谢谢 [/B]

参考意见。应该是initial parameter。the parameter improves the performance of crash and instance recovery. The smaller the value the better the recovery performance. When teh parameter is set  ,the dbwn writes dirty buffers out more aggressively.

leslie chen

fast_start_io_target = n 可以理解成每当读取了n个data block就应触发一次CKPT
log_checkpoint_internal = n 可以理解成每当读取了n个redo log block就应触发一次CKPT
log_checkpoint_timeout = n 可以理解成每隔多少秒就应触发一次CKPT (default is 1800)
ORACLE SERVER每次自动比较这三个值，取其中最近的一点产生CKPT

leslie chen

按照书上15-28 页的步骤，在执行第二步exp时出错：
exp sys/change_on_install file=d:\ts.dmp transport_tablespace=y tablespaces=users
提示如下信息：
EXP-00044: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import
我已经将sys用户加入到了pwdorcl中，且使用internal/oracle也是同样的错误。
我还要做什么呢？

freezr

最初由 leslie chen 发布
[B]fast_start_io_target = n 可以理解成每当读取了n个data block就应触发一次CKPT
log_checkpoint_internal = n 可以理解成每当读取了n个redo log block就应触发一次CKPT
log_checkpoint_timeout = n 可以理解成每隔多少秒就应触发一次CKPT (default is 1800)
ORACLE SERVER每次自动比较这三个值，取其中最近的一点产生CKPT [/B]

对于log_checkpoint_internal和log_checkpoint_timeout，你上面讲的都是ORACLE8中的意思，在8I中有所改变。log_check_internal的意思不再是每当LGWR写一定数量的BLOCK到REDO LOG BLOCK就触发CKPT，而是CKPT在REDO LOG FILE还差一定数量就要满时触发。举个例子，REDO LOG FILE的大小是2000个OS BLOCKS，如果此参数设定为500，那么REDO LOG FILE在1500个OS BLOCKS被写满时，产生CKPT。
同样，log_checkpoint_timeout也变成了这个意思。不再只是定时的间隔。变成checkpoint position in the redo log
file to a location where the end of the log file was this many seconds ago.
fast_start_io_target 是限制在DIRTY BUFFER的数量。为了限制恢复时所需的BLOCK数量。

upzero

1.  you need to execute the stored java program units in the databse,what should you do to allow this functionality: A
A)        Install the Jserver compent
B)        Use the DBMS-SESSION package
C)        Use the DBMS-UTILITY package
D)        Execute the catpro.sql script

2.        which SQL*loader parameter specifies the number of logical records to load? C
A)log    B)ROWS    C)LOAD    D)BINDSIZE

3.You Query V$session and find that the STATUS column for user Chan is marked as killed,what was occurred? B
A)        user Chan’s session was active when it was terminated;
B)        user Chan’s session was inactive when it was terminated ;
C)        user Chan’s has abnormally disconneted from the database;
D)        user chan’s created more than one session in the current instance;

4. if you altered the Nls_CALENDER parameter for your session,which data dictionary view would you query to display the value of the parameter? B
A)        DBA_CATALOG
B)        NLS-SESSION_PARAMETER
C)        NLS-DATABASE_PARAMETERS
D)        NLS-INSTANCE_PARAMETER

5.You need to administer the PROD database from a remote location, but you do not have access to a secure connection, which authentication method should you use? D
A)        O/S authentication
B)        Remote authentication
C)        Server manager privileges
D)        Password file authentication

6.the ORDER table will have very high concurrent usage, which type of segment should you use to create this table? B
A)        table
B)        table partition
C)        rollback segment
D)        temporary segment

7.You are creating an index for a table and are considering a value for INITRANS for this index ,how should INITRANS be set for this index relative to the INITRANS value already set for the corresponding data type? A
A)        higher than the table
B)        lower than the table
C)        equal to the table

8.what would you do if your database has two redo log groups and groups 2 becomes corrupted? C
A)        Drop groups 2 and add a new group
B)        Drop all the groups and issue the Alter Database Add Logfile command
C)        Reinitalize the log files in groups 2 with the Alter Database Clear Logfile command
D)        Clear Group 2 by issusing the Alter Database Clear Logfile command ,drop the group, and creat a new group;

9.you want to redistribute object ownership of the contents of the table froom one userto another which method should you use to move the data between these two users? C
A)        Direct-load insert
B)        SQL*Loader direct path
C)        Export /Import utilities
D)        SQL*loader conventional path

10.if you query V$log and find that group 3 is INACTIVE.what can be said about this group? D
A)        The group has never been written to
B)        The file can currently be written to
C)        The group does not need to be archived
D)        The group s no longer needed for instance recovery

11.what is the MAXIMUM number of control files that you can specify in the control-files parameters?  C
        A)2                B)4          C)8                D)12         E)16     F) unlimited

12. what would you use an EXCEPTION table?  D
A)        to identify disabled constraints
B)        to disable constraints for a data load
C)        to verify the structural integrity of a table
D)        to identify rows that violate a constraint that is being enabled.

13.which statement about role is True? A
A)        No user owns a role;
B)        If a user is granted a role and the with Admin Option, the user cannot alter the role
C)        A user who is granted a role is implicitly assigned the role and the With Admin Option
D)        A user must be assigned a role and the With Admin Option to grand the role to another user

14.which user is automatically granted the DBA role and owns the data dictionary base tables and views: A
        A)SYS    B)SYSTEM  C)SYSDBA   D)SYSOPER

15.which two statements about the Alter Index Rebuild command are true? B E
A)        A bitmap index can be changed to a B-tree index using the Alter Index Rebuild command
B)        The Alter Index Rebuild command can be used to relocate an index to a different tablespace
C)        The Alter Index Rebuild command cannot to rebuild a B-tree index to a reverse index.
D)        The Deallocate clause of the Alter Index command can be used to release all unused space in an index
E)        The Alter Index Rebuild command can be used to increase the MAXEXTENTS parameter for an index.

16.which encoding schema class is defined as the AscII American standard character set? B
A)        Unicode
B)        Single_byte 7bit
C)        Single-byte 8bit
D)        Fixed-width multibyte
E)        Varying-width multibyte

17.what does the externally option do when creating a user with the creator user command:  D
A)        allows the user remote access
B)        allow the user network access
C)        allows the user database access without a password
D)        specifies that the user must be authenticated by the operating system

18.You are administering password setting for a profile,which parameter would you use to ensure that a user does not reuse their current password before their password changes have occurred? D
A)        PASSWORD-GRAC-TIME
B)        PASSWORD-LIFE-TIME
C)        PASSWORD-REUSE-TIME
D)        PASSWORD-REUSE-MAX
E)        PASSWORD-VERIFY-FUNCTION

19.why must you recreated the control file f your change the MAXDATAFILE parameter for the PROD database? B
A)        to update it with the new datafiles
B)        to reallocate the space needed for the parameter
C)        to update it with the current version of the parameter file
D)        to update it with any changes made to any of the initialization parameter

20.which parameter should you increase to avoid excessive row migration?  A
        A)PCTFREE    B)PCTUSED    C)MAXEXTENTS  D)PCINCRASE

21.You created a databse and specified these storage parameter?
   INITIAL 50K
   NEXT 20K
   PCTINCREASE 30
If the storage value default to the tablespace values for all the segments in the tablespace, what is the size of the first extend allocated to the tablespace?  c
        A)20k   B)30K  c)50K  d)70K

22.You want to choose a data type that will allow you to store multiple email addresses for each record in the CONTACT table,which data type should you choose for the Email column? c
A)        ref
B)        table
C)        array
D)        varchar2
E)        nvarchar2

23.which command would you use to disable a constraint? A
A)        Alter table
B)        Drop constrain
C)        Remove constraint
D)        Delete constraint
备注：Alter Table table-name Disable Constraints table-name-ok
use the CASCADE option to disable a PK referenced by a foreign key so that the foreign key is disabled before the PK is disabled.

24.which two events can cause a DB event trigger to fire: A E
A)        creating a user
B)        creating a DB
C)        Executing a procedure
D)        Altering an instance parameter
E)        Adding a constrain to an existing table
  备注：可能引发触发器的事件：
（1）        An instance startup or shutdown
（2）        A specific error message or any error message
（3）        A user logon or logoff
（4）        A CREATE,ALTER or DROP statement in any schema

25.which files records checkpoints information used during DB recovery? D
        A)datafiles  B)alert logs   C)trace files   D)control files  E)parameter file

26.The default method of space management for a tablespace is ( Dictionary)-managed.
   另外一个表格空间管理的是Locally-managed；
   The data dictionary manages the extents. Dictionary_managed tablespace can contain both permanent and temporary segments.

27.Using the password utility ORAPWD ,you create a password file with a password of “private”.How could you change the password? A
A)        Delete and recreate the password file
B)        Use the ORAPWD utility to overwrite the password file
C)        Use the Alter Database command to change the password
D)        Use the Alter System command to change the appropriate initialization parameter

28.which table cannot be accomplished using the Alter Index Command? D
A)        coalseing an index
B)        rebuilding an online index
C)        moving an index to a different tablespace
D)        Changing the size of an existing index using the RESIZE keyword.
该命令可做的动作：
（1）        to move an index to a different tablespace;
（2）        remove deleted entries
（3）        change a reverse key index to a normal B-tree index or a Norman B-tree index to a reverse key index.
（4）        To change the index parameter
（5）        Indexes can be rebuilt online using the Online keyword or can be coalesced using the COALESCE keywords

29.which two command could you use to immediately allocate more space to an existing tablespace:  A B
A)        ALTER TABLESPACE ADD DATAFILE
B)        ALTER DATABASE DATAFILE RESIZE
C)        CREATE TABLESPACE DATAFILE SIZE
D)        ALTER TABLESPACE MINIMUM EXTENT
E)        ALTER TABLESPACE DEFAULT STORAGE

30.You need to verify the structure of the LAB_RESULT table before it is backed up. Which option could you use with the ANALYZE TABLE command to check this table for corruption? A
A)        validate structure
B)        compute statistics
C)        estimate structure
D)        validate statistics

upzero

我自己这门还没有考试呢，正在准备，若刚过的同志希望给点意见，我也只是将自己整理出来的东西分享给大家，希望多少对正在努力的同志有用！
   有你有我，这个世界将不再寂寞！
31.while setting up password file authentication ,you set the REMOTE-LOGIN-PASSWORDFILE initalization parameter to SHARED,which two will be recognized bye the password fiel?  A E
        A)sys   B) sysdba   C)system  D)sysoper   E)internal
备注：to set up password file authentication:
(1)        use the ORAPWD on UNIX or WINNT to create a password file
(2)        set the Remote-Login-Passwordfile initalization to EXECLUSIVE(for only one instance) or SHARED (for multiple instance) If you use the SHARED option,the password file will only reorgnize user SYS and INTERNAL.
(3)        When connecting to the DB,you must provide a valid username and password .This is an example connect string: CONNECT internal/oracle                       
When using the password utility to create a password file,you must specify a file name and location, a password for the SYS and INTERNAL users, and the manximum number of DBAs using the password file.

32.The REMOTE-LOGIN-PASSWORD-FILE initialization parameter is set to EXECLUSIVE for the PROD DB,which view should you query to determine which users have been granted the SYSOPER privileges? D
        A)v$DATABASE   B)V$INSTANCE   C)V$PARAMETERS  D)V$PWFILE-USERS
备注：when password file authenticated is enabled,V$PWFILE-USERS will display the names of the uses with the SYSDBA or SYSOPER privileges.

33.when a record is inserted into a table,which portion of a DB block holds the records data: B
        A)BLOCK HEADER    B)DATA SPACE   C)FREE SPACE
D)ROW DIRECTORY   E)TABLE DIRECTORY
备注：Each DB block has bytes reserved for the header,free space for growth,and data space. In a database block,row data is stored in the bytes allocated for data space,Data is inserted into the Block from the bottom up.

34.which data dictionary view would you query to display the value of the NLS-SORT value initialized at start up?   D
A)        DBA-CATALOG
B)        NLS-SESSION-PARAMETER
C)        NLS-DATABASE-PARAMETERS
D)        NLS-INSTANCE-PARAMETERS
备注： d）display the values of NLS initialization parameters listed in the parameter file.

35.according to the Optimal Architecture, how should you organize your DB files:  A
A)        directly below the oracle directory
B)        directly below the application directory
C)        directly below the oracle Server Directory
D)        within the appropriate product version directory
备注：The Optimal Flexible Architecture is a set of guidelines created by Oracle that provide a template for configuring oracle system.The OFA recommends that DB files be placed in directories directly below the oracle directory. DB file include datafiles, control files and redo log files.

36.whici Export utility keyword allows associated triggers to be included with a table during an Export when run by a privileges user? C
        A)ROWS  B)DIRECT  C)TABLES  D)PARFILE  E)CONSISTENT  F)CONSTRAINT

37.which benefit does oracle Fast Commit offer?  C
A)        transactions are immediately written to the datafiles
B)        smaller transactions are processed more quickly than large one
C)        minimal information is required to record the changes in the redo logs.
D)        Transactions requesting a COMMIT are given priority over other redo log records.
备注：oracle’s Fast Commit allows LGWR to record only the changes and SCN in the redo log files. The size of the transaction does not affect the time required to write to the redo log files. These writes are sequential and faster than writing entire blocks to the datafiles. Writes to the datafiles occur independently of the COMMIT.

38.What are three ways that data integrity can be maintained to ensure that data adhere to the business rules?  B  C F
A)        DB tunning
B)        Application code
C)        DB triggers
D)        Index utilization
E)        DB backup and recovery
F)        Declare integrity constraints

39.which view would a query to display the value assigned to the MAXDATAFIELS parameter for the PROD database:  D
A)        V$database
B)        V$datafile
C)        V$controlfile
D)        V$controlfile-Record-Setction  (displays information stored in the control file)

40. which SHUTDOWN mode will only wait for the pending transaction of a correct user to end before ending their session:  D
        A)ABORT   B)NORMAL  C)IMMEDIATE  D)TRANSACTIONAL
备注: users will be unable to create new session ,no new transactions are allowed and users are not disconnected until their current transaction commits or roll back. When all the transactions have ended. The db is closed and dismounted and the instance is shut down.
Normal Mode: users will wait for all pending transactions to be end and all users to disconnect before shutting down the DB.

upzero

41.The steps to move a tablespace to a write-once device in the appropriate order:
1)        issue the ALTER TABLESPACE READ ONLY command
2)        use o/s commands to copy the file to the device
3)        issue the ALTER TABLESPACE RENAME DATAFILE command
备注：to move a tablespace to read-only media ,such a cd-rom or write-once (wrom) drivers:
(1)        issue the Alter tablespace read only command
(2)        use o/s commands to move the tablespace data files to the read-only device
(3)        issue the Alter Tablespace tablespace Rename Datafile command

42.evaluate this statement:
ALTER PROFILE JUAN LIMIT
CPU-PER-SESSION 3600
IDLE-TIME 30;
How much time will be allowed in the next session for user JUAN? D
A)        60 hours of cpu time and 30 minutes of inactivity
B)        60 minutes of cpu time and 30 minutes of inactivity
C)        60 seconds of cpu time and 30 minutes of inactivity
D)        36 seconds of cpu time and 30 minutes of inactivity
E)        36 seconds of cpu time and 30 seconds of inactivity
F)        36minutes of cpu time and 30 minutes of inactivity
备注：
CPU-PER-SESSION is expressed in hundredths of seconds and IDLE-TIME is expressed in minutes.