Vendor: Oracle
Exam Code: 1Z0-497
Exam Name: Oracle Database 12c Essentials
QUESTION 1
Which three statements represent the benefits of multitenant architecture for database consolidation?
A. You can unplug a PDB from a development CDB and plug it into a production CDB, which allows for easier and more rapid movement of data and code.
B. You can consolidate shared database memory by combining multiple PDBs in a single CDB.
C. Patching individual PDBs requires the same amount of time as patching individual databases.
D. Consolidating separate databases into a single CDB requires the same amount of storage allocation.
E. In multitenant architecture, a PDB behaves the same as a non-CDB as seen from a client connecting
with Oracle Net. No client modification is required.
Answer: E
Explanation:
http://docs.oracle.com/cd/E16655_01/server.121/e17633/cdbovrvw.htm#CNCPT89239
QUESTION 2
Which statement about the Oracle Advanced Security Data Redaction feature is true?
A. It transparently encrypts data at rest in Oracle databases.
B. It securely manages encryption keys.
C. It protects against theft or loss of disks and backups.
D. It prevents OS users from inspecting tablespace files.
E. It limits the exposure of sensitive data in applications.
F. It alters data in caches, buffers, and persistent storage.
G. It impacts operational activities such as backup & restore, upgrade & patch, and replication.
Answer: ABC
Explanation:
http://www.oracle.com/technetwork/database/options/advanced-security/advanced-
security-ds-12c-1898873.pdf
QUESTION 3
Which three statements about Automatic Database Diagnostic Monitor (ADDM) are true?
A. It requires the database to be open.
B. It analyzes the performance of specified objects.
C. It implements all recommendations automatically.
D. It recommends solutions and quantifies expected benefits.
E. It retains snapshots in the SYSAUX tablespace until the database is restarted.
F. It analyzes the snapshots stored in the Automatic Workload Repository (AWR).
Answer: BDF
Explanation:
http://docs.oracle.com/cd/B19306_01/server.102/b14211/diagnsis.htm
QUESTION 4
Which is the default port number for Database Express?
A. 7801
B. 5500
C. 2243
D. 1521
E. 22
Answer: D
Explanation:
http://docs.oracle.com/cd/B25329_01/doc/install.102/b25143.pdf (page 4, first bulleted point)
QUESTION 5
Your customer is looking for a solution to address these downtime needs:
– Online addition and removal of disks should automatically rebalance data across new storage configurations while storage, database, and applications remain online.
– Dynamically add or remove clustered nodes without disrupting the database or applications.
– Automate the sizing and distribution of shared memory.
– Add a column with a default value without disrupting the database or applications.
– Perform rolling patch upgrades.
Which four would you recommend to address those needs?
A. Automatic Storage Management (ASM)
B. Online Data and Application change
C. Global Data Services (GDS)
D. Real Application Clusters (RAC)
E. Oracle Streams
F. Online Table Redefinition
G. Oracle Database Vault
Answer: ACDE
QUESTION 6
Your database instance is down because there was a user-initiated shutdown. Which option represents the actions performed, in the correct order, if you start up the instance?
a – The control file is read.
b – Memory is allocated.
c – Background processes pre started.
d -The initialization parameter file is read,
e- Redo log files and data files are opened.
A. b, c, a
B. d, a, e
C. a, e, d, b
D. d, b, c, a, e
E. c, b, d, a, e
Answer: E
QUESTION 7
Which three components are always part of System Global Area?
A. Database Buffer Cache
B. Undo Log Buffer
C. Shared Pool
D. Small Pool
E. Java Pool
F. Private SQL Area
Answer: ACE
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT802
QUESTION 8
Which two statements about Database Express are true?
A. It uses internal infrastructure components, such as XDB and SQL*Net.
B. It can perform actions outside the database.
C. It has background tasks and processes that periodically collect information via FTP.
D. It has two new features: Performance Hub and Composite Active Reports.
E. It is not supported on Standard Edition (SE) and Express Edition (XE).
Answer: AD
Explanation:
http://www.oracle.com/technetwork/database/manageability/emx-intro-1970113.html
QUESTION 9
Which three operations can the PUBLIC user with the SYSOPER privilege perform?
A. STARTUP
B. SHUTDOWN
C. CREATE DATABASE
D. DROP DATABASE
E. ALTER DATABASE RECOVER
Answer: ABE
Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28310/dba006.htm#ADMIN11049
QUESTION 10
To revoke unnecessary and unused privileges, you can use Privilege Analysis. Which sequence should you follow?
1 -Start the analysis.
2 – Set up the analysis policy type (database, role, context).
3 – Generate the results.
4 -View the results in DBA_USED_PRIVSand DBA_UNUSED_PRJVS.
5 – Stop the analysis.
A. 1, 2, 3, 4, 5
B. 2, 1, 5, 3, 4
C. 5, 1, 2, 3, 4
D. 2, 3, I, 5, 4
E. 1, 2, 4, 5, 2
Answer: A
QUESTION 11
Which command do you use to create a local role while you are connected as the local user?
A. create local role l_hr;
B. create role c##_hr container=current;
C. create role l_hr container=current;
D. create role l_hr container=all;
Answer: D
QUESTION 12
YOU want to move all objects of the CONSULTANT user from the test database to theDB-USER schema of the production database. Which option of IMPDP would you use to accomplish this task?
A. FULL
B. SCHEMAS
C. TRANSFORM
D. REMAP_SCHEMA
E. REMAP_TABLESPACE
Answer: D
QUESTION 13
For which database operation do you need the database to be in MOUNT state?
A. renaming the control files
B. re-creating the control files
C. dropping a user in your database
D. dropping a tablespace in your database
E. configuring the database instance to operate in ARCHIVELOG or NOARCHIVELOG mode
Answer: D
If you want to pass Oracle 1Z0-497 successfully, donot missing to read latest lead2pass Oracle 1Z0-497 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
