QUESTION 15
You are administering a database and you receive a requirement to apply the following restrictions:
1. A connection must be terminated after four unsuccessful login attempts by user.
2. A user should not be able to create more than four simultaneous sessions.
3. User session must be terminated after 15 minutes of inactivity.
4. Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?

QUESTION 16
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user
SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, ‘JACK’);
1 row created.
SQL> INSERT INTO cust VALUES(102, ‘SMITH’);
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott’s session?

QUESTION 17
An administrator account is granted the CREATE SESSION and SET CONTAINER system
privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB
that has been opened in read only mode?

QUESTION 18
You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

QUESTION 19
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

QUESTION 20
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and window.
Which two actions would reduce the job’s elapsed time?

QUESTION 21
You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage
Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure
for a Standalone Server is already installed on the server.
Which three statements must be true for successful installation of the Oracle Database 12c software?
(Choose three.)

QUESTION 22
DEFERRED_SEGMENT_CREATION is TRUE in one of your databases.
You execute this command:

Which three statements are true immediately after this statement executes successfully?

QUESTION 23
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the
partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions
access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement? (Choose three.)

QUESTION 24
You created a new database using the “create database” statement without specifying the
“ENABLE PLUGGABLE” clause.
What are two effects of not using the “ENABLE PLUGGABLE database” clause?

QUESTION 25
Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

QUESTION 26
After implementing full Oracle Data Redaction, you change the default value for the
NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?

QUESTION 27
Which two statements are true about the logical storage structure of an Oracle database?

QUESTION 28
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)

QUESTION 29
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

QUESTION 30
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

What are three possible causes for the latch-related wait events?