Multiple choice

A Profile is assigned to _____.

  1. a database

  2. tables

  3. views

  4. both (2) and (3)

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A profile in Oracle is a database-level resource limit that can only be assigned to users, not to schema objects like tables or views. Profiles control password settings (expiration, complexity, failed login attempts) and resource limits (CPU time, sessions, idle time). They are assigned with the CREATE USER or ALTER USER commands using the PROFILE clause.

Keep practicing — related questions