Exam MB2-719 Microsoft Dynamics 365 for Marketing

Published: June 28, 2018
Languages: English
Audiences: IT Professionals, Sales and Marketing Specialists
Technology: Microsoft Dynamics 365 for Marketing
Credit toward certification: MCP, MCSA

Skills measured
This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Do you have feedback about the relevance of the skills measured on this exam? Please send Microsoft your comments. All feedback will be reviewed and incorporated as appropriate while still maintaining the validity and reliability of the certification process. Note that Microsoft will not respond directly to your feedback. We appreciate your input in ensuring the quality of the Microsoft Certification program.

If you have concerns about specific questions on this exam, please submit an exam challenge.

If you have other questions or feedback about Microsoft Certification exams or about the certification program, registration, or promotions, please contact your Regional Service Center.

Set up and configure Microsoft Dynamics 365 for Marketing (10 – 15%)
Set up Microsoft Dynamics 365 for Marketing
Perform initial set up steps; configure organizational, business management, and customization settings; define default matching strategies; view quota limits
Configure other settings
Configure event settings; configure Customer Insights synchronization; upload images to file storage; view and manage keywords for an organization; create templates, including activity templates
Manage data quality and privacy
Identify GDPR rules for individuals and organizations; identify how Microsoft Dynamics 365 supports GDPR; configure permission-based marketing; track online behavior; manage email unsubscribe requests; manage data imports and deduplication
Integrate Microsoft Dynamics 365 for Marketing with other services
Integrate with the Customer Insights service; use Power BI to view Microsoft Dynamics 365 for Marketing data; identify how custom channels work with Microsoft Dynamics 365 for Marketing

Manage segments and lists (10 – 15%)
Create and manage segments
Identify segment types; create market segments including dynamic, static, and suppression segments; implement segment naming rules; view segment entities and relationships by using the Explore hyperlink; configure dynamic segments by using the Designer; combine segments using union, exclude, or intersect logic
Create and manage subscription centers and lists
Identify usage scenarios for subscription lists; create a subscription list; add a subscription list to a form; create a segment based on a subscription list

Create and manage marketing forms and pages (10 – 15%)
Create marketing forms
Identify types of marketing forms; identify form requirements and limitations; create a marketing form by using a template; create landing forms, subscription centers, and Forward to a Friend pages
Create and manage marketing pages
Create marketing pages; add form blocks to marketing pages; add forms to form blocks; apply a style to marketing pages; integrate marketing pages with marketing emails; create and use dynamic tests links; implement dedicated marketing page blocks; preview and validate marketing pages; publish a marketing page

Manage leads (10 – 15%)
Create and manage leads
Identify and describe stages in the lead life cycle; create leads manually or automatically; synchronize leads from LinkedIn by using the LinkedIn connector; create segments by using Microsoft Dynamics Customer Insights integration
Assess sales readiness
Create fixed rule and behavior rule scoring conditions; create compound conditions; set up single and multiple condition models; configure advanced lead scoring; configure sales readiness thresholds; review lead conversion metrics

Create and manage marketing emails (10 – 15%)
Create email messages
Create an email message by using a template; use basic HTML markup to create email messages; identify mandatory dynamic fields; add dynamic content to email messages
Publish and manage email messages
Identify message requirements; preview messages by using the Basic and Inbox options; validate messages; publish messages

Manage customer journeys (10 – 15%)
Create journeys
Identify and describe journey template types; identify content types; set up a customer journey; implement Activity and Launch Workflow options; implement targets; identify flow control components; implement flow control for journeys
Publish and manage journeys
Configure required options for publishing journeys; check campaigns for errors; publish a campaign; display customer journey insights

Manage events (5 – 10%)
Create events and webinars
Create an event team; set up sessions, including internal and external tracks; set up speakers; create event passes; set up venues; manage sponsors; manage vendors, logistics, and accommodations; identify webinar types; configure webinar options
Manage webinars
Configure the event portal; create event invitations, banners, and social media posts; register and check in attendees; gather event feedback; review events

Create and distribute surveys (5 – 10%)
Create surveys
Create a theme and upload images; add pages to a survey and personalize data; identify survey question types; add survey questions; identify respondent types; configure responsive routing
Preview, test, and publish surveys
Add surveys to emails; add surveys to customer journeys; clone, import, and translate surveys
Manage survey responses
Interpret survey results; identify report types; run reports; view data in the survey dashboard; create leads from surveys

Question: 1
You create a customer journey for a group of contact records.
You need to make the following modifications to the journey;
• Wait for a contact to respond to a survey and then move the contact along in the journey based on values submitted in the survey.
• Move GO percent of the contacts on a different path in the journey than the other 40 percent.

What should you do?

A. Add invoke workflow and survey tiles.
B. Add scheduler and survey tiles.
C. Add event and record update tiles.
D. Add trigger and splitter tiles.

Answer: A

Question: 2
You observe that some marketing emails that are part of customer journeys are not sent out.
Information about the emails displays in Customer Journey Blocked Email Insights.
You need to determine the cause for the issue.
What are three possible reasons why the emails are not sent? Each coned answer presents a complete solution.

A. A Dynamics 365 internal error prevents email sends.
B. The contact has unsubscribed from receiving marketing emails.
C. The contact has been added to a suppression segment.
D. The contact record has a lowered General Data Protection Regulation (GDPR) consent level.
E The contact’s email server was not online when the email was sent

Answer: B,D,E

Question: 3
You need to track customer journey page visits. Which content type tile should you use?

A. marketing page
B. event
C. activity
D. email message

Answer: B

Click here to view complete Q&A of MB2-719 exam
Certkingdom Review
, Certkingdom PDF Torrents

 MCTS Training, MCITP Trainnig

 Best Microsoft MCP MB2-719 Certification, MCP MB2-719 Training at certkingdom.com

1Z0-242 PeopleSoft Application Developer II: Application Engine & Integration

Exam Number: 1Z0-242
Exam Title: PeopleSoft Application Developer II: Application Engine & Integration (Retiring on January 1, 2019)
Associated Certification Paths Passing this exam is required to earn these certifications. Select each certification title below to view full requirements.
PeopleTools 8 Advanced Developer Certified Expert (Retiring on January 1, 2019)
OPN Certified Specialist

Duration: 120 minutes
Number of Questions: 85
Passing Score: 65%
Validated Against:  This exam has been validated against Rel. 8.48, 8.50 and 8.51
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):
PeopleSoft Application Engine Rel 8.50
PeopleSoft Integration Tools Rel 8.50

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.

These earlier courses are still valid exam preparation tools but are no longer being scheduled:
Application Engine Rel 8.48
Integration Tools Rel 8.48
Sample Questions
Training Opportunities for Oracle Partner Network Members (available to partners only)
Training Resources by Exam Topics (available to partners only)

This exam retires on January 1, 2019.

PeopleCode
Using PeopleCode Development Tools

Debug PeopleCode programs using Debug, trace, and Message Box

Using PeopleCode Variables

Configure variable prompt tables
Instantiate, populate, and access arrays

Referencing Data in the Component Buffer

Traverse the data buffer to reference multiple occurs levels

Creating Custom Objects with Application Classes

Use the Application Class Editor to create and modify application classes
Convert existing PeopleCode programs to application classes

Using Data Buffer Methods

Use standalone rowsets

Executing SQL in PeopleCode

Read and modify data tables using the SQL class and Record objects
Incorporate meta-SQL in PeopleCode and SQL

Testing and Debugging

Use Process Monitor to monitor App Engine programs
Trace Application Engine programs
Debug App Engine programs
Use Restart in App Engine programs

Using the Do Select Action

Use Do Select
Use Restartable

Incorporating Conditional Processing

Define Do actions and explain Do action program flow
Create conditional statements using SQL
Use Application Engine libraries

Using PeopleCode with Application Engine

Insert PeopleCode into an Application Engine program
Use dynamic calls

Using Set Processing

Modify a program to use set processing

Using Temporary Tables

Implement parallel processing
Explain run time allocation

Executing Application Engine Programs

Configure a push button to execute an App Engine program
Execute an Application Engine program with a command script

Creating Process Definitions for Application Engine

Configure Process Scheduler to run Application Engine processes

Using PSDAEMON

Create and implement PSDAEMON programs

Measuring Application Engine Performance

Trace Application Engine programs

Tuning Application Engine Programs

Performance tune Application Engine programs

Integration Tools

Introducing PeopleSoft Integration Broker Architecture

Describe the components of the PeopleSoft Integration Gateway

Configuring PeopleSoft Integration Broker

Configure PeopleSoft Integration Broker
Create and configure nodes

Creating Messages

Define service configuration
Create rowset and non-rowset based messages
Use message parts.

Creating Service Operations

Add and secure service operations
Create and configure queues
Add routings

Sending and Receiving Service Operations

Publish Service Operations using rowsets
Create Handlers for asynchronous service operations
Create handlers for synchronous service operations
Add handlers

Monitoring Service Operations

Monitor asynchronous services
Monitor synchronous services
Administer service operations
Monitor service operation performance and archive monitor data

Using Service Utilities

Administer services
Use the Handler Tester

Using the Oracle XSL Mapper

Install and configure JDeveloper
Create an application engine transform program
Test transform programs
Version and logically transform service operations

Applying Translations and Filtering

Create code sets for data translation
Write a transformation program for data translation

Testing Connector and Messages Using Send Master

Use Sendmaster to test service operation

Creating and Testing Component Interfaces

Describe the elements of a component interface definition
Create component interfaces
Set component interface security and test

Implementing Component Interfaces

Add component interface PeopleCode to an application

Working with Component Interface Collections

Write PeopleCode for component interface collections

Enabling Component Interfaces as Services

Use component interfaces as web services

Providing and Consuming Web Services

Provide web services
Consume web services
Secure web services

Using the Excel to Component Interface Utility

Create an application using Excel to Component Interface Utility

Importing Data into the PeopleSoft System Using Flat Files

Create file layout definitions
Import data using file layouts

Writing Data to Flat Files

Create application engine programs to export data to flat files
Create multilevel file layouts including segments


QUESTION 1
You created a component interface with the standard methods of Create, Find, Get, Cancel, and
Save. You secured the component interface and provided full access to all the methods. You want
to test the GET method to access the online information. Which three steps will you use to test the
GET method? (Choose three.)

A. Open the component interface in Application Designer.
B. Right-click in the component interface view and select Test Component Interface.
C. Save the data by selecting File, Save.
D. Use the Find option to test the GET method after supplying key values.
E. Use the Get Existing option to test the GET method after supplying key values.
F. Enter data in the Component Interface Tester tool.
G. Validate that the data has been modified and saved by accessing the online component or using the database query tool.

Answer: A,B,E


QUESTION 2
An Application Engine program uses a Do Select action. What occurs when the Select statement
is executed?

A. Each row returned by the Select statement is stored in the state record. The Select statement
continues until no more rows are returned. Then, the control passes to the calling section.
B. All rows returned by the Select statement are stored in a cursor. Then, the control is passed to
the calling section.
C. All rows returned by the Select statement are stored in the state record. Then, the control is
passed to the next section in the program.
D. All rows returned by the Select statement are stored in a cursor. The first row is stored in the
state record. Then, the remaining actions in the step are processed sequentially. Thereafter, the
control returns to the Do Select to fetch another row, until no more rows are returned.
E. When a row is returned, the remaining steps in the section execute and control returns to the
calling step.
F. When a row is returned, it is stored in the state record. Then, the control is passed to the calling
section.

Answer: D


QUESTION 3
View the Exhibit that shows the definition for the PO_QUEUE queue

Which three statements describe how this queue will function? (Choose three.)

A. Messages will be processed in parallel.
B. All messages will be processed sequentially in the order in which they are sent.
C. If an error occurs on a message, all subsequent messages will remain in a status of New.
D. If an error occurs on a message, all messages except those with the same high-level key will
continue to process.
E. When the PeopleSoft Integration Broker archive process is run, the system will delete message
transaction data from the current run-time tables.
F. When the PeopleSoft Integration Broker archive process is run, the system will write message
transaction data to the archive tables and delete the data from the current run-time tables.

Answer: B,C,F


QUESTION 4
Which two tasks do you need to complete after consuming a Web service? (Choose two.)

A. Add a point-to-point routing.
B. Add the appropriateOnRequest handler.
C. Secure the service operation with a permission list.
D. Write thePeopleCode to invoke the service operation.
E. Update the connection properties on the service operation.

Answer: C,D


QUESTION 5
Which IntBroker class method do you use to send a synchronous request?

A. Publish
B. InboundPublish
C. SyncRequest
D. GetSynclBlnfoData
E. ConnectorRequest

Answer: C

 

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

MCTS Training, MCITP Trainnig

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

 

1Z0-466 Project Lifecycle Management (PLM) Essentials

Exam Number: 1Z0-466
Exam Title: Project Lifecycle Management (PLM) Essentials
Associated Certification Paths Project Lifecycle Management Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 70
Passing Score: 70%
View passing score policy
Validated Against:
Format: Multiple Choice

Complete Recommended Training

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

Project Lifecycle Management Implementation Specialist Guided Learning Path (For Partners Only)

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.

Project Management Basics
Define a project
Transition from sales to delivery
Plan a project and related documentation

Oracle Unified Method
Explain Oracle Unified Method
Explain the Manage Focus Area
Explain the Envision Focus Area
Explain the Implement Focus Area
Employ Use Cases

Applying Method Principles
Apply the guiding method principles
Manage work, risk and scope
Control the project
Manage quality and change
Explain strategies for overcoming organizational change
Plan using iterations
Close the project

Manage Focus Area
Define the goals, benefits and components of the Manage Focus Area
Explain the structure of the Manage Focus Area
Describe the key concepts and principles of the Manage Focus Area
Apply the Manage Focus Area
Plan a project


QUESTION 1
Select the three statements that are true about the Project management Plan.

A. It is created in the Manage Project Execution and Control phase.
B. It is the single most important work product produced by the project manager.
C. Its main focus is on scheduling the project.
D. It is created by the project manager and the client.
E. It is a conceptual work product comprised of process components detailing the tools and/or
approach for each OUM Manage process.
F. It provides a framework for the Analysis and Design processes.

Answer: B,D,F

Explanation: *In OUM Manage, one of the first activities that occur during the Project Startup
phase involves the Project Manager and the client (Project Sponsor) jointly creating the Project
Management Framework. This framework establishes the ground rules for the project and is the
first step in communicating, establishing trust, and setting expectations.
The key focus for the remainder of the Project Startup Phase is to evolve the Project Management
Framework into a detailed Project Management Plan based on the agreed upon foundation.
*The project manager creates the project management plan following input from the project team
and key stakeholders. The plan should be agreed and approved by at least the project team and
its key stakeholders.
Incorrect:
Not A:Project Execution and Control runs concurrently with the Implement focus area phases. The
purposeof the Project Execution and Control Phase is to provide adequate visibility into actual
progress so thatmanagement can take effective actions when the project’s performance deviates
significantly from theproject plans. The Project Execution and Control Phase includes tracking and
reviewing the projectsaccomplishments and results against documented WBS,project estimates,
time schedule, resourcesplan, and cost budget, and adjusting these plans based on the actual
accomplishment and results.


QUESTION 2
Select the three constraints that are missing in this Triple Constraint triangle.

A. Usability
B. Scope
C. Cost
D. Complexity
E. Product
F. Schedule

Answer: B,C,F

Explanation: *Scope, Time & Cost together are termed as the Triple Constraints of a Project.
*Risk avoidance involves changing the project plan to eliminate therisk or to protect the project
objectives (time, cost, scope, quality) from itsimpact. The team might achieve this by changing
scope, adding time, oradding resources (thus relaxing the so-called “triple constraint”)
Note:


QUESTION 3
Which two statements are true about the Change Control Board (CCB)?

A. It meets daily during Project Execution and Control.
B. It is an internal project organization that is responsible for reviewing and resolving change
requests.
C. It is a person, group, or business that has a shared interest in a particular set of activities.
D. It escalates changes affecting scope to the steering committee.

Answer: B,D

Explanation: B:CCB is a review committee that discusses and approves requests for changes to
On Demand customer system configurations. The change requests are fulfilled in the following
ways:
A work guideline is generated by engineering for operations to use and implement.
The changes are included in Oracle Certified Configurations.
D:A Steering Committee is a group of high-level stakeholders who are responsible for providing
guidance on overall strategic direction. They do not take the place of a Sponsor, but help to
spread the strategic input and buy-in to a larger portion of the organization. The Steering
Committee is usually made up of organizational peers and is a combination of direct clients and
indirect stakeholders. Some members on the Steering Committee may also sit on the Change
Control Board.


QUESTION 4
Which identifies the quality standards that are relevant to the project and how to satisfy them?

A. Quality Assurance
B. Quality Control
C. Quality Planning
D. Process Improvement

Answer: A,D

Explanation:


QUESTION 5
Select two objectives of the OUM Implement Elaboration phase.

A. Confirm the project scope.
B. Identify and validate the architecturally significant requirements.
C. Identify key configuration decisions.
D. Prepare the system for acceptance test and deployment.
E. Address critical operational issues.
F. Obtain acceptance.

Answer: B,C

Explanation: The goal of the Elaboration phase is to develop the detailed requirements, partition
the solution, create any necessary prototypes, and baseline the architecture of the system. This
effort results in a stable basis for the design and implementation effort in the Construction phase.
The architecture evolves from the most significant requirements(B), those that have the greatest
impact on the architecture of the system, and an assessment of risk. The stability of the
architecture is evaluated through one or more architectural prototypes. During the Elaboration
phase, the project team’s understanding of the client’s business requirements is verified to reduce
development risk.
Note:
OUM includes the following phases.
InceptionElaborationConstructionTransitionProduction
Reference:OracleUnified Method (OUM)Oracle’s Full Lifecycle Method for Deploying Oracle-
Based Business Solutions

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

MCTS Training, MCITP Trainnig

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

 

1Z0-587 Oracle Customer Hub and Oracle Data Quality Essentials

Exam Number: 1Z0-587
Exam Title: Oracle Customer Hub and Oracle Data Quality Essentials
Associated Certification Paths Oracle Customer Hub and Oracle Data Quality Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 71
Passing Score: 62%
Validated Against: This exam has been validated against 8.2
Format: Multiple Choice

Complete Recommended Training

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

Oracle Customer Hub and Oracle Data Quality Certified Implementation Specialist (available to partners only)

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.

Understanding Universal Customer Master (UCM)
Describe UCM components and functionality
Describe UCM Extension Hubs and their functionality
Use Cross referencing
Register external systems
Use Source Data and History tables
Use Master Data Management Analytics

UCM Batch / Bulk Import
Describe the role of the Enterprise Integration Manager (EIM) and Source Data History (SDH) tables
Use EIM to perform a batch import
Use UCM Batch Manager to transfer records into the base tables
Use UCM List Import to perform a batch import
Correct incomplete transactions

Data Quality Matching

Describe the Data Quality Server
Configure the Data Quality Engine
Configure UCM for matching
Modify matching behavior

Data Cleansing & Address Validation

Describe the Data Quality Parsing and Standardization Server
Configure UCM for address validation
Validate and standardize addresses

Data Quality Profiling
Describe the Data Quality Profiling Server
Use scorecards and generate Profiling Reports
Create reference data

Data Stewardship, Suvivorship and Suspect Matching
Configure survivorship rules
Examine and process suspect match records
Merge records and use guided merge
Unmerge records

Data Governance
Use Data Governanace Manager
Configure Privacy Tools
Use Heriarchy Management

UCM Integration Services

Describe the UCM integration capabilities
Configure UCM web services
Use out-of-the-box Oracle AIA PIPs
Configure Publish/Subscribe

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

MCTS Training, MCITP Trainnig

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

1Z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration

Exam Number: 1Z0-068
Exam Title: Oracle Database 12c: RAC and Grid Infrastructure Administration
Associated Certification Paths Oracle Certified Expert, Oracle Database 12c: RAC and Grid Infrastructure Administrator
Duration: 140
Number of Questions: 90
Passing Score: Section 1 – 60%; Section 2 – 45%; Section 3 – 33%
View passing score policy
Validated Against:
Exam has been validated for product version 12.1.0.1.0.
Format: Multiple Choice

Complete Recommended Training

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

Candidates should take all of the three standalone courses listed to prepare for this exam.

Oracle Database 12c: ASM Administration and
Oracle Database 12c: Clusterware Administration and
Oracle Database 12c: RAC Administration

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.

Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-068: Oracle Database 12c: RAC and Grid Infrastructure Administration

Oracle Database 12c: RAC Administration

Grid Infrastructure

Explain the principles and purposes of clusters
Describe the Oracle Clusterware architecture
Describe how Grid Plug and Play affects Clusterware

RAC Databases and Architecture

Describe the benefits of Oracle RAC
Explain the necessity of global resources
Describe global cache coordination

Installing and Configuring Oracle RAC

Install the Oracle database software
Create a cluster database
Perform post-database-creation tasks
Convert a single instance Oracle database to RAC

Administering Oracle RAC

Use Enterprise Manager Cluster Database pages
Define redo log files in a RAC environment
Define undo tablespaces in a RAC environment
Start and stop RAC databases and instances
Modify initialization parameters in a RAC environment

Managing Backup and Recovery for RAC

Configure the RAC database to use ARCHIVELOG mode and the fast recovery area
Configure RMAN for the RAC environment

Managing Global Resources

Explain the need for global concurrency control
Describe the Global Resource Directory
Explain how global resources are managed
Explain global enqueue and instance lock management
Explain global buffer cache management

RAC Database Monitoring and Tuning

Identify RAC-specific tuning components
Determine RAC-specific wait-events, global enqueues and system statistics
Implement the most common RAC tuning practices
Use the Cluster Database Performance pages
Use the Automatic Workload Repository (AWR) in RAC
Use Automatic Database Diagnostic Monitor (ADDM) in RAC

Managing High Availability of Services

Configure and manage services in a RAC environment
Use services with client applications
Use services with the Database Resource Manager
Use services with the Scheduler
Configure services aggregation and tracing

Managing High Availability for Connections and Applications

Configure client-side connect-time load balancing and failover
Configure server-side connect-time load balancing
Use the Load Balancing Advisory (LBA)
Explain the benefits of Fast Application Notification (FAN)
Configure server-side callouts
Configure the server- and client-side ONS
Configure Transparent Application Failover (TAF)

Upgrading and Patching Oracle RAC

Describe the different types of patches
Plan for rolling patches and rolling updates
Install a patchset with the Oracle Universal Installer (OUI) utility
Install a patch with the opatch utility

Managing Oracle RAC One Node

Perform an online database migration
Add an Oracle RAC One Node database to an existing cluster
Convert an Oracle RAC One Node database to a RAC database
Use DBCA to convert a single-instance database to a RAC One Node database

Using Oracle Database Quality of Service Management (QoS)

Explain the purpose and benefits of using QoS
Describe the components of QoS
Explain the operation of QoS

Using Multitenant Architecture in a RAC Environment

Describe the multitenant architecture in RAC and non-RAC environments
Create a RAC multitenant container database (CDB)
Create a pluggable database (PDB) in a RAC CDB
Use the default CDB and PDB services
Create PDB services to associate PDB services with server pools
Drop a PDB from a RAC CDB

Oracle Database 12c: Grid Infrastructure Administration

Introduction to Clusterware

Explain the principles and purposes of clusters
Describe Cluster hardware best practices
Describe how Grid Plug and Play affects Clusterware

Oracle Clusterware Architecture

Explain the Oracle Clusterware architecture
Describe Oracle Clusterware startup details

Flex Clusters

Explain the Flex Cluster architecture and components
Describe the effect of node failure in a Flex Cluster

Grid Infrastructure Installation Planning and Pre-Tasks

Plan for Grid Infrastructure installation
Verify system and network requirements
Install required OS packages
Set kernel parameters
Create groups and users
Create directories
Configure shell limits

Grid Infrastructure Installation

Install Grid Infrastructure
Verify the installation
Configure ASM disk groups

Managing Cluster Nodes

Perform the prerequisite steps to extend a cluster
Use addNode.sh to add a node to a cluster
Delete a node from a cluster

Traditional Clusterware Management

Perform day to day Clusterware administration tasks
Perform Oracle Cluster Registry (OCR) backup and recovery
Manage network settings
Explain the scope and capabilities of what-if command evaluation

Policy-Based Cluster Management

Explain the architecture and components of policy-based cluster management
Administer server categorization
Administer a policy set
Activate a policy

Upgrading and Patching Grid Infrastructure

Explain the types of patches and upgrades available
Plan for rolling patches and rolling upgrades
Compare software versions with the active version
Install a patchset with the Oracle Universal Installer (OUI)
Install a patch with the opatch utility

Troubleshooting Oracle Clusterware

Locate the Oracle Clusterware log files and use diagcollection.pl
Enable resource debugging
Enable component-level debugging
Enable tracing for Java-based tools
Troubleshoot the Oracle Cluster Registry (OCR) file

Making Applications Highly Available with Oracle Clusterware

Explain the hivh availability components of Oracle Clusterware
Explain policy-managed and administration-managed databases
Create an application Virtual IP (VIP)
Manage application resources

Automatic Storage Management (ASM) Administration

Overview of ASM

Explain the Automatic Storage Management (ASM) architecture
Describe the components of ASM

Administering ASM Instances

Explain and apply initialization parameters for ASM instances
Manage ASM instances and associated processes
Monitor ASM instances using the V$ASM dynamic performance views

FLEX ASM

Describe the architecture and components of Flex ASM
Install and configure Flex ASM
Manage Flex ASM

Administering ASM Disk Groups

Create and delete ASM disk groups
Set the attributes of an existing ASM disk group
Perform ongoing maintenance tasks on ASM disk groups
Explain key performance and scalability considerations for ASM disk groups

Administering ASM Files, Directories and Templates

Use client tools to access ASM files
Describe the format of a fully qualified ASM file name
Explain how ASM files, directories and aliases are created and managed
Describe and manage disk group templates

Administering Oracle CloudFS

Administer ASM Dynamic Volume Manager
Manage ASM volumes
Implement ASM Cluster File System (ACFS)
Use ACFS snapshots

Oracle CloudFS Advance Topics

Configure ACFS auditing
Implement ACFS encryption
Configure and manage ACFC replication
Implement ACFS tagging
Describe the ASCF plug-in architecture
Configure High Availability NFS

QUESTION 1
Which three statements are true about ASM Cloud File System (ACFS) auditing?

A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
B. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
C. acfsutil audit init must be run by a system administrator.
D. acfsutil audit purge can be run by an audit manager.
E. acfsutil audit read marks audit files to indicate that it is safe to purge them.

Answer: C,D,E

Explanation:
C: The acfsutil audit init command must be run by the system administrator before enabling auditing for any of the audit sources on a file system.
D: Only an audit manager can run the acfsutil audit purge command.
E: acfsutil audit read marks the audit trail to indicate to the audit manager that the log archive file for the currentnode has been reviewed, backed up as necessary, and is safe to purge.

QUESTION 2
Which three statements are true about Oracle Enterprise Manager Topology Viewer?

A. It displays which listeners listen on behalf of which instances.
B. It displays the relationship between targets of different target types in a cluster.
C. It displays the status of all cluster components.
D. It displays the status of Pluggable Databases (PDBs) in a multitenant container database (CDB).
E. It displays the relationship between clustered ASM and cluster databases ifthe database is stored in ASM.
F. It displays the type of network used by RAC database instance.

Answer: A,B,E

Explanation:
Using the topology view you can quickly see the components that comprise your cluster database environment, such as database instances, listeners, Oracle ASM instances, hosts, and interfaces.
Note: Enterprise Manager provides a Topology Viewer which is a graphical representation of routing relationships across targets, components and elements. You can easily determine how requests arerouted across components. For
example, you can see how requests are routed from Oracle Web Cache, to Oracle https: Server, to a Managed Server, to a data source.
The Topology Viewer allows you to view the relationships between components, nodes, or objectswithin different Oracle applications.
References:https://docs.oracle.com/database/121/TDPRC/racmon2.htm#TDPRC350

QUESTION 3
Which three statements are true about the services created when the DBCA is used to create a RAC database?

A. They can be policy managed for a multitenant database.
B. Singleton servicesare not permitted for multitenant databases.
C. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server pool for a service.
D. Policy-managed services specified for a database allow the creation of a new server pool using DBCA.
E. They can be administrator managed for a multitenant database.

Answer: B,C,E

Explanation:
C: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in
Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
E: During installation, if you select a multitenant container database (CDB), and configure pluggable databases (PDBs), then Oracle recommends that you add services to the PDBs after installation.
IncorrectAnswers:
D: Cluster Managed Services are no longer managed through DBCA. Instead, use the Cluster Managed Services page in
Oracle Enterprise Manager Cloud Control, if available, or SRVCTL.
References:https://docs.oracle.com/database/121/RIWIN/dbcacrea.htm#RIWIN1320

QUESTION 4
When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?

A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster
B. using Shared GNS running on another cluster
C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster
D. creation of a new GNS for this cluster
E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster

Answer: B,D,E

Explanation:
B: With dynamic configurations, you can configure GNS to provide name resolution for one cluster, or to advertise resolution for multiple clusters, so that a single GNS instance can perform name resolution for multiple registered
clusters. This option is called shared GNS.
D: With static configurations, no subdomain is delegated. A DNS administrator configures the GNS VIP to resolve to a name and address configured on the DNS, and a DNS administrator configures a SCAN name to resolve to three static
addresses for the cluster.
E: With automatic configurations, a DNS administrator delegates a domainon the DNS to be resolved through the GNS subdomain. Automatic configuration occurs in one of the following ways:
References:https://docs.oracle.com/database/121/CWADD/admin.htm#CWADD838

QUESTION 5
Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = ‘SEQ1’;
O CACHE_SIZE S K
— ——————- — —
Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence.
The SEQ1 sequence is incremented from all instances equally and is frequently used.
Which two statements should you execute to reduce SQ enqueue contention?

A. alter sequence seq1 cache 10000;
B. alter sequence seq1 order;
C. alter sequence seq1 noorder;
D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’)
E. alter sequence seq1 keep;

Answer: A,D

Explanation:
A: Use cache.
D: The KEEP procedure keepsan object in the shared pool. Once an object has been kept in the shared pool, it is not
subject to aging out of the pool. This may be useful for frequently used large objects. When large objects are brought
into the shared pool, several objects may needto be aged out to create a contiguous area large enough.
References: https://ora600tom.wordpress.com/2015/01/09/enq-sq-contention/
https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_shpool.htm#i999221

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

MCTS Training, MCITP Trainnig

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

1Z0-417 Oracle Database Performance and Tuning Essentials 2015

Exam Number: 1Z0-417
Exam Title: Oracle Database Performance and Tuning Essentials 2015
Associated Certification Paths Oracle Database Performance and Tuning 2015 Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 82
Passing Score: 75%
Validated Against:  This exam is validated against Oracle Database 12c.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):
Oracle Database 12c: New Features for Administrators
Oracle Database: Introduction to SQL
Oracle Database: SQL Workshop I
Oracle Database: SQL and PL/SQL Fundamentals
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Oracle Database 12c: Backup and Recovery Workshop
Oracle Database 12c: Managing Multitenant Architecture

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 Study Guide (PDF)
Oracle Database 12c Implementation Specialist Guided Learning Path

Product / Solution Overview
Describe Oracle’s solution for database performance and tuning and its fit in Oracle’s strategy
Describe and summarize product history and the future public road map
Differentiate Oracle product technology for database performance within the Oracle portfolio, competitive marketplace and the opportunity available to partners.
Describe what it requires to get started with an Oracle Database Performance solution and the minimum and typical environment required

Positioning the Solution
Identify and construct probing questions that help position and match Oracle technology to database performance needs
Describe Oracle product technology that addresses the market trends and business dynamics driving the customer requirements
Describe key positioning statements for an Oracle Database Performance solution
Describe the value proposition for an Oracle Database solution and how the solution benefits and impacts a customer’s financial position (i.e. top-line and bottom-line)

Product Area Features and Functions for Technical Individuals
Describe product technologies and major capabilities that make up an Oracle Database Performance and Tuning Solution
Provide a high level overview of key hardware and software product components for an Oracle Database Performance solution
Describe key features, functions, terminology unique to Oracle’s solution including:
Oracle Performance Tuning Method , DB Time Model
Oracle Database Performance and Diagnostic Product Technology and Solution Capabilities
Oracle Enterprise Manager Database Express
Additional Database Performance functionality capability gained by using Oracle Enterprise Manager Cloud Control
Identify and map features, capabilities, and benefits to customer business needs and requirement scenarios

Architecture
Identify the type of hardware on which the solution / product runs for specific customer scenarios.
Outline the system requirements needed to architect and build an Oracle Database Performance and Tuning solution in single tenant, multitenant and non-CDB environments. Identify reference sources of architecture and best practices
Describe Oracle Product Technology architecture models that could be used for an Oracle Database Performance and Tuning solution including:
AWR, ADDM, ASH, and Database Express architecture
Real Application Testing architecture
Real User Experience Insight architecture
Oracle Application Testing architecture
Integration: Oracle Enterprise Manager Cloud Control architecture
Relate integration options and abilities available for an Oracle Database Performance solution

Solution Implementation – Installation, Configuration
Outline requirements and plan environment readiness for implementation of an Oracle Database Performance and Tuning solution
Implement Oracle Performance and Tuning product technology including installation and configuration
Test and validate that installation and configuration was successful

Performance Diagnostics and Monitoring, Best Practices
Define and apply database performance troubleshooting techniques using Oracle Database Performance and Tuning solution and Oracle Database capabilities for:
AWR, ADDM, ASH
Database Express Performance Hub
Define and apply database performance troubleshooting techniques using overall Oracle Database Performance and Tuning solution optional capabilities for:
Application, database, middleware, network, system, storage
Real User Experience Monitoring
View and modify parameters used to configure Oracle database performance using an Oracle Database Performance and Tuning solution
Define setup, and run database performance reporting using an Oracle Database Performance and Tuning solution
Automate database performance reporting using an Oracle Database Performance and Tuning solution

Performance Tuning, Best Practices
Analyze and apply database performance tuning using an Oracle Database Performance and Tuning solution capabilities including:
SQL Tuning Advisor
SQL Access Advisor
Segment Advisor and object reorganization
View and modify SQL to tune Oracle database performance using an Oracle Database Performance and Tuning solution
Define, setup, and automate SQL performance tuning using an Oracle Database Performance and Tuning solution

Performance Testing, Best Practices
Test database performance using an Oracle Database Performance and Tuning solution including:
SQL Performance Analyzer
Database Replay
Synthetic User Monitoring
Functional Testing, Load Testing and Test Management
View, test and validate Oracle database performance using an Oracle Database Performance and Tuning solution
Define, setup, and automate database performance testing using an Oracle Database Performance and Tuning solution

Use Cases, Scenarios
Identify common Oracle Database Performance and Tuning use cases for:
Monitoring performance
Performing database performance Health Checks
Maintaining database availability and Service Levels
Database Performance Diagnostics and Troubleshooting
SQL Tuning
Identify applicable Oracle Database Performance product technology for use cases
Describe implementation scenarios and options for an Oracle Database Performance solution

QUESTION 1
You need to load SQL statements from a time period of optimal performance to compare against a time period
that performance was reported as poor. Which functionality would you use to accomplish that task?

A. Optimizer Statistics Comparator
B. Dynamic Baseline Advisor
C. Automatic Workload Repository Baselines
D. SQL Tuning Sets
E. Database Replay

Answer: D

QUESTION 2
Which option would you use to capture workloads from one or more systems concurrently and then play them back?

A. Automatic Workload Repository
B. Enterprise Manager Cloud Control
C. Consolidated Database Replay
D. Consolidation Planner
E. Workload Consolidator and Playback

Answer: C

QUESTION 3
Upon migration to Oracle Database 12c, a customer asked that monitoring at an individualdatabase level be
disabled in favor of database performance monitoring consolidated and centralized across their enterprise.
Which are two actions you would take to meet the customer’s requirements?

A. Disable Oracle Enterprise Manager Database Express by setting the https: Port to 0.
B. For the always active Oracle Enterprise Manager Database Express process, create a script that will disable that process upon database boot.
C. Using the appropriate architecture implement Oracle Enterprise Manager.
D. Delete the “express” directory in Oracle Home to disable Oracle Enterprise Manager Database Express.
E. Changes permissions of the “express” directory to real only by root.
F. Enable SNMP and configure MIBS on each database and forward database monitoring SNMP traps.

Answer: B,E

QUESTION 4
What two statements are true when you are using SQL Tuning Advisor and create a SQL Profile to improve performance of a SQL statement issued by a packaged application?

A. You need to regularly run SQL Tuning Advisor to verify if the SQL Profile can be replaced with a better one.
B. After a SQL Profile is created, it will then run efficiently for the life of the database.
C. The SQL Profile rewrites the SQL Statement issued by theapplication so it appears to the Optimizer as aperfectly written SQL statement.
D. You can have only one SQL Profile active at one time for a single SQL statement.
E. You need Oracle Database 12c or later to use SQL Profiles.
F. SQL Profiles can be used for non-Oracle databases like Microsoft SQL Server, if the Tuning Pack islicensed.

Answer: A,E

QUESTION 5
Which two situations help to identify that a customer as already using Oracle Diagnostics Pack for Oracle Database functions?

A. The customer has Enterprise Manager installed on a separate server and regularly accesses the
Databasehome page of some of its Enterprise Edition databases from its console.

B. A customer says that he or she doesn’t use Enterprise Manager, but you learn that the customer
routinelyexecutesawrrpt.sqlfrom the SQLPlus prompt.

C. A customer has theCONTROL_MANAGEMENT_PACK_ACCESSinitialization parameter set
toDIAGNOSTIC +TUNING.

D. A customer says that he or she doesn’t use Enterprise Manager, but you learn that the customer has
SQLscripts that access theDBA_HIST_ACTIVE_SESS_HISTORYdatabase view.

E. A customer says that he or she doesn’t use theEnterprise Manager, but you learn that the customer
usescustomized SQL scripts that accessV$SESSIONandV$SQLviews.

Answer: C,D

 

 

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

MCTS Training, MCITP Trainnig

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

 

 

1Z0-497 Oracle Database 12c Essentials

Exam Number: 1Z0-497
Exam Title: Oracle Database 12c Essentials
Associated Certification Paths Oracle Database 12c Certified Implementation Specialist
Duration: 120 minutes
Number of Questions: 85
Passing Score: 70%
Validated Against: This exam has been validated against Oracle Database 12c.
Format: Multiple Choice

Complete Recommended Training

Complete the training below to prepare for your exam (optional):
Oracle Database 12c: New Features for Administrators
Oracle Database: Introduction to SQL
Oracle Database: SQL Workshop I
Oracle Database: SQL and PL/SQL Fundamentals
Oracle Database 12c: Admin, Install and Upgrade Accelerated
Oracle Database 12c: Backup and Recovery Workshop
Oracle Database 12c: Managing Multitenant Architecture

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 Study Guide
Oracle Database 12c Implementation Specialist

Oracle Database Software
Describe the key characteristics of a relational database
Summarize locking behavior in an Oracle database
Describe the differences between data concurrency and data consistency
Describe the various steps of a database transaction

Administration & Configuration
Design a database, identify requirements, create the logical design and physical database design
Install and configure a database
Grant Enterprise Manager administrative privileges
Use SQL*Plus and SQL Developer to access your database

Oracle Database 12c New Features
Setup a Global Database Service (GDS)
Define declarative policies for Oracle Data Redaction
Apply best practices for running the ADDM Advisor

Maximum Availability Architecture
Implement the various Data Guard configurations available
Explain the architectural differences between Data Guard and Active Data Guard
Implement the various replication options available to the Oracle database
Create an MAA architecture that leverages Active Data Guard and Oracle Golden Gate
Choose the appropriate high availability architecture based on various planned and unplanned scenarios

Backup and Recovery
Explain general best practices and guidelines for backups on the Oracle database
Implement recovery procedures for various failure scenarios
Use the Data Recovery Advisor for backup and recovery solutions

Monitoring
Use Oracle Enterprise Manager to view database storage structures
Apply different strategies for interacting with the database using SQL Developer
Describe the EM Cloud Control and EM Express architecture as it relates to the database
Manage structures used to undo changes made to the database and maintain data consistency

Administering Users and Security
Create and administer users
Grant privileges to users to perform database operations
Create and manage roles

Software Installation and Maintenance
Install the Oracle database software
Locate patches for the Oracle database
Apply best practices to patching the database
Apply troubleshooting tasks for planned database maintenance
View and modify the parameters used to configure the Oracle instance

Oracle Data Structures

Articulate the various schema objects in a relational database
Perform different index scans and relate them to index types
Leverage partitioning in an Oracle database
Use the data dictionary and the dynamic performance views
Identify the various tools for data movement and analysis

Oracle Database Instance Architecture
Define the main components of an Oracle Instance
Describe the various stages of a database instance
Articulate the various basic memory structures
Describe how a block of data is written to the database
Articulate the mandatory background processes

Oracle Multitenant Architecture
Explain the benefits of multitenant architecture for database consolidation
Create a pluggable database (PDB)
Articulate the difference between a Container database and a Pluggable database
Perform administration tasks on a container database (CDB)
Manage processes in a CDB
Manage physical and logical structures in a CDB
Describe the various storage options for a PDB

Oracle Network Architecture
Describe the differences between Shared Server and Dedicated Server architecture as it relates to Oracle Connection Manager
Describe the Oracle Database listener architecture
Configure and connect to a database service
Configure a database listener


QUESTION 1
Which statement about CDB architecture is true?

A. Oracle-supplied metadata resides only in the root container.
B. A seed PDB can sometimes be opened for particular operations.
C. Multiple PDBs with the same name can reside in the same CDB.
D. A CDB can have an infinite number of PDBs.
E. You can create common users in PDBs.

Answer: A
Reference: https:://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89235


QUESTION 2
As part of your Oracle Database 12c post-installation tasks, you run these commands:
Cd $ORACLE_HOME/bin
srvctl stop database -d myDb
chopt enable dm
srvctl start database -d myDb
What does this do?

A. It enables the Oracle Data Mining option in your Oracle binary files.
B. It creates the Fast Recovery Area disk group.
C. It generates Client Static Library.
D. It configures one of the Oracle user accounts.
E. It configures Oracle Net Services.
F. It configures Oracle Messaging Gateway.

Answer: A
Reference: https:://docs.oracle.com/cd/E16655_01/install.121/e17889/postinst.htm#RILIN1049 (see
4.4)


QUESTION 3
Exhibit below:

Which three statements are true about terminating a session?

A. Without any error, you can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSIOU ‘7, 15′;
B. You can terminate the active session by executing:
SQL> ALTER SYSTEM KILL SESSIOM “7, 15′;
But you also get the error message:
ORA-00028: your session has been killed
C. You cannot terminate the active session. You have to wait until that session becomes inactive.
D. Without any error, you can terminate the inactive session by executing:
SQL> ALTER SYSTEM KILL SESSION ’12, 63’;
E. When an inactive session is killed, the status of that session remains visible in VSSESSION
with status KILLED. The rowf the terminated session is removed from VSSESSION after the user
attempts to use the session again.
F. You cannot terminate the inactive session. You have to wait until that session becomes active
again.

Answer: D,E,F
Reference:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc008.htm#ADMIN11192


QUESTION 4
Which two statements are true about shared server sessions?

A. No Program Global Area (PGA) is allocated for shared server processes.
B. User Global Area is stored in System Global Area (SGA).
C. Shared SQL Area is allocated from Program Global Area (PGA).
D. Private SQL Area is allocated from Library Cache.
E. Large Pool is used for SQL work areas.

Answer: D
Reference: https:://docs.oracle.com/cd/B19306_01/server.102/b14220/memory.htm (see library
cache)


QUESTION 5
Which targets can be managed by using Enterprise Manager Cloud Control?

A. Hosts and databases
B. Hosts, databases, and application servers
C. Application servers and web applications
D. Databases, Oracle Management Server (OMS), and Oracle Management Repository (OMR)
E. Databases, application servers, and web applications
F. Hosts, databases, application servers, web applications, OMS, and OMR

Answer: A
Reference: https:://www.oracle.com/technetwork/oem/framework-infra/wp-em12c-security-bestpracticesv2-
1493383.pdf (page 3, second bulleted point, last couple of sentences)

 

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

MCTS Training, MCITP Trainnig

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

 

1Z0-052 Oracle Database 11g: Administration I

Exam Number: 1Z0-052
Exam Title: Oracle Database 11g: Administration I
Associated Certification Paths Oracle Database 11g Administrator Certified Associate
Duration: 90 minutes
Number of Questions: 70
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 I

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 Preparation Seminar: Oracle Database 11g Administration I
Exam Prep Seminar Package: Oracle Database Administration I

Practice Exams
Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: Oracle Database 11 g: Administration I
Sample Questions

Additional Training
Training Opportunities for Oracle Partner Network Members (available to partners only)
OPN Guided Learning Path: Oracle Database 11g Implementation Specialist (available to partners only)
Training Resources by Exam Topics (available to partners only)

Exploring the Oracle Database Architecture
Explain the Memory Structures
Describe the Process Structures
Overview of Storage Structures

Preparing the Database Environment
Identify the tools for Administering an Oracle Database
Plan an Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)

Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)

Managing the Oracle Instance
Setting database initialization parameters
Describe the stages of database startup and shutdown
Using alert log and trace files
Using data dictionary and dynamic performance views

Configuring the Oracle Network Environment
Configure and Manage the Oracle Network
Using the Oracle Shared Server architecture

Managing Database Storage Structures
Overview of tablespace and datafiles
Create and manage tablespaces
Space management in tablespaces

Administering User Security
Create and manage database user accounts
Grant and revoke privileges
Create and manage roles
Create and manage profiles

Managing Data and Concurrency
Monitor and resolve locking conflicts
Manage data using DML

Managing Undo Data
Overview of Undo
Transactions and undo data
Managing undo

Implementing Oracle Database Security
Database Security and Principle of Least Privilege
Work with Standard Database Auditing

Database Maintenance
Use and manage optimizer statistics
Use and manage Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds

Performance Management
Use Automatic Memory Management
Use Memory Advisors
Troubleshoot invalid and unusable objects

Intelligent Infrastructure Enhancements
Use the Enterprise Manager Support Workbench
Managing Patches

Backup and Recovery Concepts
Identify the types of failure that can occur in an Oracle database
Describe ways to tune instance recovery
Identify the importance of checkpoints, redo log files, and archived log files
Overview of flash recovery area
Configure ARCHIVELOG mode

Performing Database Backups
Create consistent database backups
Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area

Performing Database Recovery
Overview of Data Recovery Advisor
Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)

Moving Data
Describe and use methods to move data (Directory objects, SQL*Loader, External Tables)
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases


QUESTION 1
You notice that the performance of the database has degraded because of frequent checkpoints.
Which two actions resolve the issue? (Choose two.)

A. Disable automatic checkpoint tuning
B. Check the size of the redo log file size and increase the size if it is small
C. Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor
D. Decrease the number of redo log members if there are more than one redo log members
available in each redo log group

Answer: B,C

Explanation:


QUESTION 2
Identify the memory component from which memory may be allocated for:
Session memory for the shared server Buffers for I/O slaves Oracle Database Recovery Manager
(RMAN) backup and restore operations

A. Large Pool
B. Redo Log Buffer
C. Database Buffer Cache
D. Program Global Area (PGA)

Answer: A

Explanation:


QUESTION 3
You executed the following command to create a tablespace called SALES_DATA:
SQL> CREATE TABLESPACE sales_data
DATAFILE SIZE 100M
SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES_DATA tablespace? (Choose two)

A. The database automatically determines the extent-sizing policy for the tablespace.
B. The segments are automatically shrunk when the contents are removed from them.
C. The allocation of extents within the tablespace is managed through the dictionary tables.
D. The space utilization description of the data blocks in segments is recorded in bitmap blocks.
E. The space utilization description of the data blocks in segments is managed through free lists.

Answer: A,D

Explanation:


QUESTION 4
In which of the scenario will the DBA perform recovery? (Choose all that apply.)

A. The alert log file is corrupted
B. A tablespace is accidentally dropped
C. One of the redo log members is corrupted
D. A database user terminates the session abnormally
E. The hard disk on which the data files is stored is corrupted

Answer: B,E

Explanation:


QUESTION 5
You want to enable archiving on your database. Presently, the database is running in
NOARCHIVELOG mode.
Given below are the steps to accomplish the task in random order:
1. Shut down the instance.
2. Execute the ALTER DATABASE ARCHIVELOG command.
3. Start up the instance and mount the database.
4. Set the DB_RECOVERY_FILE_DEST initialization parameter to $ORACLE_HOME/dest_1.
5. Open the database.
Which is the correct sequence of steps for accomplishing the task?

A. 4, 1, 3, 2, 5
B. 1, 3, 4, 5, 2
C. 1, 3, 2, 5; 4 not required
D. 4, 1, 5, 2; 3 not required
E. 1, 3, 4, 5; 2 not required

Answer: C

Explanation:

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

MCTS Training, MCITP Trainnig

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

1Z0-144 Oracle Database 11g: Program with PL/SQL

Exam Number: 1Z0-144
Exam Title: Oracle Database 11g: Program with PL/SQL
Associated Certification Paths Oracle Advanced PL/SQL Developer Certified Professional (Retiring June 30th, 2018)
Oracle PL/SQL Developer Certified Associate
Duration: 90 minutes
Number of Questions: 63
Passing Score: 65%
Validated Against:  This exam has been validated against Oracle Database 10g, Oracle Database 11g, Oracle Database 11g Release 2, and Oracle Database 12c Release 1.
Format: Multiple Choice

Complete Recommended Training

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

Oracle Database: Program with PL/SQL

Certification Discount Package:Oracle PL/SQL Developer Certified Associate Certification Discount Package(ILT, LVC)

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-144-ESN on the Pearson VUE website.

Exam Preparation Seminar
Certification Exam Prep Seminar: Program with PL/SQL
Exam Prep Seminar Package: Program with PL/SQL

Practice Exams

Practice Exams: Oracle Authorized practice exam from Kaplan IT Training: 1Z0-144: Oracle Database 11g: PL/SQL Fundamentals

Additional Training: These earlier courses are still valid exam preparation tools but are no longer being scheduled:

Oracle Database 11g: Program with PL/SQL

Oracle Database 11g: PL/SQL Fundamentals
Introduction to PL/SQL
Explain the need for PL/SQL
Explain the benefits of PL/SQL
Identify the different types of PL/SQL blocks
Output messages in PL/SQL
Declaring PL/SQL Variables
Recognize valid and invalid identifiers
List the uses of variables, declare and initialize variables, use bind variables
List and describe various data types using the %TYPE attribute
Writing Executable Statements
Identify lexical units in a PL/SQL block
Use built-in SQL functions in PL/SQL and sequences in PL/SQL expressions
Describe when implicit conversions take place and when explicit conversions have to be dealt with
Write nested blocks and qualify variables with labels
Write readable code with appropriate indentation
Interacting with the Oracle Database Server
Create PL/SQL executable blocks using DML and transaction control statements
Make use of the INTO clause to hold the values returned by a SQL statement
Writing Control Structures
Identify the uses and types of control structures (IF, CASE statements and expressions)
Construct and identify loop statements
Apply guidelines when using conditional control structures
Working with Composite Data Types
Create user-defined PL/SQL records
Create a record with the %ROWTYPE attribute
Create an INDEX BY table and INDEX BY table of records
Describe the differences among records, tables, and tables of records
Using Explicit Cursors
Distinguish between usage of implicit and explicit cursors, use SQL cursor attributes
Declare and control explicit cursors, use simple loops and cursor FOR loops to fetch data
Declare and use cursors with parameters
Lock rows with the FOR UPDATE clause and reference the current row with the WHERE CURRENT OF clause
Handling Exceptions
Define PL/SQL exceptions
Recognize unhandled exceptions
Handle different types of exceptions (pre-defined exceptions, non-predefined exceptions and user-defined exceptions)
Propagate exceptions in nested blocks and call applications
Creating Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms
Create a simple procedure and invoke it from an anonymous block
Create a simple function
Create a simple function that accepts a parameter
Differentiate between procedures and functions

Oracle Database 11g: Develop PL/SQL Program Units
Creating Procedures
Differentiate between anonymous blocks and subprograms, use a modularized and layered subprogram design, and identify the benefits of subprograms
Create a simple procedure and invoke it from an anonymous block
Work with procedures
Handle exceptions in procedures, remove a procedure, and display a procedure’s information
Creating Functions
Differentiate between a procedure and a function
Describe the uses of functions
Work with functions (create, invoke and remove functions)
Creating Packages
Identify the benefits and the components of packages
Work with packages (create package specification and body, invoke package subprograms, remove a package and display package information)
Working with Packages
Overload package subprograms, use forward declarations
Create an initialization block in a package body
Manage persistent package data states for the life of a session and use PL/SQL tables and records in packages
Using Oracle-Supplied Packages in Application Development
Describe how the DBMS_OUTPUT package works
Use UTL_FILE to direct output to operating system files
Describe the main features of UTL_MAIL
Using Dynamic SQL
Describe the execution flow of SQL statements
Use Native Dynamic SQL (NDS)
Use the DBMS_SQL package
Design Considerations for PL/SQL Code
Create standard constants and exceptions
Write and call local subprograms
Control the run-time privileges of a subprogram
Perform autonomous transactions
Use NOCOPY hint, PARALLEL ENABLE hint and DETERMINISTIC clause
Use bulk binding and the RETURNING clause with DML
Creating Triggers
Describe different types of triggers and their uses
Create database triggers
Manage triggers
Creating Compound, DDL, and Event Database Triggers
Create triggers on DDL statements
Create triggers on system events
Using the PL/SQL Compiler
Describe the new PL/SQL compiler and features
Use the new PL/SQL compiler initialization parameters
Use the new PL/SQL compile time warnings
Managing PL/SQL Code
Describe and use conditional compilation
Hide PL/SQL source code using dynamic obfuscation and the Wrap utility
Managing Dependencies
Track and manage procedural dependencies

QUESTION
1
Which two statements are true about the instead of triggers? (Choose two.)

A. Delete operations cannot be performed using the instead of triggers.
B. The instead or triggers must be created to add or modify data through any view.
C. The instead of triggers can be written only for views, and the before and after timing options are not valid.
D. The check option for views is not enforced when Insertions or updates to the view are performed by using theinstead of trigger.

Answer: B,C

Explanation:


QUESTION 2
Which two statements are correct about the usage of parameters in functions? (Choose two.)

A. Functions can have only in mode parameters.
B. Functions called in SQL statements cannot have out or in outmode parameters.
C. Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
D. Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks.

Answer: B,D

Explanation:


QUESTION 3
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA.
HR is an existing schema in the database.
SCOTT creates the following trigger:
CREATE OR REPLACE TRIGGER drop_trigger
BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, ‘Cannot drop object’);
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?

A. Only HR
B. SCOTT and HR
C. Only SCOTT
D. SCOTT, HR, and SYS

Answer: A

Explanation:


QUESTION 4
Which two statements are true about the continue statement? (Choose two.)

A. The PL/SQL block execution terminates immediately.
B. The CONTINUE statement cannot appearoutside a loop.
C. The loop completes immediately and control passes to the statement after end loop.
D. The statements after the continue statement in the iteration are executed before terminating the LOOP.
E. The current iteration of the loop completes immediately and control passes to the next iteration of the loop

Answer: B,E

Explanation:


QUESTION 4
Which two statements are true about statement-level and row-level triggers? (Choose two.)

A. A row trigger fires once even if no rows are affected.
B. A statement trigger fires once even if no rows are affected.
C. Row triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.
D. Statement triggers are useful if the trigger action depends on the data of rows that are affected or on data that is provided by the triggering event itself.

Answer: B,C

Explanation:

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

MCTS Training, MCITP Trainnig

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

12COCMU Oracle Database 12c Certified Master Upgrade Exam

Exam Number: 12COCMU
Exam Title: Oracle Database 12c Certified Master Upgrade Exam
Associated Certification Paths Oracle Database 12c Administrator Certified Master (upgrade)
Duration: 1 day
Number of Questions: N/A
Passing Score: 59.17%
View passing score policy
Validated Against:

This exam has been validated against Oracle Database 12c Enterprise Edition Release 12.1.0.2.0.

Format: Performance Based
Complete Recommended Training

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

Oracle Database 12c: New Features for Administrators
Oracle Database 12c: Data Guard Administration
Oracle Database 12c: High Availability New Features
Oracle Database 12c: ASM Administration
Oracle Database 12c: Clusterware Administration
Oracle Database 12c: RAC Administration

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 Delivery

The OCM is offered in English, regardless of exam location (except in Japan, it is offered only in Japanese).
Exam Retake Policy
Exam Cancellation Policy: Oracle Certified Master Exams are offered through Oracle University and are governed by the Oracle University Legal Terms & Policies.
You are not allowed to use your own keyboard. We recommend you practice on the type of keyboard you expect to find in OCM Test Center.
All countries, except those listed will use country-specific keyboards
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.

Preparation

Review the OCM exam objectives to evaluate where you will need additional training and preparation.
Update your training with Oracle University’s advanced Database Administrator curriculum.
Refer to the Oracle Database12c documentation library available from the Oracle Technology Network
Practice in a representative environment (practice environment does not need to be on the exact OS and database software versions used in the OCM exam – see below). You can download Oracle products from the Oracle Technology Network. Use Oracle Linux operating system.
To prepare for the OCM exam, candidates should focus on mastering the tasks for each Skillset. Software can be downloaded from the Oracle Technology Network (OTN) to build a practice environment. Use the latest software available from OTN; it is not necessary to build a practice environment on the exact OS and database software versions used in the OCM exam. Later releases of Oracle server support nearly all features and functions of earlier ones; for any software version, relevant parameter values, naming differences and obsolete features may be found in the product documentation, which is available from OTN.
It is also recommended that candidates practice on the type of keyboard that they expect to find in OCM Test Center. All countries, except those listed will use country-specific keyboards:
United States, Canada, United Kingdom, Netherlands, Greece, Croatia, Italy, Poland, Romania, Slovak Republic, Egypt, Israel, United Arab Emirates, Saudi Arabia, South Africa, Hong Kong, Indonesia, India, Malaysia, Philippines, Singapore, Thailand, Vietnam, Australia, New Zealand.

Exam Environment

Oracle Linux Release 6.5 64 bit
Mozilla Browser, Text (emacs, gedit) and vi editors
Shell environment: bash, csh
Use either CLI or GUI environment and tools when available
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 64 bit
Oracle Grid Infrastructure 12c Release 1 (12.1.0.2)
Oracle Enterprise Manager Cloud Control 12c Rel 4

Notes about t he exam

Exam participants work through four skillsets that are based on the exam objectives.
Tasks can be performed using CLI or GUI environment and tools when available

Minimum Skill-set wise Passing Scores:

Skillset1 : General Database and Network Administration, and Backup Strategy : 55.56%
Skillset2: Data and Performance Management : 31.74%
Skillset3: Data Guard : 43.39%
Skillset4: Grid Infrastructure and RAC : 44.28%

General Database and Network Administration, and Backup Strategy

Create and manage pluggable databases
Create and manage users, roles, and privileges
Configure the network environment to allow connections to multiple databases
Protect the database from loss of data due to any kind of failure
Create and manage database configuration files

Data and Performance Management

Modify materialized views
Create a plugged-in tablespace by using the transportable tablespace feature
Create partitioned tables
Configure the database to retrieve all previous versions of the table rows
Configure the Resource Manager
Tune SQL statements
Perform real application testing
Create SQL Plan baselines

Data Guard

Create a physical standby database
Make the standby database available for testing
Restore the standby database to its normal function
Configure fast start failover

Grid Infrastructure and Real Application Clusters

Install Oracle Grid Infrastructure
Configure Oracle Flex ASM
Create ASM disk groups
Create and manage an ASM instance
Create ACFS
Start, stop, configure, and administer Oracle Grid Infrastructure
Install the Oracle Database 12c software
Create RAC databases
Configure services

Click here to view complete Q&A of 12COCMU exam
Certkingdom Review
, Certkingdom PDF Torrents

MCTS Training, MCITP Trainnig

Best Oracle 12COCMU Certification, Oracle 12COCMU Training at certkingdom.com

Best Online MCITP Training and Learning blog