OCP 1Z0-023 学习讨论区

upzero

1.Which script provides wrapped package code?
A)cat*.sql
B)utl*.sql
C)prvt*.sql  *
D)dbms*.sql
备注：
prvt*.plb is an administrative script and provides wrapped package code. Wrapped database package code is used to extend the oracle sever functionality.

dbms*.sql defines the database package specifications.
cat*.sql provides catalog and data dictionary information.
utl*.sql creates views and tables for database utilities.

2.which privileges is needed to assign a profile to an existing user?
A)Alter User *
B)Create User
C)Alter Profile
D)Create Profile
note:
To assign a profile to an existing user,issue the Alter User command.
To assing a profile to a new user,include the Profile clause in the Create User command.

3.What does the initialize parameter LOG_ARCHIVE_START indicate?
A)the number of redo log groups
B)if automatic archiving is enabled *
C)the destination of the archive log files
D)if the database is in NOARCHIVELOG mode
note:
The initialization parameter LOG_ARCHIVE_START indicates whether automatic archiving is enabled when an instance starts.A value of TRUE indicates that archiving is automatic.The ARCHIVE LOG LIST command to determine if automatic archiving enabled.

4.How would you create an EXCEPTIONS table?
A)Use the CREATE TABLE command
B)Execute the catproc.sql script
C)Execute the utlexcpt.sql script  *
D)Use the Alter Table command with the EXCEPTION clause
note:
  Execute the utlexcpt.sql script to create an EXECPTIONS table.Issue the ALTER TABLE command with the EXECPTIONS clause to link a table with the EXCEPTIONS table.Query the EXCEPTIONS table to identify invalid data. Corrct any errors.

5.what does the initialization parameter LOG_ARCHIVE_START indicate?
A)the number of redo log groups
B)if automatic archiving is enabled *
C)the destination of the archive log files
D)if the database is in NORCHIVELOG mode
note:
  The initialization parameter LOG_ARCHIVE_START indicates whether automatic archiving is enabled when an instance starts.A value of TRUE indicates that archiving is automatic.The default value is FALSE,and the filled redo log files must be manually archived.Execute the ARCHIVE LOG LIST command to determine if automatic archiving is enabled.

upzero

我不久考试，感觉对于这门比较怕怕，因此希望刚过的同志能有机会到这里发表以下意见，提供给我们做参考！
  我贡献了自己几天下来的努力结果，希望大家也发扬以下乐于助人的精神！

roycai

題有異議
我認為應選擇C

upzero

sorry, it is a mistake .
thank you !I have correct it as you can see!

最初由 roycai 发布
[B]題有異議
我認為應選擇C [/B]

bluce-c

hi,38题好象少了个C选项。多谢你的好东东。

bluce-c

最初由 upzero 发布
[B]我不久考试，感觉对于这门比较怕怕，因此希望刚过的同志能有机会到这里发表以下意见，提供给我们做参考！
  我贡献了自己几天下来的努力结果，希望大家也发扬以下乐于助人的精神！ [/B]

hi,38题你好象少了个C 。多谢你的好东东。

bluce-c

不好意思，多按了一次。请原谅。

susan_j

最初由 feng_xin 发布
[B]

我认为应该是
1. b     2. a   3. acd [/B]

我也认为是。

upzero

呵呵，我在2002-1-27日上午三十分钟通过了023，感觉还好，42过，我通过了53题！
希望后面的同志们好好加油哦！

upzero

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

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

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

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.

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.

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.