TestKing Oracle 9i 1z0-031 ...

[ Pobierz całość w formacie PDF ]
Oracle 1z0-031
Oracle 9i
Database Fundamentals I
Version 7.0
1z0-031
Important Note
Please Read Carefully
Study Tips
This product will provide you questions and answers along with detailed explanations carefully
compiled and written by our experts. Try to understand the concepts behind the questions instead
of cramming the questions. Go through the entire document at least twice so that you make sure
that you are not missing anything.
Further Material
For this test TestKing also provides:
* Interactive Test Engine Examinator. Check out an Examinator Demo at
Latest Version
We are constantly reviewing our products. New material is added and old material is revised.
Free updates are available for 90 days after the purchase. You should check your member zone at
TestKing an update 3-4 days before the scheduled exam date.
Here is the procedure to get the latest version:
1.
Go to
www.testking.com
2.
Click on
Member zone/Log in
3.
The latest versions of all purchased products are downloadable from here. Just click the
links.
Feedback
Feedback on specific questions should be send to feedback@testking.com. You should state:
Exam number and version, question number, and login ID.
Our experts will answer your mail promptly.
Copyright
Each pdf file contains a unique serial number associated with your particular name and contact
information for security purposes. So if we find out that a particular pdf file is being distributed
by you, TestKing reserves the right to take legal action against you according to the International
Copyright Laws.
Leading the way in IT testing and certification tools,
www.testking.com
- 2 -
For most updates, it is enough just to print the new questions at the end of the new version, not
the whole document.
1z0-031
Note:
Section A contains 150 questions.
Section B contains 55 questions.
The total number of questions is 205.
Section A
QUESTION NO: 1
You intend to use only password authentication and have used the password file utility to
create a password file as follows:
$orapwd file=$ORACLE_HOME/dbs/orapwDB01
password=orapass entries=5
The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE.
You created a user and granted only the SYSDBA privilege to that user as follows:
CREATE USER dba_user
IDENTIFIED BY dba_pass;
GRANT sysdba TO dba_user;
The user attempts to connect to the database as follows:
connect dba_user/dba_pass as sysdba;
Why does the connection fail?
A.
The DBA privilege was not granted to dba_user.
B.
REMOTE_LOGIN_PASSWORDFILE is not set to EXCLUSIVE.
C.
The password file has been created in the wrong directory.
D.
The user did not specify the password orapass to connect as SYSDBA.
Answer: B
Setting REMOTE_LOGIN_PASSWORDFILE to
exclusive
means that a password file exists and
any user/password combination in the password file can log into Oracle remotely and administer
the instance.
Incorrect Answers
A:
The main problem that the connection failed is the REMOTE_LOGIN_PASSWORDFILE
initialization parameter is set to NONE. Granting the DBA privilege to dba_user will not fix
the issue.
Leading the way in IT testing and certification tools,
www.testking.com
- 3 -
1z0-031
C:
The default directory for the password file is $ORACLE_HOME/dbs/, so there is no error in
the location of the password file.
D:
The main problem that the connection failed is the REMOTE_LOGIN_PASSWORDFILE
initialization parameter is set to NONE. Specifying the password during login process will
not fix the issue.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 513-516
Chapter 10: Basics of the Oracle Database Architecture
QUESTION NO: 2
John has created a procedure named SALARY_CALC. Which SQL query allows him to
view the text of the procedure?
A.
SELECT text FROM user_source
WHERE name ='SALARY_CALC';
B.
SELECT * FROM user_source
WHERE source_name ='salary_calc';
C.
SELECT * FROM user_objects
WHERE object_name = 'SALARY_CALC';
D.
SELECT * FROM user procedures
WHERE object_name ='SALARY_CALC';
E.
SELECT text FROM user_source
WHERE name='SALARY_CALC'
AND owner ='JOHN';
Answer: A
USER_SOURCE dictionary view displays the source code for PL/SQL programs owned by the
user.
Incorrect Answers
B:
There is no SOURCE_NAME column in the USER_SOURCE dictionary view.
C:
You cannot view the text of the procedure using the USER_OBJECTS dictionary view.
D:
There is no USER_PROCEDURES dictionary view in Oracle.
E:
There is no OWNER column in the USER_SOURCE dictionary view, only NAME, TYPE,
LINA and TEXT columns.
OCA Oracle 9i Associate DBA Certification Exam Guide, Jason Couchman, p. 576-578
Chapter 11: Managing the Physical Database Structure
Leading the way in IT testing and certification tools,
www.testking.com
- 4 -
1z0-031
QUESTION NO: 3
You issue the following queries to obtain information about the redo log files:
SQL> SELECT group#, type, member FROM v$logfile;
GROUP# TYPE MEMBER
------ ------- --------------------------------------
1 ONLINE /databases/DB01/ORADATA/u02/log1a.rdo
1 ONLINE /databases/DB01/ORADATA/u03/log1b.rdo
2 ONLINE /databases/DB01/ORADATA/u02/log2a.rdo
2 ONLINE /databases/DB01/ORADATA/u03/log2b.rdo
3 ONLINE /databases/DB01/ORADATA/u02/log3a.rdo
3 ONLINE /databases/DB01/ORADATA/u03/log3b.rdo
SQL> SELECT group#, sequence#, status FROM v$log;
GROUP# SEQUENCE# STATUS
------ --------- ---------
1
250
INACTIVE
2
251
CURRENT
3
249
INACTIVE
You immediately issue this command:
ALTER DATABASE DROP LOGFILE MEMBER
'/databases/DB01/ORADATA/u03/log2b.rdo';
Why does the command fail?
A.
Each online redo log file group must have two members.
B.
You cannot delete any members of online redo log file groups.
C.
You cannot delete any members of the current online redo log file group
D.
You must delete the online redo log file in the operating system before issuing the
ALTER DATABASE command.
Answer: C
It’s not possible to delete any member of the current online redo log file group. You need to
switch log files with the ALTER SYSTEM SWITCH LOGFILE command first. After that you
can delete member from the inactive group.
Incorrect Answers
A:
There is no such limitation on members amount for each redo log file. A redo log group has
to have at least one member. Also it must be at least two log file groups for database.
Leading the way in IT testing and certification tools,
www.testking.com
- 5 -
[ Pobierz całość w formacie PDF ]