- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
51.
Which of the following statements create an Oracle account but let the operating
system authenticate logons? (Choose two.)
- A.create user ops$admin identified by os;
- B.create user ops$admin identified externally;
- C.create user ops$admin nopassword;
- D.create user ops$admin authenticated by os;
- Answer & Explanation
- Report
Answer : [A, B]
Explanation :
Explanation :
| Authentication by the operating system is called external authentication, and the Oracle account name must match the operating-system account name prefixed with the OS_AUTHENT_PREFIX string. When a user is created with the OS_AUTHENT_PREFIX string, the password provided in option A is ignored, and the user is created as exter- nally authenticated. |
52.
If you want to capture the SQL statement and bind variables when performing a standard
statement audit, which value should the AUDIT_TRAIL parameter have?
- A.NONE
- B.DB
- C.DB,EXTENDED
- D.OS
- E.OS,EXTENDED
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The AUDIT_TRAIL parameter with the value DB,EXTENDED enables you to capture SQL statements and bind variables in auditing. OS,EXTENDED is not a valid value for AUDIT_TRAIL . |
53.
Which of the following statements give user desmond the ability to alter table
gl.accounts ?
- A.grant alter on gl.accounts to desmond;
- B.grant alter to desmond on gl.accounts;
- C.grant alter table to desmond;
- D.allow desmond to alter table gl.accounts;
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| Altering a table in another user’s schema requires either the object privilege ALTER on that object or the system privilege ALTER ANY TABLE . Option A has the correct syntax for granting the object privilege on ALTER gl.accounts to user desmond . The alter table privilege in option C is invalid. CREATE TABLE implicitly gives the privilege to alter a table. One would need the ALTER ANY TABLE privilege to alter another user’s table. |
54.
Which of the following statements has the correct syntax and gives the ability to grant
the privilege to other users?
- A.grant alter any table with grant option to desmond;
- B.grant alter on gl.accounts to desmond with admin option;
- C.grant alter any table to desmond with grant option;/li>
- D.grant alter any table to desmond with admin option;
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Conferring the ability to further grant the privilege requires the keywords WITH ADMIN OPTION for system or role privileges or the keywords WITH GRANT OPTION for object privileges. Only option D has both the correct syntax and the correct keywords. Option B would be correct if WITH GRANT OPTION were used. Option C would be correct if WITH ADMIN OPTION were used. Option A is not syntactically correct. |
55.
Examine the CREATE USER statement and choose which of the following options
best applies.
CREATE USER JOHN IDENTIFIED BY JOHNNY
DEFAULT TABLESPACE INDEX01
PASSWORD EXPIRE
QUOTA UNLIMITED ON DATA01
QUOTA UNLIMITED ON INDEX01;
GRANT CONNECT TO JOHN;
CREATE USER JOHN IDENTIFIED BY JOHNNY
DEFAULT TABLESPACE INDEX01
PASSWORD EXPIRE
QUOTA UNLIMITED ON DATA01
QUOTA UNLIMITED ON INDEX01;
GRANT CONNECT TO JOHN;
- A.JOHN will not be able to log in to the database using SQL*Plus until the DBA changes his password.
- B.JOHN is authenticated by the database.
- C.When tables are being created, if JOHN did not specify the TABLESPACE clause, the table will be created on the DATA01 tablespace.
- D.Specifying unlimited space quota on INDEX01 is a redundant step because INDEX01 is JOHN ’s default tablespace.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| JOHN will be able to log in to the database using SQL*Plus, and Oracle will prompt for new password when John logs in the first time. Because John’s default tablespace is INDEX01 , the tables and indexes created will be on the INDEX01 tablespace if the TABLESPACE clause is omitted. Although INDEX01 is the default tablespace, to create objects on INDEX01 or any other tablespace, a specific space quota needs to be defined, or the user should have the UNLIMITED TABLESPACE system privilege. |
|
|
||||||||||||||||||||||||||||
