You want to create a role to meet these requirements：
1：The role is to be protected from unauthorized usage.
2：The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles（）
A.Create the role with global authentication.
B.Create the role with external authentication.
C.Create the role as a secure application role.
D.Create the role as a password-protected role.
E.Create a role and use Fine-Grained Access Control （FGAC） to secure the role.
您可能感兴趣的试卷
你可能感兴趣的试题
Examine the commands executed in the following sequence：
1：SQL> CREATE ROLE mgrrole；
2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；
3：SQL> GRANT select，update ON sh.sales TO mgrrole；
4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；
5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；
6：SQL> GRANT ceo TO mgrrole；
Which statement is true about the above commands（）
A.The commands execute successfully.
B.Command 6 produces an error because of circular role grant.
C.Command 5 produces an error because a role cannot be granted to another role.
D.Command 3 produces an error because the MGRROLE role already contains system privileges.
E.The table created by HR remains and HR still has the CREATE TABLE system privilege.
F.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
Examine the following steps performed on a database instance：
1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.
2：The SKD usercreates a table.
3：The SKD user grants theCREATETABLE system privilege to the HR user.
4：The HR user creates a table.
5：The DBA revokes the CREATE TABLE system privilege from SKD.
Which statement is true after step 5 is performed（）
A.The table created by SKD isnot accessibleand SKD cannot create new tables.
B.The tables created by SKD and HR remain， but both cannot create new tables.
C.The table created by HR remains and HR still has the CREATE TABLE system privilege.
D.The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command：
SQL> GRANT SELECT，INSERT，UPDATE ON emp TO scott WITH GRANT OPTION； The user SCOTT executes this command to grant privileges to the user JIM： SQL> GRANT SELECT，INSERT，UPDATE ON hr.emp TO jim；
Now， the user HR decides to revoke privileges from JIM using this command： SQL> REVOKE SELECT，INSERT，UPDATE ON emp FROM jim； Which statement is true after HR issues the REVOKE command（）
A.The command fails because SCOTT still has privileges.
B.The command succeeds and privileges are revoked from JIM.
C.The command fails because HR cannot revoke the privileges from JIM.
D.The command succeeds and only HR has the privilege to perform the SELECT， INSERT， and UPDATEoperations on the EMP table.
View the Exhibit and examine the privileges granted to the MGR_ROLE role.
The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the user SKD by executing the command： SQL> GRANT MGR_ROLE TO SKDWITH ADMIN OPTION；
Which statement is true about the user SKD after he/she is granted this role（）
A.The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.
B.The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C.The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.
D.The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privileges from them.
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE
REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0
You have a local operating system user SKD. You create a database user OPS$SKD， and then
assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.
What would youachieve by the above process（）
A.The database user OPS$SKD will be able to administer the database.
B.The authentication detail for the database user OPS$SKD is recorded in the password file.
C.The local operating system user SKD will be able to access the database instance without specifying the username and password.
D.The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
A.The SKD user cannot log in to the database instance.
B.The objects owned by the SKD user are not accessible to any user.
C.The other users can access the objects owned by the SKD user， on which they have access.
D.The password for the SKD user expires and the user is forced to change the password at the next log in.
View the Exhibit1， which shows the options that are selected to create the user SL_REP.
Which two statements are true regarding this user（）
A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database by defa
The user HR receives the following error while inserting data into the TTK table： ERROR at line 1：
ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMDUpon
investigation， you find that SMD is a small file tablespace.
Which three action would allow the user to insert data（）
A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.
You executed the following command to create a tablespace called SALES_DATA：
> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；
Which two statements are true about the SALES_DATA tablespace （）
A.The database automatically determines the extent-sizing policy for the tablespace.
B.The segments are automatically shrunk when the contents are removed from them.
C.The allocation of extents within the tablespace is managed through the dictionary tables.
D.The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E.The space utilization description of the data blocks in segments is managed through free lists.MANUAL
Which statements are true regarding the USERS tablespace（）
A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated
最新试题
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN；Which two statements are true（）
Which kinds of failures make the Data Recovery Advisor （DRA） generate a manual checklist？（）
You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this（）
You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database（）
Examine the following statement that is used to modify the primary key constraint on the SALES table：SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；Which three statements aretrue regarding the above command（）
View the Exhibit. You are creating an additional database by using the Database Configuration Assistant（DBCA）. You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this（）
You set the following parameters in the parameter file and restarted the database：MEMORY_MAX_TARGET=0MEMORY_TARGET=500MPGA_AGGREGATE_TARGET=90MSGA_TARGET=270MWhich two statements are true about these parameters after the database instance is restarted（）
Which statements are true about checkpointing（）
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario（）
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）