NEW QUESTION 1
Which three statements are true about windows? (Choose three.)

• A. Only one window can be open at any given time
• B. Consumer groups are associated with windows
• C. Windows work with job classes to control resource allocation
• D. The database service name must be provided during windows creation
• E. Windows can automatically start job or change resource allocation among jobs for various time periods

Answer: ACE

NEW QUESTION 2
Your database instance has Automatic Memory Management enabled and supports shared server connections. Examine the following:
1. Parallel execution messages and control structures
2. Local variables for a process
3. Security and resource usage information
4. Runtime memory values, such as rows retrieved for a SQL statement using a serial execution plan
5. SQL execution work areas
Which option indicates what is allocated from the large pool in this instance?

• A. only 1
• B. 1, 2, and 5
• C. 1, 2, 3, and 5
• D. 1, 2, and 4

Answer: D

NEW QUESTION 3
Which three statements are true about checkpointing? (Choose three.)

• A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
• B. It ensures that all dirty buffers are written to data files during consistent shutdown.
• C. It reduces the time required for recovery in case of an instance failure.
• D. Frequent thread checkpoints can degrade database performance.
• E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file.

Answer: BCD

NEW QUESTION 4
You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
– Applications will connect to the database via a middle tier.
– The number of concurrent user connections will be high.
– The database will have mixed workload, with the execution of complex BI queries scheduled at night. Which DBCA option must you choose to create the database?

• A. a General Purpose database template with default memory allocation
• B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
• C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
• D. a default database configuration

Answer: C

Explanation: References:
http://www.oracledistilled.com/oracle-database/administration/creating-a-database-using-database-configuration

NEW QUESTION 5
You want to load data from a large file into your database without causing an overhead on the SGA. Which tool would you use.

• A. external table
• B. Oracle data Pump
• C. SQL*Loader with a direct data path
• D. SQL*Loader with a conventional data path
• E. Enterprise Manager Database Express

Answer: C

Explanation: References: https://docs.oracle.com/cd/B19306_01/server.102/b14215/ldr_modes.htm#i1007501

NEW QUESTION 6
Which three statements are true about a job chain? (Choose three.)

• A. It can contain a nested chain of jobs.
• B. It can be used to implement dependency-based scheduling.
• C. It cannot invoke the same program or nested chain in multiple steps in the chain.
• D. It cannot have more than one dependency.
• E. It can be executed using event-based or time-based schedules.

Answer: ABE

NEW QUESTION 7
Which statement is true about the Oracle central inventory directory (oraInventory)?

• A. oraInventory must not be shared by all Oracle software installations on a single system.
• B. If ORACLE_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.
• C. lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.
• D. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.

Answer: D

Explanation: References https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN483

NEW QUESTION 8
You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satisfies the requirements?

• A. EXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)
• B. REUSE AUTOEXTEND ON MAXSIZE UNLIMITED
• C. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM
• D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE

Answer: D

NEW QUESTION 9
Which statement is true about Oracle Net Listener?

• A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• B. A single listener can service only one database instance and multiple remote client connections.
• C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
• D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
• E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Answer: C

Explanation: https://docs.oracle.com/database/121/CNCPT/process.htm

NEW QUESTION 10
To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message: SQL > startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.

• A. The PGA_AGGREGATE_TARGET parameter is set to zero.
• B. The STATISTICS_LEVEL parameter is set to BASIC.
• C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
• D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.

Answer: B

Explanation: Example:
SQL> startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET

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

• A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
• B. Run the Automatic Workload Repository Monitor (ADDM).
• C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
• D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Answer: D

Explanation: * SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements.
* The query optimizer can also help you tune SQL statements. By using SQL Tuning Advisor and SQL
Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency. SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics.
Note:
* Decision support system (DSS) workload
* The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles.

NEW QUESTION 12
Which two tasks can be performed on an external table? (Choose two.)

• A. partitioning the table
• B. creating an invisible index
• C. updating the table by using an UPDATE statement
• D. creating a public synonym
• E. creating a view

Answer: DE

Explanation: http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN01507
You can, for example select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.

NEW QUESTION 13
Your database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$
You execute the following command:

And then grant OPS$GUEST_USER the CREATE SESSION privilege. Which two statements are true? (Choose two.)

• A. GUEST_USER can query the tables created in the USERS tablespace by default.
• B. The authentication details for GUEST_USER are stored in the database password file.
• C. A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.
• D. GUEST_USER can log on to the database without specifying a username and password.
• E. GUEST_USER is forced to change the password at the first logi

Answer: CD

NEW QUESTION 14
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

• A. OMF cannot be used in a database that already has data files created with user-specified directions.
• B. The file system directions that are specified by OMF parameters are created automatically.
• C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
• D. OMF automatically creates unique file names for table spaces and control files.
• E. OMF may affect the location of the redo log files and archived log files.

Answer: DE

Explanation: D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces Redo log files Control files Archived logs
Block change tracking files Flashback logs
RMAN backups Note:
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle- managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.
http://www.oracle-base.com/articles/9i/oracle-managed-files.php
http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm References:

NEW QUESTION 15
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

• A. Tracking the most recent read time for a table segment in a user tablespace
• B. Tracking the most recent write time for a table segment in a user tablespace
• C. Tracking insert time by row for table rows
• D. Tracking the most recent write time for a table block
• E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Answer: ABD

Explanation: Incorrect:
Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. Heat Map provides data access tracking at the segment-level and data modification tracking at the segment and row level.
* To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database.
References:

NEW QUESTION 16
On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id); Which two statements are correct? (Choose two.)

• A. Both the indexes are created; however, only the ORD_COSTOMER index is visible.
• B. The optimizer evaluates index access from both the Indexes before deciding on which index to use for query execution plan.
• C. Only the ORD_CUSTOMER_IX1 index is created.
• D. Only the ORD_CUSTOMER_IX2 index is created.
• E. Both the indexes are updated when a new row is inserted, updated, or deleted In the orders table.

Answer: AE

Explanation: 11G has a new feature called Invisible Indexes. An invisible index is invisible to the optimizer as default. Using this feature, we can test a new index without effecting the execution plans of the existing sql statements or we can test the effect of dropping an index without dropping it.

NEW QUESTION 17
Examine the query and its output:

What might have caused three of the alerts to disappear?

• A. The threshold alerts were cleared and transferred to DBA_ALERT_HISTORY.
• B. An Automatic Workload Repository (AWR) snapshot was taken before the execution of the second query.
• C. An Automatic Database Diagnostic Monitor (ADOM) report was generated before the execution of the second query.
• D. The database instance was restarted before the execution of the second quer

Answer: D

NEW QUESTION 18
Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

• A. Grant the APEX_PUBLIC_USER role to the SYSMAN user.
• B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server.
• C. Install Oracle HTTP Server.
• D. Configure at least one dispatcher for the TCP/IP protocol.
• E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Expres

Answer: BD