[Q][031]Discuss Together

xmzw

QUESTION NO: 103
When an Oracle instance is started, background processes are started.
Background processes perform which two functions? (Choose two.)
A. Perform I/O
B. Lock rows that are not data dictionary rows
C. Monitor other Oracle processes
D. Connect users to the Oracle instance
E. Execute SQL statements issued through an application
Answer: A, B            


我选择A,C

xmzw

QUESTION NO: 130
Examine the list of steps to rename the data file of a non-SYSTEM tablespace HR_TBS.
The steps are arranged in random order.
1. Shut down the database.
2. Bring the HR_TBS tablespace online.
3. Execute the ALTER DATABASE RENAME DATAFILE command
4. Use the operating system command to move or copy the file
5. Bring the tablespace offline.
6. Open the database.
What is the correct order for the steps?
A. 1, 3, 4, 6; steps 2 and 5 are not required
B. 1, 4, 3, 6; steps 2 and 5 are not required
C. 2, 3, 4, 5; steps 1 and 6 are not required
D. 5, 4, 3, 2; steps 1 and 6 are not required
E. 5, 3, 4, 1, 6, 2
F. 5, 4, 3, 1, 6, 2
Answer: D

这题题目似乎有些问题
3改为ALTER TABLESPACE RENAME DATAFILE答案就是D了

xmzw

QUESTION NO: 141
You are in the planning stages of creating a database. How should you plan to influence the size of the control file?
A. Specify size by setting the CONTROL_FILES initialization parameter instead of using the Oracle default value.
B. Use the CREATE CONTROLFILE command to create the control file and define a specific size for the control file.
C. Define the MAXLOGFILES, MAXLOGMEMBERS, MAXLOGHISTORY, MAXDATAFILES, MAXINSTANCES parameters in the CREATE DATABASE command.
D. Define specific values for the MAXLOGFILES, MAXLOGGROUPS, MAXLOGHISTORY, MAXDATAFILES, and MAXINSTANCES parameters within the initialization parameter file.
Answer: D           

我选择C

xmzw

QUESTION NO: 146
Your company hired Joe, a DBA who will be working from home. Joe needs to have the ability to start the database remotely.You created a password file for your database and set REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE in the parameter file.
Which command adds Joe to the password file, allowing him remote DBA access?
A. GRANT DBA TO JOE;
B. GRANT SYSDBA TO JOE;
C. GRANT RESOURCE TO JOE;
D. orapwd file=orapwdPROD user=JOE password=DBA
Answer: D         

我选择B

lwn123

最初由 xmzw 发布
[B]QUESTION NO: 74
You set the value of the OS_AUTHENT_PREFIX initialization parameter to OPS$ and created a user account by issuing this SQL statement:
CREATE USER OPS$smith
IDENTIFIED EXTERNALLY;
Which two statements are true? (Choose two.)
A. Oracle server assigns the DEFAULT profile to the user.
B. You can specify the PASSWORD EXPIRE clause for an external user account.
C. The user does not require CREATE SESSION system privilege to connect to the database.
D. If you query the DBA_USERS data dictionary view the USERNAME column will contain the value SMITH.
E. The user account is maintained by Oracle, but password administration and user authentication are performed by the operating system or a network service.
Answer: C, D

我选择A,D [/B]

答案D，我试验过了，在数据字典中查询到的用户名就是OPS$smith
很令人疑惑，不过事实就是这样

xmzw

答案有两个
我查的是SMITH

liu

Hello Everyone,

Make sure you all get the updated TK 031. version 3.0 from here.

http://www.itpub.net/showthread. ... 47&pagenumber=2

supexplorer

I am reading books now. I will talk with your guys soon when I read test king.

shyu1

Good news for everyone!
http://www.itpub.net/showthread.php?s=&threadid=56100

无边落木

I'am tring to pass 031 at the end of September or at the begining of October, any one has the same schedule as me?