A. The number of days for which an account may be inactive before it is locked.
B. The maximum number of sessions permitted for a user before the password must be changed.
C. The number of days for which an account may be logged in to one or more sessions before it is locked.
D. The ability to prevent a password from ever being reused.
E. The maximum amount of CPU time allowed for a user's sessions before their account is locked.
A. Each server process or background process has their own Program Global Area (PGA).
B. A person or program can have more than one session with an instance by logging in with the same user.
C. The buffer cache and the redo log buffer are held in the large pool.
D. A person or program can have more than one session with an instance by logging in with different users.
E. A connection represents the state of a user's login to an instance.
F. A session represents the state of a user's login to an instance.
A. All sessions must have the same timeout value when waiting for resumable space allocations.
B. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.
C. Resumable space allocation is only possible with locally managed tablespaces.
D. Resumable space allocation may be enabled for some sessions and not others.
E. A user's session may be suspended and resumed multiple times.
F. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege.
A. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.
B. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE.
C. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED.
D. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED.
A. True. Dispatchers monitor the response queue.
B. Broadcasting shared server session responses back to requesters on all connections.
C. Sending shared server session responses back to requesters on the appropriate connection.
D. Sending each connection input request to the appropriate shared server input queue.
E. Writing inbound requests to the common request queue from all shared server connections.
F. Checking for outbound shared server responses on the common outbound response queue.
G. Receiving inbound requests from processes using shared server connections.
A. Execute DML statements in the HR schema.
B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
C. Revoke the CREATE SESSION privilege from user HR.
D. Execute DDL statements in the HR schema.
E. Revoke the CREATE SESSION privilege from other users.
F. Log in to the database instance.
A. Enabling online redo log archiving.
B. Full database recovery.
C. Creating a database.
D. Re-creating control files.
E. Renaming data files.
A. ALTER SYSTEM CHECKPOINT
B. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
C. ALTER SYSTEM SWITCH LOGFILE
D. ALTER SYSTEM FLUSH BUFFER_CACHE
A. Oracle Net Manager can be used to locally configure naming methods on a database server.
B. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server.
C. Oracle Net Manager can be used to centrally configure listeners on any database server target.
D. The Oracle Net Configuration Assistant is only used when running the Oracle installer.
E. The lsnrctl utility requires a listener.ora file to exist before it is started.
F. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target.
A. They are owned by the SYSTEM user.
B. Read consistency is not guaranteed.
C. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary.
D. They can be queried only when the database is open.
E. V$FIXED_TABLE can be queried to display the names of all dynamic performance views.
