1Z0-053 Oracle Database 11g: Administration II

Exam Number: 1Z0-053
Exam Title: Oracle Database 11g: Administration II
Associated Certification Paths Oracle Database 11g Administrator Certified Professional
Duration: 120 minutes
Number of Questions: 78
Passing Score: 66%
View passing score policy
Validated Against: The exam has been validated against Oracle® Database 11g Release 2 version 11.2.0.1.0.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):

Oracle Database 11g: Administration Workshop II DBA Release 2

Additional Preparation and Information

A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Exam Preparation Seminar
Certification Exam Prep Seminar: Oracle Database 11g Administration II
Exam Prep Seminar Package: Oracle Database 11g Administration II

Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-053 Oracle Database 11g: Administration II

Additional Training
The earlier course is still a valid exam preparation tool but is no longer being scheduled:
Oracle Database 11g: Administration Workshop II
Training Opportunities for Oracle Partner Network Members (avialable to partners only)
OPN Guided Learning Path: Oracle Database 11g Implementation Specialist (avialable to partners only)
Training Resources by Exam Topics (avialable to partners only)

Database Architecture and ASM
Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups

Configuring for Recoverability
Configure multiple archive log file destinations to increase availability
Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area

Using the RMAN Recovery Catalog
Identify situations that require RMAN recovery catalog
Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog

Configuring Backup Specifications
Configure backup settings
Allocate channels to use in backing up
Configure backup optimization

Using RMAN to Create Backups
Create image file backups
Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups

Performing User-Managed Backup and Recovery
Recover from a lost TEMP file
Recover from a lost redo log group
Recover from the loss of password file
Perform user-managed complete database recovery
Perform user-managed incomplete database recovery
Perform user-managed and server managed backups
Identify the need of backup mode
Back up and recover a control file

Using RMAN to Perform Recovery
Perform complete recovery from a critical or noncritical data file loss using RMAN
Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery

Using RMAN to Duplicate a Database
Creating a duplicate database
Using a duplicate database

Performing Tablespace Point-in-Time Recovery
Identify the situations that require TSPITR
Perform automated TSPITR

Monitoring and Tuning RMAN
Monitoring RMAN sessions and jobs
Tuning RMAN
Configure RMAN for Asynchronous I/O

Using Flashback Technology
Restore dropped tables from the recycle bin
Perform Flashback Query
Use Flashback Transaction

Additional Flashback Operations
Perform Flashback Table operations
Configure, Monitor Flashback Database and Perform Flashback Database operations
Set up and use a Flashback Data Archive

Diagnosing the Database
Set up Automatic Diagnostic Repository
Using Support Workbench
Perform Block Media Recovery

Managing Memory
Implement Automatic Memory Management
Manually configure SGA parameters
Configure automatic PGA memory management

Managing Database Performance
Use the SQL Tuning Advisor
Use the SQL Access Advisor to tune a workload
Understand Database Replay

Space Management
Manage resumable space allocation
Describe the concepts of transportable tablespaces and databases
Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Resources
Understand the database resource manager
Create and use Database Resource Manager Components

Automating Tasks with the Scheduler
Create a job, program, and schedule
Use a time-based or event-based schedule for executing Scheduler jobs
Create lightweight jobs
Use job chains to perform a series of related tasks

Administering the Scheduler
Create Windows and Job Classes
Use advanced Scheduler concepts to prioritize jobs

---

QUESTION 2
You want to perform the following operations for the DATA ASM disk group:
Verify the consistency of the disk.
Cross-check all the file extent maps and allocation tables for consistency.
Check whether the alias metadata directory and file directory are linked correctly.
Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Answer: A

Explanation:
Syntax: ALTER DISKGROUP <disk_group_id> CHECK [REPAIR | NOREPAIR];
The check_diskgroup_clause lets you verify the internal consistency of Oracle ASM disk group
metadata. The disk group must be mounted. Oracle ASM displays summary errors and writes the
details of the detected errors in the alert log.
The CHECK keyword performs the following operations:
Refer to here

---

QUESTION 3
Which two statements are true regarding the functionality of the remap command in ASMCMD?
(Choose two.)

A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original
location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate
location on disk if the blocks on the original location cannot be read properly.

Answer: A,D

Explanation:
Reference from the Oracle document release v11.1 at here:
Repairs a range of physical blocks on a disk. The remap command only repairs blocks that have
read disk I/O errors. It does not repair blocks that contain corrupted contents, whether or not those
blocks can be read. The command assumes a physical block size of 512 bytes and supports all
allocation unit sizes (1 to 64 MB).
Reference from the Oracle document release v11.2 at here:
The remap command marks a range of blocks as unusable on the disk and relocates any data
allocated in that range.

---

QUESTION 4
What is the advantage of setting the ASM-preferred mirror read for the stretch cluster
configuration?

A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.

Answer: D

Explanation:
Preferred Read Failure Groups
When you configure Oracle ASM failure groups, it might be more efficient for a node to read from
an extent that is closest to the node, even if that extent is a secondary extent. In other words, you
can configure Oracle ASM to read from a secondary extent if that extent is closer to the node
instead of Oracle ASM reading from the primary copy which might be farther from the node. Using
the preferred read failure groups feature is most useful in extended clusters.

---

QUESTION 5
Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline
B. when one or more ASM files are dropped
C. when some disks in a disk group are offline
D. when some disks in a failure group for a disk group are rebalancing

Answer: C

Explanation:
In the FORCE mode, Oracle ASM attempts to mount the disk group even if it cannot discover all of
the devices that belong to the disk group. This setting is useful if some of the disks in a normal or
high redundancy disk group became unavailable while the disk group was dismounted. When
MOUNT FORCE succeeds, Oracle
ASM takes the missing disks offline.
If Oracle ASM discovers all of the disks in the disk group, then MOUNT FORCE fails. Therefore,
use the MOUNT FORCE setting only if some disks are unavailable. Otherwise, use NOFORCE.
In normal- and high-redundancy disk groups, disks from one failure group can be unavailable and
MOUNT FORCE will succeed. Also in high-redundancy disk groups, two disks in two different
failure groups can be unavailable and MOUNT FORCE will succeed. Any other combination of
unavailable disks causes the operation to fail, because Oracle ASM cannot guarantee that a valid
copy of all user data or metadata exists on the available disks.
Refer to here

---

QUESTION 6
Which background process of a database instance, using Automatic Storage Management (ASM),
connects as a foreground process into the ASM instance?

A. ASMB
B. PMON
C. RBAL
D. SMON

Answer: A

Explanation:
ASMB (ASM Background Process): Communicates with the ASM instance, managing storage and
providing statistics, runs in ASM instances when the ASMCMD cp command runs or when the
database instance first starts if the server parameter file is stored in ASM. ASMB also runs with
Oracle Cluster Registry on ASM.
RBAL (ASM Rebalance Master Process): In an ASM instance, it coordinates rebalance activity for
disk groups. In a database instances, it manages ASM disk groups.
PMON (Process Monitor): Monitors the other background processes and performs process
recovery when a server or dispatcher process terminates abnormally.
SMON (System Monitor Process): Performs critical tasks such as instance recovery and dead
transaction recovery, and maintenance tasks such as temporary space reclamation, data
dictionary cleanup, and undo tablespace management

Click here to view complete Q&A of 1Z0-053 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-053 Certification, Oracle 1Z0-053 Training at certkingdom.com

1Z0-148 Oracle Database: Advanced PL/SQL

Exam Number: 1Z0-148
Exam Title: Oracle Database: Advanced PL/SQL
Associated Certification Paths Oracle Database PL/SQL Developer Certified Professional
Duration: 110
Number of Questions: 75
Passing Score: 62%
Format: Multple Choice

Complete Recommended Training
Oracle Database 12c: Advanced PL/SQL
Oracle Database 11g: Advanced PL/SQL

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Oracle Database 12c: Program with PL/SQL
Oracle Database 12c: SQL and PL/SQL Fundamentals
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-148: Oracle Database 12c: Advanced PL/SQL

Designing PL/SQL Code
Identify guidelines for cursor design
Use cursor variables
Use DBMS_SQL functions
Create subtypes based on existing types

Creating and Managing Collections
Create and manage nested tables
Create and manage varrays
Create and manage associative arrays/PLSQL tables

Working with Collections
Manipulate collections
Distinguish between the different types of collections and their uses
Use nested collections
Use collection of objects

Manipulating Large Objects
Create and maintain LOB data types
Differentiate between internal and external LOBs
Use the DBMS_LOB PL/SQL package
Use of temporary LOBs
Describe and use SecureFile LOB

Using Advanced Interface Methods
Execute external C programs from PL/SQL
Execute Java programs from PL/SQL

Tuning PL/SQL Performance
Use native and interpreted compilation methods
Optimize PL/SQL code
Enable intraunit inlining
Use DBMS_PARALLEL_EXECUTE package

Improving Performance with Caching
Identify when to result cache a function
Handle session dependencies in a result cache function
Set up PL/SQL functions to use PL/SQL result caching
Invoker’s Right function result caching
Explain invalidation of cache results
Use the DBMS_RESULT_CACHE package

Analyzing PL/SQL Code
Use the supplied packages and dictionary views to find coding information
Determine identifier types and usages with PL/Scope
Use the DBMS_METADATA package for creation DDL that can be used to re-create the objects
Use compile time warnings
Use conditional compilation

Profiling and Tracing PL/SQL Code
Trace PL/SQL program execution
Profile PL/SQL applications

Implementing Fine-Grained Access Control for VPD
Explain the process of fine-grained access control
Build security policies

Safeguarding Your Code Against SQL Injection Attacks
Explain SQL injection
Reduce attack surfaces
Use DBMS_ASSERT

Edition-Based Redefinition
Use Edition-Based Redefinition

Multidisciplinary
Items wherein concepts across multiple objectives will be tested in each item


QUESTION 1
Which three statements are correct with reference to intra unit inlining?

A. Inlining will always decrease the size of a unit.
B. Setting PLSQL_OPTIMIZE_LEVEL to 2 means automatic inlining is attempted.
C. You cannot inline an external subroutine.
D. Programs that make use of smaller helper subroutines are good candidates for inlining.
E. Pragmas apply only to calls in the next statement following the pragma.
F. You cannot inline local subroutines.

Answer: C,D,E

Explanation: References:

---

QUESTION 2
Which two statements are true regarding edition-based redefinition (EBR)?

A. There is no default edition defined in the database.
B. EBR does not let you upgrade the database components of an application while in use.
C. You never use EBR to copy the database objects and redefine the copied objects in isolation.
D. Editions are non-schema objects.
E. When you change an editioned object, all of its dependents remain valid.
F. Tables are not editionable objects.

Answer: E,F

Explanation: References:

---

QUESTION 3
Which statement is true about the DBMS_PARALLEL_EXECUTE package?

A. DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
B. To execute chunks in parallel, users must have CREATE JOB system privilege.
C. No specific system privileges are required to create or run parallel execution tasks.
D. Only DBAs can create or run parallel execution tasks.
E. Users with CREATE TASK privilege can create or run parallel execution tasks.

Answer: B

Explanation:
Referencehttps://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#A RPLS67331(security model)

---

QUESTION 4
Which two statements describe actions developers can take to make their application less vulnerable to security attacks?

A. Include the AUTHID DEFINER clause in stored program units.
B. Do not concatenate unchecked user input into dynamically constructed SQL statements.
C. Switch from using DBMS_SQL to EXECUTE IMMEDIATE.
D. Include the AUTHID CURRENT_USER clause in stored program units.
E. Increase the amount of code that is accessible to users by default.

Answer: B,D

---

QUESTION 5
Which statement is correct about DBMS_LOB.SETOPTIONS and
DBMS_LOB.GETOPTIONS for SecureFiles?

A. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
B. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
C. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
D. If a table was not created with compression specified in the store as securefile clause then DBMS_LOB.SETOPTIONS can be used to enable it later.

Answer: D

Explanation: References:

---

QUESTION 6
Which two statements about the PL/SQL hierarchical profiler are true?

A. Access it using the DBMS_PROFILER package.
B. Access it using the DBMS_HPROF package.
C. Profiler data is recorded in tables and published in HTML reports.
D. It is only accessible after a grant of the CREATE PROFILE privilege.
E. It helps you identify subprograms that are causing bottlenecks in application performance.

Answer: B,E

Explanation: References:

Click here to view complete Q&A of 1Z0-148 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-148 Certification, Oracle 1Z0-148 Training at certkingdom.com

1Z0-071 Oracle Database SQL

Exam Number: 1Z0-071
Exam Title: Oracle Database SQL
Associated Certification Paths
    Oracle Database 11g Administrator Certified Associate
    Oracle PL/SQL Developer Certified Associate
    Oracle Database 12c Administrator Certified Associate
    Oracle Database SQL Certified Associate
Duration: 100 minutes
Number of Questions: 73
Passing Score: 63%
Validated Against:  This exam was validated against 11g Release 2 version 11.2.0.1.0 and up to 12c Release 1 version 12.1.0.1.0.
Format: Multiple Choice

Complete Recommended Training
Oracle Database 12c: Introduction to SQL or
Oracle Database: Introduction to SQL

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Also available in Spanish - 1Z0-071-ESN on the Pearson VUE website.
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-071 DBCert: Oracle Database SQL

Using Structured Query Language (SQL)
Explain the relationship between a database and SQL

Using Data Definition Language (DDL)
Describe the purpose of DDL
Use DDL to manage tables and their relationships
Explain the theoretical and physical aspects of a relational database

Using Data Manipulation Language (DML) and Transaction Control Language (TCL)
Describe the purpose of DML
Use DML to manage data in tables
Use TCL to manage transactions

Defining SELECT Statements
Identify the connection between an ERD and a database using SQL SELECT statements

Using Basic SELECT statements
Build a SELECT statement to retrieve data from an Oracle Database table
Use the WHERE clause to the SELECT statement to filter query results

Restricting and Sorting Data
Use the ORDER BY clause to sort SQL query results
Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime

Defining Table Joins
Describe the different types of joins and their features
Use joins to retrieve data from multiple tables
Use self joins

Using Single-Row Functions to Customize Output
Use various types of functions available in SQL
Use conversion functions
Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements

Using Conversion Functions and Conditional Expressions
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply general functions and conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables
Use SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins

Using Subqueries to Solve Queries
Define subqueries
Describe the types of problems subqueries can solve
Describe the types of subqueries
Use correlated subqueries
Update and delete rows using correlated subqueries
Use the EXISTS and NOT EXISTS operators
Use the WITH clause
Use single-row and multiple-row subqueries

Using the Set Operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Manipulating Data
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

Using DDL Statements to Create and Manage Tables
Describe data types that are available for columns
Create a simple table
Create constraints for tables
Describe how schema objects work
Execute a basic SELECT statement

Creating Other Schema Objects
Create simple and complex views with visible/invisible columns
Create, maintain and use sequences

Managing Objects with Data Dictionary Views
Use the data dictionary views to research data on objects
Query various data dictionary views

Controlling User Access
Differentiate system privileges from object privileges
Grant privileges on tables and on a user
Distinguish between privileges and roles

Managing Schema Objects
Manage constraints
Create and maintain indexes including invisible indexes and multiple indexes on the same columns
Drop columns and set column UNUSED
Perform flashback operations
Create and use external tables

Manipulating Large Data Sets
Describe the features of multitable INSERTs
Merge rows in a table

---

QUESTION 1
Evaluate the following SQL statement:
SELECT product_name || 'it's not available for order'
FROM product_information
WHERE product_status = 'obsolete';
You received the following error while executing the above query:
ERROR:
ORA-01756: quoted string not properly terminated
What would you do to execute the query successfully?

A. Enclose the character literal string in the SELECT clause within the double quotation marks.
B. Do not enclose the character literal string in the SELECT clause within the single quotation marks.
C. Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.
D. Use escape character to negate the single quotation mark inside the literal character string in the SELECT clause.

Answer: C

---

QUESTION 2
Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME
------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You need to display customers' second names where the second name starts with "Mc" or "MC."
Which query gives the required output?

A. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1))='Mc';
B. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) LIKE 'Mc%';
C. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1) FROM customers
WHERE SUBSTR(cust_name, INSTR(cust_name,' ')+1) LIKE INITCAP('MC%');
D. SELECT SUBSTR(cust_name, INSTR(cust_name,' ')+1)
FROM customers
WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,' ')+1)) = INITCAP('MC%');

Answer: B

---

QUESTION 3
Which three statements are true regarding group functions? (Choose three.)

A. They can be used on columns or expressions.
B. They can be passed as an argument to another group function.
C. They can be used only with a SQL statement that has the GROUP BY clause.
D. They can be used on only one column in the SELECT clause of a SQL statement.
E. They can be used along with the single-row function in the SELECT clause of a SQL statement.

Answer: A,B,E

---

QUESTION 4
Evaluate the following ALTER TABLE statement:
ALTER TABLE orders
SET UNUSED order_date;
Which statement is true?

A. The DESCRIBE command would still display the ORDER_DATE column.
B. ROLLBACK can be used to get back the ORDER_DATE column in the ORDERS table.
C. The ORDER_DATE column should be empty for the ALTER TABLE command to execute successfully.
D. After executing the ALTER TABLE command, you can add a new column called ORDER_DATE to the ORDERS table.

Answer: D

---

QUESTION 5
Which two statements are true regarding constraints? (Choose two.)

A. A foreign key cannot contain NULL values.
B. A column with the UNIQUE constraint can contain NULL.
C. A constraint is enforced only for the INSERT operation on a table.
D. A constraint can be disabled even if the constraint column contains data.
E. All the constraints can be defined at the column level as well as the table level

Answer: B,D

---

QUESTION 6
Which three statements are true regarding the data types?

A. Only one LONG column can be used per table.
B. ATIMESTAMP data type column stores only time values with fractional seconds.
C. The BLOB data type column is used to store binary data in an operating system file.
D. The minimum column width that can be specified for a varchar2 data type column is one.
E. The value for a CHAR data type column is blank-padded to the maximum defined column width.

Answer: A,D,E

---

QUESTION 7
The first DROP operation is performed on PRODUCTS table using the following command:
DROP TABLE products PURGE;
Then you performed the FLASHBACK operation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP;
Which statement describes the outcome of the FLASHBACK command?

A. It recovers only the table structure.
B. It recovers the table structure, data, and the indexes.
C. It recovers the table structure and data but not the related indexes.
D. It is not possible to recover the table structure, data, or the related indexes.

Answer: D

Click here to view complete Q&A of 1Z0-071 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-071 Certification, Oracle 1Z0-071 Training at certkingdom.com

1Z0-238 Oracle EBS R12: Install, Patch and Maintain Applications

Exam Number: 1Z0-238
Exam Title: Oracle EBS R12: Install, Patch and Maintain Applications
Associated Certification Paths Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
Oracle E-Business Suite R12 Applications Database Administrator Certified Professional
Duration: 90 minutes
Number of Questions: 75
Passing Score: 63%
View passing score policy
Validated Against: This exam has been validated against Release 12
Format: Multiple Choice

Complete Recommended Training
R12.x Install/Patch/Maintain Oracle E-Business Suite

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Preparing for your Installation
Advantages of Rapid Install
Technology Stack Components
Pre-requisites required (Platform Hardware and Softwares)
Staging Software
How Installation works

Performing an Installation
Types of Installation (Standard/Typical/Express)
Validation of Parameters passed
Restart / Troubleshooting fresh Install
Rapid Install progress monitoring

Finishing your Installation
Explain required post-installation tasks
Describe the client software configuration process
Describe installation-specific post-installation tasks
Sanity Checks after successful installation

Oracle Applications Components
Identify and describe the high-level technology stack components that make up the desktop, application and database tiers
Understand how Oracle Applications uses the various technology stack components
Identify the various oracle homes used by the Oracle Applications
Identify and describe the role of the various Applications Technology layer products
Identify the key changes in the R12 applications technology stack

Environment Files, Control Scripts and Languages
Describe the Oracle Applications main environment file and its key parameters
Identify other important environment files
Identify application tier server control scripts
Explain how languages are supported by Oracle Applications

Oracle Applications File System
Describe the Oracle Applications file system (both database tier and application tier)
Describe the product directory structure
Identify the important product directories (AD, AU)
Describe the role of the following directories: APPL_TOP, COMMON_TOP, INST_TOP
List the directories that are new with Release 12

Oracle Applications Database
Describe the objects and schemas that exist in the Oracle Applications database
Describe the purpose of the APPS schema and Additional Schema
Impending Multiple Organization and Reporting Currencies
Overview of Database Features
Database Monitoring Features
Database Performance Features
Database Scalability and Business Intelligence Features
How to Start and Shutdown the database server and listener

Advanced Configuration Options
Understand the use of a shared application tier file system in Oracle Applications
Explain the benefits of using a staged APPL_TOP
Identify the main load balancing options and their key features
Understand the major factors in efficient network design for Oracle Applications

R12 Use Oracle Applications AD Utilities
Configuration and environment files
Identify the AD utilities
Understand the usage of command line arguments and flags
Describe parallel processing
Identify the location and usage of log and restart files. (adadmin.log and adwor0xxx.log)
Distributed AD

AD Administration: Maintain Applications Files Tasks
Relink Oracle Applications programs
Create the main Applications environment file
Identify the appropriate servers for file system administration tasks
Maintain Snapshot Information

AD Administration: Compile/Reload Database Entities Tasks
Using Compile/Reload Database Entities Tasks
Alternative methods to compile/generate & reload objects

AD Administration: Non-interactive Operation and Maintenance Mode
Create a defaults file and running AD Administration in non-interactive mode
Enable and Disable maintenance mode
Benefits of Running AD Administration in Non-interactive Mode
Defaults file available menu options

Special Utilities
Overview of AD Controller
Understand the worker status
Troubleshoot worker processes
Restart and shutdown a worker
AD Relink Utility
Describe the Upgrade Process
Review Worker Status & It's Flow

Autoconfig
Describe the Applications Context
Describe Autoconfig
Identify Scripts used by Autoconfig
Run Autoconfig to configure an Oracle Application System
Update Applications Context Parameters
Restore Applications Context Parameters
Roll Back an Autocofig Session
Run Autoconfig in Test Mode
Troubleshooting / Dependency while running Autoconfig
Benefits of Context Files
Autoconfig in OAM

AD Administration: Maintain Database Entities Tasks
Using Different Options Maintain Database entities task

Dual Table

License Manager
License Manager Utility
Register products
Register country-specific functionalities
Register languages
Identify licensed products and languages
License Manager Summary Report

Reporting Utilities
Overview of Command Line Reporting Utilities
AD Configuration Report
AD File Identification
AD Job Timing Report
Running AD Configuration

Configuration Utilities
Install a new off-cycle product
How to use AD Splicer
Convert the character set of Applications files

Patching and the AutoPatch Process
Overview of patches (includes the purpose, types of patches, naming convention)
Describe the elements of a patch
Distinguish between a patch, minipack, maintenance pack and consolidated updates
Describe how a patch is created
Overview of Autopatch and its features/ Options
Explain the steps AutoPatch goes through to apply a patch
How to apply a Patch (both on single node and multi node configuration
Downloading a Patch

---

QUESTION 1
Which three are the correct definitions of the objects in the Oracle Applications database? (Choose three.)

A. Hybrid objects contain materialized view objects, and store and process data.
B. Code objects contain index, PL/SQL package, and Java-stored procedure objects.
C. Data objects contain table, index, and sequence and index-organized table objects.
D. Hybrid objects contain PL/SQL package and Java-stored procedure, and process data objects.
E. Code objects contain trigger, PL/SQL package, Java-stored procedure, synonym, and view objects.

Answer: A,C,E

---

QUESTION 2
The AD Administration task utility Compile APPS Schema is similar to the "Validate APPS Schema" task, except that instead of just producing a list of invalid objects, it compiles invalid objects using multiple workers in an attempt to move them back to the valid object state. This task is most often run when custom packages are moved into the APPS schema, and during the upgrade process. The "Compile APPS Schema" task can be toggled to compile all objects or just the invalid objects. Choose three correct benefits of using this task. (Choose three.)

A. increases run-time performance in the applications
B. corrects all corrupt schema package bodies and headers
C. finds truly invalid objects before users get a run-time error
D. allows new custom or patched packages to be immediately validated

Answer: A,C,D

---

QUESTION 3
Which three statements about the Applications Context file are true? (Choose three.)

A. It is a system configuration file.
B. It must be edited manually using a text editor.
C. It is stored in an Oracle Applications Manager (OAM) schema.
D. It can be downloaded from Oracle Applications Manager (OAM).
E. It is created by Rapid Install using AutoConfig during installation and upgrade.
F. It stores all information required to configure an Oracle Applications instance.

Answer: D,E,F

---

QUESTION 4
Choose two statements that are correct for AutoPatch running in Test Mode. (Choose two.)

A. It Relinks any executables.
B. It does not record patch history.
C. It reads and validates the patch driver's file.
D. It generates any forms, reports, PL/SQL libraries, or menu files.
E. It copies any files from the patch directory to the installation area.

Answer: B,C

---

QUESTION 5
What is the version of the Java Oracle home in Oracle Applications Release 12?

A. 10.2
B. 8.1.7
C. 8.0.6
D. 10.1.3
E. 10.1.2

Answer: D

Click here to view complete Q&A of 1Z0-238 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-238 Certification, Oracle 1Z0-238 Training at certkingdom.com

1Z0-244 Oracle EBS R12: Advanced Supply Chain Planning

Exam Number: 1Z0-244
Exam Title: Oracle EBS R12: Advanced Supply Chain Planning
Associated Certification Paths
Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.

Oracle E-Business Suite R12 Advanced Supply Chain Planning Consultant Certified Expert
OPN Certified Specialist
Duration: 135 minutes
Number of Questions: 89
Passing Score: 62%
View passing score policy
Validated Against:  This exam has been validated against Release 12
Format: Multiple Choice

Complete Recommended Training

R12.2 Oracle Advanced Supply Chain Planning Fundamentals Ed 2

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

This course is no longer being scheduled, but is still a valid preparation tool for this exam, if you took the course while it was live:
R12 Oracle Advanced Supply Chain Planning Fundamentals
Training Opportunities for Oracle Partner Network Members (available to partners only)
Sample Questions

Overview to Advanced Supply Chain Planning
Identify planning business issues
Describe key capabilities of Oracle Advanced Supply Chain Planning
Explain efficiencies achieved by implementing Oracle Advanced Supply Chain Planning
Identify key constraints that influence distribution planning decisions and how to meet them
Explain key benefits of using distribution planning
Explain integration of distribution planning with other Oracle APS suite products
Explain usefulness of different plan types
Identify plan classes based on scenarios
Identify differences in implementation progression by plan class
Describe planning business flow
Describe planning data flow

Unconstrained Plans
Describe planning concepts
Create unconstrained plans
Launch unconstrained plans

Constrained Plans
Create demand priority rules
Create and assign calendars
Set constrained plan options
Set aggregation levels
Run constrained plan
View material constraints
View resource constraints

Constrained Plans - Enforce Capacity Constraints with Decision Rules
Describe Enforce Capacity Constraints with Decision rule plans
Interpret End item substitution/Substitution components
Setup and use Alternate resources/BOMs/Routings
Planning Decision rule hierarchy

Global Forecasting
Describe global forecasting
Spreading Global Forecasts
Consuming Global Forecasts
Recommending Sales Order changes

Planning Information and Planner Workbench
Explain the significance of various types of data used for planning
Explain key functionalities of planner workbench
Describe how to research data for planning
Describe planning results
Describe planner strategies
Copy and manage plans

Modeling the Supply Chain
Analyze enterprise data
Analyze organization structure
Review planning approach
Analyze item information
View Bill of material data
Explain types of BOM
Create and Maintain BOM
Create and maintain Routing & Resources
Explain Engineering change order (ECO) and its process
Analyze sourcing information
View supplier data
Define lead time
Review organization relationship
Model the supply chain
Describe the usage of MRP plan versus Master Production Plan and Master Production Schedule
Describe the benefits of Holistic Plans

Querying Supply Chain Plan Information
Create personal and public queries
Manage personal and public queries
Create order queries
Manage order queries

Constrained Plans - Enforce Demand Due Dates
Describe Enforce Demand Due Dates constrained plans
Describe exceptions out of Enforce Demand Due Date Plans

Integrating Advanced Supply Chain Planning with Other Oracle Applications
Describe the types of manufacturing environments that are integrated with ASCP
Describe the integration points between ASCP and Oracle Project Manufacturing
Describe the integration points between ASCP and Oracle Process Manufacturing
Describe the integration points between ASCP and Oracle Flow Manufacturing
Describe the integration points between ASCP and Demantra demand Management
Describe the integration points between ASCP and Production scheduling
Describe the integration points between ASCP and SNO

Demand and Supply
Explain Types of Demand sources
Describe sales orders
Explain forecast and forecast consumption
Analyze supply types
Describe demand classes
Analyze purchase orders
Analyze manufacturing orders

Collections
Analyze & Review collections strategy
Detail the types of collection exceptions
Detail various Collection methods
Analyze & Review collected data

Analyzing Unconstrained Plans
View unconstrained exceptions
Compare and manage unconstrained exception messages
View recommendations
Peg supply and demand
Release recommendations

Constrained Plans - Enforce Capacity Constraints
Describe ECC plans
Analyze Sales order exceptions
Analyze Forecast exceptions
Analyze Late supply exceptions
Describe causes of late demands
View Gantt chart
Run and Analyze Planning detail /Plan comparison reports
View and Analyze Workflow notifications
Analyze Bottleneck resources
Review outcome of Network routings
Firm work orders

Cost-Based Optimized Plans
Setting plan options for Cost Based Optimized Plan
Describe Optimized Plans
Describe Desired Outcomes from Optimized Plan
Setting Penalty factors for Optimized Plans
Configuring targets for key performance indicators and reviewing results

Planning Strategies
Perform Net Change Plan simulation
Compare Simulation Plan results


1. You define a Supply Chain Plan of type "Production Plan."

In the Main Tabbed Region of Plan Options, you select Planned Items as "Demand schedule items only" and select the Include Critical Components check box.

Which three describe the Items in the planned organizations that are selected by the plan? (Choose three.)

All critical components of Items with the Planning Method Item Attribute of "MPS Planning" or "MPS/MPP Planned" and contained within the Demand Schedules. All sandwiched Items are also selected.
Any Item contained within Demand Schedules that has a component with the Planning Method Item Attribute of "MPS Planning" or "MPS/MPP Planned" anywhere in its supply chain bill. All sandwiched Items are also selected.
All Items contained within Demand Schedules, EXCEPT the ones with the Planning Method Item Attribute set to "Not Planned." All components of these Items are also selected, EXCEPT the ones with the Planning Method Item Attribute set to "Not Planned."
All Items contained within Demand Schedules, with the Planning Method Item Attribute of "MPS Planning" or "MPS/MPP Planned." All components of these Items with the Planning Method Item Attribute of "MPS Planning" or "MPS/MPP Planned" are also selected.
All Items contained within Demand Schedules, with the Planning Method Item Attribute of "MRP/MPP Planned," "MPS/MPP Planned," or "MPP Planned." All components of these Items with the Planning Method Item Attribute of "MRP/MPP Planned," "MPS/MPP Planned," or "MPP Planned" are also selected.

Answers ABD

2. The planning manager at your client company asks: "How much material availability would I need to arrange to satisfy all anticipated demand in a timely manner"?

The manager wants to make decisions on supplier sourcing to address the exceptions. It is generally difficult to change the resource capacity, but increased outsourcing is an option.

The planning horizon is long term.

Which Plan Class would you recommend?

Optimized Plan
Unconstrained Plan
Material Constrained Plan
Resource Constrained Plan
Material and Resource Constrained Plan
Answers D


3. The planning manager at your client company asks: "How much resource capacity would I need to arrange to satisfy all anticipated demand in a timely manner"?

The manager wants to make decisions on resource acquisition/disposition to address the exceptions. It is generally difficult to change material availability, but internal resource acquisition/disposition is an option.

The planning horizon is long term.

Which Plan Class would you recommend?

Optimized Plan
Unconstrained Plan
Material Constrained Plan
Resource Constrained Plan
Material and Resource Constrained Plan
Answers C


4. When defining Demand Priority Rules, which three Demand Types can you use to define additional priorities by Demand Class? (Choose three.)

Forecast
Sales Orders
Excess Demand
Target Inventory Level Demands

Answers AB

5. The client creates and maintains forecast data in Master Scheduling/MRP (MRP), but not in Oracle Demand Planning.

Identify three correct statements with reference to forecasting via this method. (Choose three)

You can collect these Forecasts to the planning data store
MRP Forecasts consist of similar data as Forecasts in Oracle Demand Planning
MRP Forecasts consist of different data as Forecast Sets in Oracle Demand Planning.
The Forecast from MRP does not contain detail entries at the Customer Ship-to Level.
A Forecast from MRP will always be part of a Forecast Set and the Set can contain multiple Forecasts.

Answers ABE

6. Your client wants to have the ASCP Planning engine to evaluate the delivery time and select the ship method that is most appropriate.

Identify the three required setups to enable this functionality. (Choose three.)

In the Plan options, the Optimize check box must be selected.
In the Plan options, set Schedule By to "Request Arrival Date."
Set Assignment set in Plan Options to the Assignment set containing the multiple shipping method sourcing.
Create Sourcing Rules with multiple lines for the same source utilizing different shipping methods with different transit times.
Set the MSC: ATP Assignment Set system profile to the Assignment Set containing the sourcing assignments for multiple shipping methods.
Define shipping methods and Transit times between shipping organizations and customers using the Inter-Location Transit Times Setup Screen.

Answers CDF

Click here to view complete Q&A of 1Z0-244 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-244 Certification, Oracle 1Z0-244 Training at certkingdom.com

1Z0-521 Oracle E-Business Suite R12.1 Order Management Essentials

Exam Number: 1Z0-521
Exam Title: Oracle E-Business Suite R12.1 Order Management Essentials
Associated Certification Paths
Oracle E-Business Suite 12 Supply Chain Certified Implementation Specialist: Oracle Order Management
Duration: 150 minutes
Number of Questions: 80 for both sections combined
Passing Score: E-business Essentials - 60% Order Management - 60%
Validated Against: This exam is valid for Oracle E-Business Suite 12 and 12.1.
Format: Multiple Choice

Complete Recommended Training

R12.x Oracle E-Business Suite Essentials for Implementers and
R12.x Oracle Order Management Fundamentals

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

Resources available to partners only
Training Opportunities for Oracle Partner Network Members
Oracle EBS R12.1 SCM Essentials Implementation Boot Camp
Training Resources by Exam Topics
These earlier courses are still valid exam preparation tools but are no longer being scheduled:
Oracle E-Business Suite R12: E-Business Essentials
R12 Oracle Order Management Fundamentals
R12.1 Oracle Order Management Implementation Boot Camp

E-BUSINESS ESSENTIALS

Navigating in R12 Oracle Applications
Log in to Oracle Applications
Navigate from Personal Home Page to Applications
Choose a responsibility
Create Favorites and set Preferences
Use Forms and Menus
Enter data using Forms
Search for data using Forms
Access online Help
Run and monitor Reports and Programs
Log out of Oracle Applications

Introduction to Oracle Applications R12
Explain the footprint of R12 E-Business Suite
Describe the benefits of R12 E-Business Suite
Describe R12 E-Business Suite architecture

Shared Entities and Integration
Explain shared entities within R12 E-Business Suite
Describe key integration points and business flows between products in E-Business Suite (EBS)
Identify Key Business Flows and products involved in E-Business Suite (EBS)

Fundamentals of Flexfields
Describe Flexfields and their components
Identify the steps to implement a Flexfield
Define value sets and values
Define Key Flexfields
Define Descriptive Flexfields

Fundamentals of Multi-Org
Define Multiple Organization (Multi-Org)
Describe the types of organizations supported in the Multi-Org model
Explain the entities of Multi-Org
Explain how Multi-Org secures data
Identify key implementation considerations for Multi-Org
Define Multi-Org Access Control
Explain Multi-Org preferences
Explain Enhanced Multiple-Organization Reporting
Explain the concepts of subledger accounting

Fundamentals of Workflow and Alerts
Explain Workflow concepts
Describe the benefits of Workflow

ORDER MANAGEMENT

Overview of Oracle Order Management
Describe Oracle Order Management and its main components
Explain the capabilities of Oracle Order Management
Identify the other products that Oracle Order Management integrates with

Order Entities and Order Flows
Manage Quotes
Manage Order to Cash Lifecycle with Standard Items
Manage Order to Cash Lifecycle with PTO, and ATO Items
Manage Drop Shipments
Manage Back-to-Back Orders
Manage Sales Agreements
Manage Order to Cash Lifecycle with Customer Acceptance

Multiple Organization Access Control Setup
Explain the necessity for multiple organization access control (MOAC)
Identify the Order Management windows (setup and transaction) that use the Operating Unit field and 12i specific MOAC additional features
Perform the various setups involved in implementing MOAC

Oracle Inventory Setup for Oracle Order Management
Explain the structure of an inventory organization
Define subinventories
Use units of measure
Use the item master organization
Define items
Create available-to-promise rules

Oracle Receivables Setup for Oracle Order Management
Define TCA Concepts
Define Customer Information and Payment Terms
Define Invoicing, Accounting Rules and Deferred Revenue
Explain Customer Acceptance and Billing Setups
Defining Invoicing Sources (Batch Source)
Explain Online Transaction Security and Tax-Related Setup Steps
Define Credit Checking

Oracle Order Management Setup Steps
View and Update Profile Options
Create QuickCodes or Lookups
Manage Document Sequencing
Define Transaction Types
Explain Order Header and line Workflows in Transaction Types
Set up Processing Constraints
Define Validation Templates
Define Defaulting Conditions
Define Defaulting Rules
Set up Versioning and Audit History
Setup Available to Promise
Define Scheduling
Create Credit Check Rules

Holds, Order Purge, and Exception Management Setup
Create,Apply and Release Holds - Seeded, Generic
Explain Order and Quote Purge
Explain Exception Management

Basic Pricing Setup
Describe Pricing Process and Basic Pricing Concepts
Maintain Price Lists

Define Pricing Security
Use Qualifiers with various Types of Modifiers
Apply Freight and Special Charges Modifier
Create and Use Price Books

Overview of Shipping Execution
Explain the Oracle Order Management to Oracle Shipping Execution Flow
Describe Shipping Entities
Identify User Interfaces in Oracle Shipping Execution
Identify Key Reports and Processes
Describe integration with Oracle Order Management, Oracle Transportation Execution, and Oracle Warehouse Management

Shipping Execution Setup
Define Roles and Users
Define Carriers
Shipping Execution Documents
International Trade Management Adapter
Manage Shipping Exceptions
Define Pick Release Rules
Define Ship Confirm Rules
Containers/LPNs

---

QUESTION 1
Which three statements are about freight carriers? (Choose three)

A. Freight carriers can be defined only in transportation.
B. Freight carriers are used for customer shipments.
C. Freight carriers are specific to inventory organization.
D. General ledger accounts can not be associated with freight to collect associated costs.
E. Inter organization transfer uses an associated general ledger account to specify the freight.
F. Freight carriers are used for shipments to and from customers, suppliers, and internal
organizations.

Answer: C,E,F

---

QUESTION 2
The item sub inventory report output contains _______. (Choose three)

A. EOQ
B. Source type
C. Locator control
D. Focus forecast
E. Fixed Lot multiple
F. Min-max information

Answer: B,E,F

---

QUESTION 3
A key business user requirement to those users should be able to create sales order with
distributor keys trokes.
Which four setup options facilitate reduced data entry? (Choose four)

A. Defaulting rules
B. Transaction types
C. OM: invoice source
D. Processing constraints
E. Automatic attachments rules
F. OM: invoice transaction type
G. OM: enable Related items and manual substitutions

Answer: A,B,E,G

---

QUESTION 4
ACME has offices in various countries and its customers and supports are based around the
globe.
Given that the addresses are formatted in each country, how would you setup the system to
handle this situation?

A. Ser up the address as a context-sensitive key Flexfield.
B. Ser up the address as a free format segmented value set.
C. Ser up the address as a context-sensitive descriptive field
D. Ser up the address as a dependent value set country-specific segments.

Answer: C

---

QUESTION 5
Identify three true statements regarding freight and special charges. (Choose three)

A. Accrual is valid application method for modifier type of freight/special charges.
B. Basic pricing provides seeded freight and special charges type of modifier list.
C. You can define your own implementation-specific freight and special charges type of the modifier list.
D. You can use the range price breaks in creating modifiers for freight and special charges if you are using only Basic pricing.
E. You can handle your own implementation-specific freight cost type or freight charges type codes for use in modifiers for calculating freight and special charges.
F. When there are two equal modifiers with the highest precedence in an incompatibility level, the pricing engine selects the modifier that provides the best benefit to the customer.

Answer: B,E,F

Click here to view complete Q&A of 1Z0-521 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-521 Certification, Oracle 1Z0-521 Training at certkingdom.com

1Z0-160 Oracle Database Cloud Service

Exam Number: 1Z0-160
Exam Title: Oracle Database Cloud Service
Associated Certification Paths
Oracle Database Cloud Administrator Certified Professional
Oracle Database Cloud Service Operations Certified Associate
Oracle Database Cloud Administrator Certified Associate

Duration: 120 minutes
Number of Questions: 70
Passing Score: 63%

Validated Against:
Exam has been validated against Oracle Database as a Service Cloud v 12.1.0.3
Format: Multiple-Choice

Complete Recommended Training
Complete the training below to prepare for your exam (optional):

Database Cloud Channel
Oracle Database Cloud for Oracle DBAs Ed 3

Additional Preparation and Information
A combination of Oracle training and hands-on experience (attained via labs and/or field experience) provides the best preparation for passing the exam.

The 1Z0-160 - Oracle Database Cloud Service Certification exam validates concepts and skills covering the full Database product family and focuses on the Database Cloud Service (DBCS) only. It is primarily designed for On-Premise DBAs to add cloud expertise to their certification titles, and for operators that use DBCS to provision services. If you are looking for a certification that covers ALL of the services in the DB Cloud family, please see the Data Management CLS and exam 1Z0-950: Oracle Data Management Cloud Service 2018 Associate

The contents covered in this exam is based on OCI-C.

Creating Database Deployment
Fundamentals of Oracle Database Cloud Service
Identify the steps for creating a Database Deployment
Identify Database Deployment options and service levels.
Allocate the Oracle Cloud Service storage volumes when a Database Deployment instance is created
Multi-Tenant- Advantage and value proposition.

Database Deployment Administration
Use My Service Dashboard and Database Cloud Console
Administer users/privileges needs for the Oracle Cloud Service
Administer storage/disks requirements of the Oracle Cloud Service
Patch your Database Deployment
Differentiate between oracle and opc users
Configure SSH connections to compute node in Database Deployment
Database Deployment backup and restore utilities and options.

Database Deployment Connectivity and Security
Configure Security rules
User authentication and roles
Generate an SSH Public/Private key pair
Create an SSH tunnel to a port in the compute node
Enable access to DBaaS Monitor
Connect remotely to the Database Deployment database using SQL*Net
Administer Oracle REST Data Services (ORDS)
Enable access to Oracle Application Express (APEX)

Performance and Scaling
Identify Scaling issues for Compute and Storage.
Learn how to avoid and resolve Database Deployment performance issues.

QUESTION: No: 1
You want all your colleagues to be able to access the compute node associated with an Oracle Database
Cloud - Database as a Service (DBaaS) instance. You want them to do so by using a custom host name
rather than an IP address regardless of the client machine (personal or provided by the company) that
they use for the access.

How would you enable this access?

A. Configure the Advanced Security Option (ASO).
B. Enable secure access to the DBaaS instance VNI and database instance from remote hosts by using SSH.
C. Contact the administrator of your company's intra net DNS and request a custom DNS record for the compute node's public IP address.
D. Edit the machine's/etc/hostsfile.
E. Resolve your domain name to the IP address of the DBaaS compute node by using the third-party domain registration vendor console.

Answer: C

Explanation:
You can associate a custom host name or domain name to the public IP address of a compute node
associated with your Oracle Database Cloud Service environment.
To associate a custom host name to the public IP address of a compute node, contact the administrator of
your DNS (Domain Name Service) and request a custom DNS record for the compute node's public IP
address. For example, if your domain is exampIe.com and you wanted to use clouddbl as the custom
host name for a compute node, you would request a DNS record that associates cIouddbI.exampIe.com to
your compute node's public IP address.

References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/define-custom-host-or-domainname.html

QUESTION: No: 2
With Oracle Database Cloud Service as the subscription type, you must configure a database for Backup and Recovery.
Which two options do you have to back up your database instance?

A. No backups required. You are responsible for configuring the database backups.
B. Backup to cloud storage and VIVI block storage. Ten days worth of backups are kept, with five most recent days worth of backups available directly on VIVI block storage.
C. Backup to Oracle Cloud Service storage volumes that is equal to five times the value that was provided in Usable Data Storage when the instance was created.
D. Backup to cloud storage and VIVI block storage. Fourteen days worth of backups are kept, with seven most recent days worth of backups available directly on VNI block storage.

Answer: A,C

Explanation:
When creating a new database deployment on Oracle Database Cloud Service, you choose whether you
want automatic backups to be configured for the database. Your choices are:
Both Cloud Storage and Local Storage-30 days' worth of backups are kept, with the 7 most recent days'
worth available directly on the compute node's local storage.
Cloud Storage Only-30 days' worth of backups are kept, with all backups on cloud storage.
None-automatic backups are not configured.
References:
https://docs.oracIe.com/en/cloud/paas/database-dbaas-cloud/csdbi/db-depIoyments.htmI

QUESTION: No: 3
Users must be granted roles to manage Cloud services.
Which three statements are true about roles and role assignment in Database as a Service (DBaaS)?

A. Service administrators can assign and remove roles only for users of the services that they manage.
B. The DBaaS Database Administrator role permits granting the DBaaS Database Administrator or DBaaS Database Operator role to existing users.
C. Identity domain administrators can assign and remove roles for users in any identity domains.
D. The DBaaS Database Operator role permits the ability to scale, patch, and backup or restore service instances.
E. DBaaS network administrators can grant access privileges to designated users.

Answer: A,D,E

Explanation:

A: A Service administrator manages administrative functions related to Oracle Cloud services within an identity domain.
D: The privileges given to the DBaaS Database Administrator role include:
Can scale, patch, and back up or restore database deployments

QUESTION: No: 4
Which users are created and can be used for database and host management of your DBaaS database servers?

A. root, opc and oracle users
B. root, oracle and cloud users
C. root and oracle users
D. opc and oracle users
E. cloud and oracle users

Answer: D

Explanation:
Linux user accounts that are provisioned on an Oracle Database Cloud Service deployment that hosts an Oracle Real Application Clusters (Oracle RAC) database:
* ope
The system administrator account you use to connect to the compute node using SSH. This user can use the sudo command to perform operations that require root-user access.
* oracle
The Oracle Database administrator account you use to access the system and perform non-root database administration tasks.
* grid
The Oracle Grid Infrastructure administrator account you use to perform ASNI, ACFS, and cluster ware administration tasks.
* root
The root administrator for the system. You do not have direct access to this account. To perform
operations that require root-user access, use the sudo command as the ope user.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/Iinux-user-accounts-rac.html

QUESTION: No: 5
Which two situations require that your Database as a Service (DBaaS) instance be scaled up?

A. The DBaaS instance is maxed out on semaphore sets.
B. The database instance has reached the limit in the Iicense_max_sessions database parameter.
C. The DBaaS instance is maxed out on CPU.
D. The database instance is out of space in the sysaux and system tablespaces.
E. The DBaaS instance is maxed out on storage.
F. The DBaaS instance is maxed out on semaphores.

Answer: C,E
Explanation:

Existing DBCS instances may scale up to bigger shapes in OCPU, IVIemory and Storage for vertical scaHng.
For horizontal scaling, DBCS provides RAC with the Extreme Performance option currently allowing applications to scale up to 2 nodes, each with a max of 160CPU shapes.
Note: An Oracle CPU (OCPU) provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads,
known as vCPUs.
References:
https://cloud.oracIe.com/opc/database/faq

Click here to view complete Q&A of 1Z0-160 exam
Certkingdom Review, Certkingdom PDF Torrents

Best Oracle 1Z0-160 Certification, Oracle 1Z0-160 Training at certkingdom.com