Oracle 1Z0-060 Question Answer

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 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

Answer: B

Oracle 1Z0-060 Question Answer

You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

A. Enable Memory Access Mode, which reads performance data from SGA.
B. Use emergency monitoring to fetch data directly from SGA analysis.
C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
E. Run ADDM in diagnostic mode.

Answer: B


You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
D. Database files stored in ZFS and accessed using conventional NFS mounts.
E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Answer: AEG

Oracle 1Z0-060 Question Answer

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.

Answer: AE


Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
C. All the components may be moved into SYSAUX tablespace.
D. All the components may be moved from the SYSAUX tablespace.

Answer: AB

Pass4sure 1Z0-060 Question Answer

Which three are true about the large pool for an Oracle database instance that supports shared server connections?

A. Allocates memory for RMAN backup and restore operations
B. Allocates memory for shared and private SQL areas
C. Contains a cursor area for storing runtime information about cursors
D. Contains stack space
E. Contains a hash area performing hash joins of tables

Answer: ABC


What are three purposes of the RMAN “FROM” clause?

A. to support PUSH-based active database duplication
B. to support synchronization of a standby database with the primary database in a Data environment
C. To support PULL-based active database duplication
D. To support file restores over the network in a Data Guard environment
E. To support file recovery over the network in a Data Guard environment

Answer: BCE

Apple Chipmaker Downgraded; Oracle Upgraded; Seagate Gets Target Hikes

Oracle (ORCL), Fitbit (FIT), Seagate Technology (STX), Ulta Beauty (ULTA) and Apple (AAPL) supplier Taiwan Semiconductor (TSM) are Tuesday highlights, thanks to a changes in analyst opinion.

BMO Capital Markets upgraded the Silicon Valley giant to outperform from market perform and raised its price target to 47 from 45.

Shares were up 1.6% Tuesday on the stock market today.

Taiwan Semiconductor

The Apple supplier was handed a downgrade to neutral from overweight from JPMorgan. Shares dipped 0.85% to 26.97, still above a 26.68 buy point..

In other iPhone chipmaker news, Intel (INTC) might eventually bump off Qualcomm (QCOM) as an iPhone supplier, according to Cowen, which sees Intel grabbing more than half of Apple's iPhone 7 modem business.

Fitbit

Wells Fargo initiated the fitness tracker maker with a market perform rating. Shares dropped 1.2% to 13.51.

Fitbit was recently named Morgan Stanley's top consumer electronics pick, with analysts from the bank seeing a "strong" holiday season ahead.

Seagate Technology

Shares leapt 21.8% tp 29.35 Tuesday after the hard drive makerannounced preliminary fourth-quarter results and increased revenue guidance for the quarter late Monday.

Needham raised its price target to 33 from 31, and Maxim Group boosted its price target to 35 from 25. Needham rates Seagate a buy; Maxim has a hold on the company.

Seagate also announced about 6,500 job cuts -- 14% of its global workforce -- by the end of fiscal 2017. Rival Western Digital (WDC) was up 4.8% on the news. Western Digital has been climbing since preannouncing its earnings outlook last week.
Ulta Beauty

Stifel resumed coverage of the specialty beauty retailer with a hold rating; shares were up 0.4% to 253.25, hitting a fresh high.
Ulta continues to be a high scorer in IBD's ratings, earning a 99 Composite Rating.

Team New Zealand skipper Glenn Ashby makes cheeky dig at Oracle rival Jimmy Spithill

Team New Zealand captain Glenn Ashby has made another excavation cheerful Oracle Team USA Jimmy Spithill counterpart.

The couple was appearing at the press conference for the final round of the World Cup series America in Chicago and when fellow Australian Spithill was presented as "local hero Oracle Team USA," Ashby not he could help it.

When asked what he regarded as the toughest opposition of the New Zealand team, Ashby said: "Team GBR and AUS ... Team USA, I'm sorry you put the letters confused sometimes."

Spithill isn't the only Australian in Oracle with seven of the 14 crew hailing from across the Tasman, while two others have dual heritage, according to the team's website.

The pattern of Oracle took the jibe in good heart, although it seeks to achieve Ashby back in the water with the New Zealand team with a two-point lead at the top of the standings ahead at the end of week.

The pair know each other well have been successful part of the challenge of the America's Cup Oracle against Alinghi in 2010, with tutoring Ashby Spithill in multihull racing.

Last year, Ashby Spithill gave a not so subtle reminder of the fraud scandal that enveloped Oracle Team USA before the last America's Cup.

Americans were convicted of using illegal weighing in kingposts catamarans 45 feet used in the World Series and Ashby Spithill has a legal burden post as a reminder in Portsmouth.

Pass4sure 1Z0-060 Question Answer

In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

A. The partitions can be moved online to new tablespaces.
B. Global indexes must be rebuilt manually after moving the partitions.
C. The partitions can be compressed in the same tablespaces.
D. The partitions can be compressed in the new tablespaces.
E. Local indexes must be rebuilt manually after moving the partitions.

Answer: ABD