1Z0-031 Oracle - Braindumps.com.ua: question list for "Oracle9i: Database Fundamentals I", page: 5

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1Z0-031: Oracle9i: Database Fundamentals I

#41. You use the password utility with this statement to create a password file:
$orapwd file =$ORACLE_HOME/dbs/orapwPROD password=orapass entries=5
You set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to NONE.
You execute this script:

 CREATE USER dba_prod 
 IDENTIFIED BY prod_123; 
 GRANT sysdba TO dba_prod

You issue this command using SQL*Plus:

 CONNECT dba_user/prod_123 AS sysdba;

What will be the result?

#42. You use the password utility with this statement to create a password file:
$orapwd file = $ORACLE_HOME/dbs/orapwPROD password=prodpass entries=5
You set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and you execute this script:

 CREATE USER sam 
 IDENTIFIED BY prod_123; 
 GRANT sysdba TO sam

If Sam connects AS SYSDBA, which statement is true?

#43. Using the password utility ORAPWD, you create a password file with a password of 'private'. How could you change the password?

#44. 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?

#45. You use the password utility with this statement to create a password file:
$ORAPWD file = $ORACLE_HOME/dbs/orapwPROD
password=prodpass entries=5
You set the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE, and you issue this command:

 CONNECT sys/change_on_install AS SYSDBA

Which result will occur?

#46. You need to create a view. Which OEM tool should you use?

#47. You use the password utility with this statement to create a password file:
$orapwd password=pass123 entries=5
Which statement about this statement is true?

#48. Which data dictionary view would you use to get a list of object privileges for all database users?

#49. Which type of file is part of the Oracle database?

#50. Consider this SQL statement:

 UPDATE employees SET first_name = 'John' 
 WHERE emp_id = 1009; 
 COMMIT;

What happens when a user issues the COMMIT in the above SQL statement?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [37]

gen. 0.738

Server date 07:47 22-11-2008

Oracle 1Z0-031

Forum

Start online exam simulation

Master braindump

User braindumps