Oracle Database Security Administration - 1z1-116 Exam Practice Test

A. Add or remove owners to or from the realm.

B. Grant or revoke system privileges to access objects protected by the realm.

C. Add or remove realm-secured database roles to or from the realm.

D. Grant or revoke privileges on realm-protected objects to or from other users.

E. Add or remove participants to or from the realm.

F. Add or remove realm-protected objects to or from the reaim.

G. Grant or revoke realm-secured database roles.

A. John can perform backup and recovery operations by using SQL.

B. John can query other user's data.

C. John Is not able to perform startup and shutdown operations.

D. John must connect as system to perform backup and recovery operations.

E. John can query dba tables.

F. John can perform backup and recovery operations by using RMAN.

G. John must connect as sys to perform backup and recovery operations.

A. Modify all JDBC Thin based clients to include network encryption parameters in Java.

B. Set the server side sqinet.oia parameter sqlnet.encryption_server = requested.

C. Upgrade all OCI-basod clients to match the database version.

D. Verify which clients have encrypted connections using the view vSsession_CONNECT_INFO.

E. Configure the listener with an endpoint for protocol TCPS.

F. Set the client side sqinec.ora parameter SQLNET.ENCRYPTION _client = required.

G. Set the server side sqinot.ora parameter SQLNET.CRYPTO_CHECKSOM_SERVER - accepted.

A. Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.

B. Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .

C. Grant other users access to the database link in the PDBI pluggable database.

D. Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.

E. Grant other users access to the database link In the PDB2 pluggable database.

A. The target database wallet can be uploaded to the data_pctmp_dtr directory.

B. The credential_nam£ parameter automatically creates the credential object store.

C. Only data_pump_dir directory can be used to store credential wallets.

D. The db_link_cred parameter stores the password in a wallet.

E. The db__link__cred references the credential for the username and password for the target database.

F. The database link port Is not correct because It must be restricted to 1521.

A. Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.

B. Set REMOTE_OS_AUTHENT = FALSE In the init.ora file.

C. Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.

D. Set sqlnet.aothentication_sebvices=(NONe» In sqlnet.ora on the database server.

A. It runs only on UNIX/Linux systems.

B. It must connect to the database using a SYSDBA connection.

C. It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.

D. It runs only on Windows systems.

E. It must be run on the server that contains the database.

A. You get an error at the time of factor creation If the retrieval method function you have specified does not exist.

B. You can configure a factor to be evaluated only once per session.

C. Changing a factor type can change how factors are evaluated.

D. You can use a factor to enforce conditions for a command rule.

E. A factor can reference a function In another schema to compute its value, provided execute privilege Is granted to the sys user.

A. User Interaction

B. Scope

C. Attack Complexity

D. Attack Vector

E. Privileges Required

F. Availability

A. Substitute

B. Array List

C. Random Strings

D. Auto Mask

E. Shuffle