NEW QUESTION 1
You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file? (Choose two.)

• A. It records the usernames and passwords of users when granted the DBA role.
• B. It contains the usernames and passwords of users for whom auditing is enabled.
• C. Is used by Oracle to authenticate users for remote database administration.
• D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
• E. It supports the SYSBACKUP, SYSDG, and SYSKM system privilege

Answer: CE

NEW QUESTION 2
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?

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

Explanation: About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by
low-privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.

NEW QUESTION 3
Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

• A. Automatic Database Diagnostic Monitor (ADDM)
• B. SQL Tuning Advisor
• C. SQL Access Advisor
• D. SQL Performance Analyzer
• E. Automatic Workload Repository (AWR) report

Answer: C

Explanation: References: https://docs.oracle.com/cd/B28359_01/server.111/b28314/tdpdw_perform.htm#TDPDW00813

NEW QUESTION 4
A user establishes a connection to a database instance by using an Oracle Net. You want to ensure that:
1. The user account must be locked after five consecutive unsuccessful login attempts.
2. Data read per session must be limited for the user.
3. The user cannot have more than three simultaneous sessions.
4. The user must have a maximum minutes session idle time before being logged off automatically. Which two would you do to implement this? (Choose two.)

• A. by alerting the appropriate user attributes with an ALTER USER command
• B. by using appropriate PASSWORD parameters set in the profile assigned to the user
• C. by implementing Database Resource Manager and assign it a profile for the user
• D. by implementing Database Resource Manager and assign it a role for the user
• E. by using appropriate KERNEL parameters set in the profile assigned to the user

Answer: BE

NEW QUESTION 5
You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file? (Choose two.)

• A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
• B. It contains username and passwords of database users who are members of the OSOPER operating system group.
• C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
• D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
• E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

Answer: AD

Explanation: * You can create a password file using the password file creation utility, ORAPWD.
* Adding Users to a Password File
When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges.
A user's name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.
* The syntax of the ORAPWD command is as follows: ORAPWDFILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
* IGNORECASE
If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.

NEW QUESTION 6
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

• A. Place the root container in ARHCHIVELOG mode.
• B. Take the user data tablespace offline.
• C. Place the root container in the nomount stage.
• D. Ensure that HR_PDB is ope

Answer: A

NEW QUESTION 7
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)

• A. The ASM compatibility attribute controls the format of the disk group metadata.
• B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
• C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
• D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
• E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Answer: ABD

Explanation: AD: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.
B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
Not E:
/The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.
/ You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.
Note:
* The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create an volume in a disk group.

NEW QUESTION 8
Which two statements are true about variable extent size support for large ASM files? (Choose two.)

• A. The metadata used to track extents in SGA is reduced.
• B. Rebalance operations are completed faster than with a fixed extent size
• C. An ASM Instance automatically allocates an appropriate extent size.
• D. Resync operations are completed faster when a disk comes online after being taken offline.
• E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.

Answer: AC

Explanation: A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large databases (A), and improve performance for file create and open operations.
C: You don't have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size. Note:
* The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU). To accommodate increasingly larger files, ASM uses variable size extents.
* The size of the extent map that defines a file can be smaller by a factor and 64 depending on the file size. The initial extent size is equal to the allocation unit size and it increases by a factor and 64 at predefined thresholds. This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to Oracle Release 11 or higher.

NEW QUESTION 9
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement? (Choose two.)

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B. Setting the target tablespace to read-only
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D. Setting the target tablespace offline
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Answer: BC

Explanation: The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

NEW QUESTION 10
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.)

• A. The OSBACKUPDBA, OSDGDBA, and OSKMDBA OS groups must be created.
• B. An operating system OSDBA group must be created for users with the SYSDBA system privilege.
• C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group.
• D. The Oracle Database 12c installation must have a separate Oracle inventory directory.
• E. An operating system OSOPER group be created for users with the SYSOPER system privileg

Answer: BCE

NEW QUESTION 11
What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?

• A. Optimizer statistics are collected automatically.
• B. Only timed operating system (OS) statistics and plan execution statistics are collected.
• C. Automatic Workload Repository (AWR) snapshots are not generated automatically.
• D. The Oracle server dynamically generates the necessary object-level statistics on tables as part of query optimization.

Answer: C

Explanation: References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214

NEW QUESTION 12
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id); END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into
tables on which they do not have any privileges?

• A. Create the CREATE_TEST procedure with definer’s rights.
• B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
• C. Create the CREATE_TEST procedure with invoker’s rights.
• D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

Answer: C

Explanation: If a program unit does not need to be executed with the escalated privileges of the definer, you should specify that the program unit executes with the privileges of the caller, also known as the invoker. Invoker's rights can mitigate the risk of SQL injection.
Incorrect:
Not A: By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. Such definer-rights subprograms are bound to the schema in which they reside.
not B: Using the GRANT option, a user can grant an Object privilege to another user or to PUBLIC.

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

• A. It loads data faster than conventional SQL*Loader
• B. No data file needs to be specified
• C. It can load data in parallel
• D. It loads data more efficiently than conventional SQL*Loader
• E. It requires Enterprise Manager Express to be configured

Answer: AC

Explanation: Reference: https://www.oracle.com/technetwork/database/enterprise-edition/learnmore/sqlldr-express-modewp- 1991038.pdf

NEW QUESTION 14
Examine the parameters for your database instance:

You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?

• A. Undo data is written to flashback logs after 1200 seconds.
• B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undotablespace.
• C. You can perform a Flashback Database operation only within the duration seconds.
• D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Answer: D

NEW QUESTION 15
In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?

• A. Undo is retained in the UNDO tablespace for 1000 seconds, and then moved to the SYSTEM tablespace to provide read consistency.
• B. Inactive undo is retained for at least 1000 seconds if free undo space is available.
• C. Inactive undo is retained for 1000 seconds even if new transactions fall due to lack of space in the undo tablespace.
• D. Undo becomes expired obsolete after 1000 second

Answer: B

NEW QUESTION 16
You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command. CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

• A. It allows only 80% of space to be occupied in all data blocks of this table.
• B. It minimizes row chaining during row insertion.
• C. It minimizes row migration during existing row data updation.
• D. It automatically coalesces free space of a data block when it reaches 20% of available spac

Answer: A

NEW QUESTION 17
Which three statements are true PFILEs, SPFILEs or both? (Choose three.)

• A. SPFILEs and PFILEs may both be edited with an O/S editing utility
• B. Some SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause
• C. A SPFILE can be created by an idle instance
• D. A PFILE can be created by an idle instance
• E. All SPFILE parameters can be modified successfully with the SCOPE=BOTH clause
• F. All SPFILE parameters can be modified successfully with the SCOPE=MEMORY clause

Answer: BDE

NEW QUESTION 18
Identify the access that is initially available to connect to your Database as a Service (DBaaS) environment.

• A. Enterprise Manager on port 1158
• B. telnet on port 23
• C. Cloud Control on port 7799
• D. SSH on port 22
• E. SSL/TLS on port 443

Answer: D