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:
https://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

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