A. The HR.ROLE_CHECK procedure must be created without the AUTHID clause.
B. user psmith is connecting remotely.
C. The HR.ROLE_CHECK procedure must be created with the AUTHID CURRENT_USERR clause.
D. User psmith Is connecting outside of the SYSDATE specified.
E. The HR_ADMIN role must be granted to user PSMITH.
F. The set hole hr_admin stuternent must be executed with the dbms. session. set_role procedure.
A. User JANE can create objects In sys schema only when connected as SYSDBA.
B. User JANE can grant SYSDBA privilege to roles.
C. User JANE can backup and recover the database.
D. User JANE acquires the DBA role by default.
E. User JANE must always connect as SYSDBA to the database instance.
F. User JANE must use operating system authentication.
A. CLIENT_INFO
B. SESSION_CSER
C. CURRENT SCHEMA
D. CURRENT_OSER
A. direct path exports
B. users with the SYSDA privilege other than sys
C. conventional path exports
D. objects in the SYS schema
E. partitioned tables
A. enforcing row-level security at the table level
B. creating a procedure that defines the VPD restrictions in a VPD policy
C. enforcing row-level security at the database level
D. collecting sensitive data Information with Database Security Assessment Tool (DBSAT)
E. enabling salt tor an encrypted column
F. setting the SQL92_SECURITy initialization parameter to false
A. the primary and foreign key columns
B. none of the columns
C. columns with any type of constraint
D. foreign key columns only
E. the primary key column only
A. the username, password, and service name required to connect to the database
B. the private key of the database service
C. the private key of the client application
D. the user certificate used to uniquely Identify the client application
E. the trusted certificates of the database service
F. the trusted certificates of the Certification Authority
G. the user certificate used to uniquely Identify the database service
A. Configure liscener.oia with an endpolnt for tcps
B. Configure sqlnet. ora with parameter tcp . invited_nodes
C. Download the root certificate from the Certificate Authority In Base64 format
D. Configure sqinet.ora with parameter sq.lnet.encrypt70N_server
E. Download the trusted certificate of the web server in Base64 format a
F. Configure access control lists using DBMS_NETWORK_ACL._ADMIN
G. Configure an Oracle wallet using mkstore or Wallet Manager
A. It must have the Database Vault option enabled.
B. It cannot be used to capture the privileges that have been exercised on precompiled database objects.
C. Privilege analysis data for dropped objects are kept.
D. If a privilege is captured during run time, it is saved under the run-time capture name.
E. It shows the grant paths to the privileges and suggests which grant path to keep.
F. It can be used after you install the Oracle Database without any additional database configuration steps.
