100+ Free Oracle 1Z0-116 Practice Questions

Security Overview and Assessment

Identify security risks and compliance drivers, recognise common database attack points, apply the Maximum Security Architecture, and use the Database Security Assessment Tool (DBSAT) and timely patching to reduce risk.

User and Authentication Management

Create and manage users and profiles, enforce password complexity and lifecycle with profiles and verification functions, and configure OS, Kerberos, PKI/certificate, centrally managed users and enterprise user security.

Authorization, Roles and VPD

Grant system and object privileges, design roles and secure application roles, implement fine-grained access control with Virtual Private Database (VPD), and use application contexts, USERENV and client identifiers for least privilege.

Oracle Database Vault

Protect sensitive data from highly privileged users using realms, command rules, rule sets, factors and separation of duties so that SYSDBA-level access alone cannot read or change protected objects.

Auditing

Configure unified auditing and audit policies, use predefined policies, implement fine-grained auditing (FGA), manage and purge the unified audit trail, and enrich audit records with context information.

Encryption and Network Security

Implement Transparent Data Encryption (TDE) for columns and tablespaces, manage software keystores and the TDE master key, integrate Oracle Key Vault, and enable native network encryption and integrity for SQL*Net traffic.

Data Redaction and Data Masking

Create Oracle Data Redaction policies using full, partial, random and regular-expression redaction at query time, and use Data Masking and Subsetting to protect sensitive data in non-production environments.