We share the latest exam dumps throughout the year to help you improve your skills and experience! The latest Oracle Database 1Z0-060 exam dumps, online exam Practice test to test your strength, Oracle 1Z0-060 “Oracle Database 12c Administrator Certified Professional(upgrade)” in https://www.geekcert.com/1z0-060.html Update the exam content throughout the year to ensure that all exam content is authentic and valid. 1Z0-060 PDF Online download for easy learning.
[PDF] Free Oracle Database 1Z0-060 pdf dumps download from Google Drive: https://drive.google.com/open?id=1vEGzoBKjFNXljPLuvJOwmAYwHNAZx7Qu
[PDF] Free Full Oracle pdf dumps download from Google Drive: https://drive.google.com/open?id=1MbUFUh0mnBLBvtc6SBd-ok4XLwRcYaqD
Upgrade to Oracle Database 12c | Oracle University: https://education.oracle.com/upgrade-to-oracle-database-12c/pexam_1Z0-060
Free test Oracle Database 1Z0-060 Exam questions and Answers
QUESTION 1
Examine the memory-related parameters of an Oracle database instance:
Which statement is true?
A. The value of the memory_target parameter cannot be changed dynamically.
B. PGA size can grow automatically beyond 500 MB.
C. Only the components of SGA are managed automatically.
D. Memory is dynamically re-allocated between SGA and PGA as needed.
Correct Answer: B
QUESTION 2
An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is
inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak
hours. The following are the parameter settings for the database instance:
You want to balance the memory between the System Global Area (SGA) components depending on the workload.
Which option would solve this problem?
A. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M
B. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
C. setting the SGA_TARGET parameter to 300M
D. setting the SGA_MAX_SIZE parameter to 400M
Correct Answer: C
QUESTION 3
Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)
A. All administration tasks must be done to a specific pluggable database.
B. The pluggable databases increase patching time.
C. The pluggable databases reduce administration effort.
D. The pluggable databases are patched together.
E. Pluggable databases are only used for database consolidation.
Correct Answer: CE
The benefits of Oracle Multitenant are brought by implementing a pure deployment choice. The following list calls out
the most compelling examples.
*
High consolidation density. (E)
The many pluggable databases in a single multitenant container database share its memory and background
processes, letting you operate many more pluggable databases on a particular platform than you can single databases
that use the old architecture. This is the same benefit that schema-based consolidation brings.
*
Rapid provisioning and cloning using SQL.
*
New paradigms for rapid patching and upgrades. (D, not B)
The investment of time and effort to patch one multitenant container database results in patching all of its many
pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database
at a different Oracle Database software version.
*
(C, not A) Manage many databases as one.
By consolidating existing databases as pluggable databases, administrators can manage many databases as one. For
example, tasks like backup and disaster recovery are performed at the multitenant container database level.
*
Dynamic between pluggable database resource management. In Oracle Database 12c, Resource Manager is extended
with specific functionality to control the competition for resources between the pluggable databases within a multitenant
container database.
Note:
*
Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by
simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a
multitenant container database to hold many pluggable databases. And it fully complements other options, including
Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no
change, as a pluggable database; and no changes are needed in the other tiers of the application.
QUESTION 4
Which two statements are true about Oracle Direct Network File System (NFS)? (Choose two.)
A. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.
B. It utilizes the operating system file system cache.
C. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the
Direct NFS client.
D. The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed
through the operating system kernel NFS.
E. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O
commands over any remaining paths.
Correct Answer: CE
QUESTION 5
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
A. Oracle Data Pump
B. Oracle Recovery Manager (RMAN)
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Real Application Security
Correct Answer: B
QUESTION 6
You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
RANDOM redaction on the SAL and COMM columns PARTIAL redaction on the HIREDATE column FULL redaction on
the MGR column
What would you define to implement this?
A. several redaction policies, with one redaction policy for each data type defined for the table that must be redacted
B. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type
C. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted
D. several redaction policies, with one redaction policy for each table column that must be redacted
Correct Answer: C
You can redact columns of different data types, using different redaction types, for one table or view.
QUESTION 7
Which three statements are true about tablespaces in a multitenant container database (CDB)? (Choose three.)
A. All PDBs and CDBs have their own UNDO tablespaces.
B. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces.
C. Each pluggable database (PDB) can have a temporary tablespace or a tablespace group.
D. CDBs and PDBs may share the same temporary tablespace that is present in the root container.
E. There can be only one temporary tablespace group in a CDB.
Correct Answer: CDE
QUESTION 8
Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of
which use the CDB tablespace. The temp file is called temp01.tmp.
A user issues a query on a table on one of the PDBs and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file `/u01/app/oracle/oradata/CDB1/temp01.tmp\\’ ORA-27037: unable to obtain file
status
Identify two ways to rectify the error.
A. Add a new temp file to the temporary tablespace and drop the temp file that that produced the error.
B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.
C. Take the temporary tablespace offline, recover the missing temp file by applying redo logs, and then bring the
temporary tablespace online.
D. Shutdown the database instance, restore and recover the temp file from the backup, and then open the database
with RESETLOGS.
E. Shut down the database instance and then restart the CDB and PDBs.
Correct Answer: AE
*
Because temp files cannot be backed up and because no redo is ever generated for them, RMAN never restores or
recovers temp files. RMAN does track the names of temp files, but only so that it can automatically re-create them when
needed.
*
If you use RMAN in a Data Guard environment, then RMAN transparently converts primary control files to standby
control files and vice versa. RMAN automatically updates file names for data files, online redo logs, standby redo logs,
and temp files when you issue RESTORE and RECOVER.
QUESTION 9
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle
database 12c?
A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION
Correct Answer: CE
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION This feature enables global index
maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index
unusable.
Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to
off- peak time.
Reference: Oracle Database VLDB and Partitioning Guide 12c
QUESTION 10
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries
that span multiple partitions.
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still
perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a
segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result? (Choose three.)
A. Using a partial local index on the warehouse fact table month column with indexing disabled for the table partitions
that return most of their rows to the queries.
B. Using a partial local index on the warehouse fact table month column with indexing disabled for the table partitions
that return a few rows to the queries.
C. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains
the existing local partitioned column.
D. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which
retains the existing local partitioned column.
E. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions
that return most of their rows to the queries.
F. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions
that return a few rows to the queries.
Correct Answer: ACE
QUESTION 11
You must track all transactions that modify certain tables in the SALES schema for at least three years.
Automatic undo management is enabled for the database with a retention of one day.
Which two must you do to track the transactions? (Choose two.)
A. Enable supplemental logging for the database.
B. Specify undo retention guarantee for the database.
C. Create a Flashback Data Archive in the tablespace where the tables are stored.
D. Create a Flashback Data Archive in any suitable tablespace.
E. Enable Flashback Data Archiving for the tables that require tracking.
Correct Answer: DE
E: By default, flashback archiving is disabled for any table. You can enable flashback archiving for a table if you have
the FLASHBACK ARCHIVE object privilege on the Flashback Data Archive that you want to use for that table.
D: Creating a Flashback Data Archive
/ Create a Flashback Data Archive with the CREATE FLASHBACK ARCHIVE statement, specifying the following:
Name of the Flashback Data Archive Name of the first tablespace of the Flashback Data Archive (Optional) Maximum
amount of space that the Flashback Data Archive can use in the first tablespace / Create a Flashback Data Archive
named fla2 that uses tablespace tbs2, whose data will be retained for two years: CREATE FLASHBACK ARCHIVE fla2
TABLESPACE tbs2 RETENTION 2 YEAR;
QUESTION 12
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to
users:
1.
Create a policy to capture the privilege used by a user for privilege analysis.
2.
Generate a report with the data captured for a specified privilege capture.
3.
Start analyzing the data captured by the policy.
4.
Revoke the unused privileges.
5.
Compare the used and unused privileges\\’ lists.
6.
Stop analyzing the data.
Identify the correct sequence of steps.
A. 1, 3, 5, 6, 2, 4
B. 1, 3, 6, 2, 5, 4
C. 1, 3, 2, 5, 6, 4
D. 1, 3, 2, 5, 6, 4
E. 1, 3, 5, 2, 6, 4
Correct Answer: B
1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges\\’ lists.
4. Revoke the unused privileges.
QUESTION 13
Which three statements are true about RMAN compressed backups?(Choose three.)
A. Media manager compression should not be enabled if compressed backups are being written to tape.
B. Compressed backups can be written to media only if using proxy copies.
C. File system compression should be enabled if compressed backups are being written to disk.
D. Compression creates some performance overhead during backups to tape.
E. Compression creates some performance overhead during backups to disk.
Correct Answer: BCE
We share 13 of the latest Oracle Database 1Z0-060 exam dumps and 1Z0-060 pdf online download for free. Now you know what you’re capable of! If you’re just interested in this, please keep an eye on “Micvce.com” blog updates! If you want to get the Oracle Database 1Z0-060 Exam Certificate: https://www.geekcert.com/1z0-060.html (Total questions:191 Q&A).
Related 1Z0-060 Exam Resources
| title | youtube | Upgrade to Oracle Database 12c | Oracle University | lead4pass | |
|---|---|---|---|---|
| cisco 1Z0-060 | lead4pass 1Z0-060 dumps pdf | lead4pass 1Z0-060 youtube | Upgrade to Oracle Database 12c | Oracle University | https://www.geekcert.com/1z0-060.html |
| Oracle Database | https://www.geekcert.com/1z0-061.html | |||
| https://www.geekcert.com/1z0-062.html | ||||
| https://www.geekcert.com/1z0-063.html | ||||
| https://www.geekcert.com/1z0-064.html | ||||
| https://www.geekcert.com/1z0-066.html | ||||
| https://www.geekcert.com/1z0-067.html | ||||
| https://www.geekcert.com/1z0-068.html | ||||
| https://www.geekcert.com/1z0-071.html |
Lead4pass Promo Code 12% Off
Why Choose Lead4pass?
Geekcert helps you pass the exam easily! We compare data from all websites in the network, other sites are expensive,and the data is not up to date, Lead4pass updates data throughout the year. The pass rate of the exam is above 96%.
