Oracle 1Z0-060 Questions Answers

Which statement is true concerning dropping a pluggable database (PDB)?

A. The PDB must be open in read-only mode.
B. The PDB must be in mount state.
C. The PDB must be unplugged.
D. The PDB data files are always removed from disk.
E. A dropped PDB can never be plugged back into a multitenant container database (CDB).

Answer: B



You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

A. Compare Period ADDM report
B. AWR Compare Period report
C. Active Session History (ASH) report
D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: A

http://www.oraclecertificationprep.com/apex/f?p=OCPSG:EXAM_DETAILS:::NO::P2_EXAM:1Z0-060

https://www.dumpspedia.info/1z0-060-questions-dumps.html

Oracle 1Z0-060 Questions Answers

Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table's indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?

A. Oracle Data Pump.
B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
D. Online Table Redefinition.
E. Edition-Based Table Redefinition.

Answer: D



What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

A. Effectively implements role separation
B. Enables you to take advantage of Oracle Managed Files.
C. Automatically registers the database with Oracle Restart.
D. Helps you to easily upgrade the database from a prior release.
E. Enables the Installation of Grid Infrastructure files on block or raw devices.

Answer: CE

Oracle 1Z0-060 Questions Answers

You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:

SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;

For which database users is the audit policy now active?

A. All users except SYS
B. All users except SCOTT
C. All users except sys and SCOTT
D. All users except sys, system, and SCOTT

Answer: B


On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:

$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.
B. It fails because no SQL *Loader data file location is specified.
C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.
D. It fails because no SQL *Loader control file location is specified.

Answer: AC

Oracle 1Z0-060 Question Answer

Examine this command:

SQL > exec DBMS_STATS.SET_TABLE_PREFS (`SH', `CUSTOMERS', `PUBLISH', `false');

Which three statements are true about the effect of this command?

A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Answer: CDE                                                  1Z0-060 Braindumps

Which two are true concerning a multitenant container database with three pluggable database?

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.

Answer: CE

Hubris, Thy Name Is Oracle: So, Cloud Is Still Totally For Nerds, Right?

Comment If Larry Ellison earned a dollar for every phrase advertised in the cloud he made, Oracle's market share in cloud infrastructure would not be the measly 0.3 percent, according to Gartner's calculations, of what it is today.

Big Red has spent years playing simulation with the cloud, trying to convince the world that it could simultaneously invest little in the data centers while getting the maximum benefit. Oracle is finally learning what it must invest to collect its ambitions in the cloud.

As such, the company recently announced that it will build 12 new data centers, despite claiming it did not need more because its databases and computers are much faster than those of AWS or Microsoft Azure. Even with this loosening of the stock markets, it is not clear whether Oracle has a good chance of closing the gap with its tougher competitors.
Pot, meet kettle

Oracle has become a caricature rather than a competitor, regularly throwing sparks in such a way that his executive suite looks silly at best. In 2009, as an excuse to start to fall behind Amazon Web Services, the then CEO Ellison ranted: "Everyone looks around and says, 'Yah, as if everything were in the cloud.' My objection is that it is absurd, it's nonsense ... What are you talking about? It's not water vapor, it's a computer connected to a network! "

And, of course, no one was better than Oracle in computers connected to networks.

The problem is that, in fact, "cloud" is neither "water vapor" nor as simple as connecting a few computers to a network. Oracle's unwillingness to take the trend seriously (along with IBM colleagues and elsewhere) led AWS CEO Andy Jassy to say in 2017: "I do not think that in our best dreams we thought we would have an advantage of six to seven years. "But they did, and Ellison's arrogance played an important role in guaranteeing that.

Even though Oracle hardened the future, its core licensing business was in terminal decline. As noted by Redmonk analyst Stephen O'Grady in 2013, Oracle has had increasing difficulty selling software to anyone, except those who are already buying. Even its cloud strategy has focused on a relatively small niche: existing customers looking to eliminate applications from the data center and move them to the cloud.

Unsurprisingly, in its last quarter, Oracle's new license revenue was reduced, even as its SaaS business grew 55 percent to $ 1.1bn and its total PaaS business (which includes IaaS) rose by only 21 percent. at $ 396m. This cloud business is growing faster than the decreases in its legacy business, but not fast enough to keep pace with market leaders AWS, Microsoft and Google.
If you build it, will they come?

Clearly, Oracle's strategy did not work. That strategy, in part, inexplicably has depended on the company managing to save its way to the glory of the cloud. Even when AWS, Microsoft and Google obtained $ 41.6bn in data center constructions last year, 33 percent more than the previous year, to bring their collective total to hundreds of data centers, Oracle had difficulty announcing just three data centers. in 2017, spending a little more than $ 2bn.

Even then, Oracle wanted the world to think that all this was by design. CEO Mark Hurd tried to explain Oracle's insignificant investments in data centers: "If I have computers twice as fast, I do not need as many data centers, if I can speed up the database, I may need a quarter of data." . "The reason for Oracle's parsimonious approach was simply that it is the best in everything, it does not matter that in spite of everything its boast of having a" personalized "infrastructure, so do all the others. that AWS, Microsoft and Google have much more scale and experience with the customized creation of their hardware and software, Oracle is a neophyte.
Keeping up with the cloudy Jones

Can Oracle catch up? That is hard to imagine. While the company can (and should) dramatically expand the footprint of its data center to even be credible, it is difficult to see how it can catch market leaders. Leaving brute capacity aside, even Microsoft Azure, a distant second in AWS market share, has had trouble adding features and services to the pace of AWS. Oracle is not even in the same universe as AWS when it comes to cloud services, but it can not enter the same zip code as Azure or Google Cloud. Once again, the database giant hopes to attract existing customers with offers such as automation in "almost all" of its services, but it has yet to prove that it can compete hand-in-hand with cloud heavyweights.

But Oracle not only relies on sizzling to sell this product: it has been honing the sales machine, hiring sales and engineering personnel from more experienced rivals while greatly increasing bonuses and changing structures to achieve renewals. License experts report that Oracle customers are offered the cloud as a means to reduce the bill of any license breach problem.

No wonder, then, that Deutsche Bank Securities Inc analyst Karl Keirstead has declared that "the game" has been "finished" for Oracle in the IaaS market.

Nor does the strength of Oracle's previously impregnable databases seem so secure these days. Modern data is much more similar to Amazon DynamoDB or Microsoft Azure CosmosDB than to the ordered and zeros of the relational databases of yesteryear. Oracle, unlike AWS, Microsoft and Google, has no experience in the development of large-scale next-generation cloud applications, so you will always have difficulty building a modern data infrastructure.

As such, Amazon has helped migrate 50,000 instances of databases to AWS, most of them from Oracle, as AWS CEO Andy Jassy proclaimed. The pace of these migrations seems to accelerate to approximately 5,000 per month. As Gartner analyst Merv Adrian told me, in an interview, Oracle has lost market share of database every year for the past four years. While the company still holds 40 percent of the market, its absolute dominance is no longer guaranteed.

Is there any positive news for Oracle? Of course. While Oracle is a rounding error in IaaS and can get a 2% market share in PaaS, it can claim a more respectable fourth SaaS with a market share of 5.6%. Ellison can boast that Oracle is "completely transforming the way all companies buy and use the cloud by offering flexibility and options," but the best thing to say is that it is still relevant in SaaS. It is a big market and a big business.

Meanwhile, Oracle is experimenting with the cloud market because it is funded by a massive base of installed companies that pay for maintenance in all instances of old databases. A recent survey from Rimini Street indicated that up to 74 percent of those customers run the legacy database without support, however they pay anyway. It is a high margin revenue that Oracle can use to fund their cloud aspirations.

Twelve more data centers are a way to spend that cash. It will be enough? No. But it can only give Oracle the ability to convince more of its customer base to give it an opportunity with its cloud-based applications. That will be worth a few billion dollars a year, even if the competition counts in tens of billions now (AWS) or in the not too distant future (Microsoft and Google).

Oracle 1Z0-060 Question Answer

Your database supports a DSS workload that involves the execution of complex queries:
Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
B. Run the Automatic Workload Repository Monitor (ADDM).
C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

Answer: D


In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you find that buffer busy waits is caused by contention on data blocks. Which option would you consider first to decrease the wait event immediately?

A. Decreasing PCTUSED
B. Decreasing PCTFREE
C. Increasing the number of DBWN process
D. Using Automatic Segment Space Management (ASSM)
E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Answer: D

Oracle 1Z0-060 Question Answer

Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?

A. None of the data definition language (DDL) statements are logged in the trace file.
B. Only DDL commands that resulted in errors are logged in the alert log file.
C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
D. Only DDL commands that resulted in the creation of new database files are logged.

Answer: A


A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

A. Execute the query and view Active Session History (ASH) for information about the query.
B. Enable SQL trace for the query.
C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.
D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

Answer: C

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

Oracle's attorney tried to get Eric Schmidt to admit that Google was creepy

Oracle and Google are back in court this week to determine if Google owes Oracle billions of dollars (or any dollars) over how it built Android.

And the first star witness was Eric Schmidt, the executive chairman of Google's Alphabet parent company.

He's a good one to start with. He was an exec at Sun Microsystems, the company that Oracle bought in 2010 that led to this trial.

Schmidt was at Sun when Sun developed the Java operating system and all the assorted programming paraphernalia that Oracle and Google are currently arguing over. So he's familiar with that part of things.

And, of course, he was famously CEO of Google when Google created Android. Schmidt had to give up his seat on Apple's board of directors because Android competed with the iPhone, and Steve Jobs was so angry about what he saw as Schmidt's betrayal that he threatened to go "thermonuclear" over Android, so the story goes.

In court on Tuesday, Oracle's attorney, Peter Bicks, was trying to get Schmidt to acknowledge that using a part of the Java programming language in Android without paying for it was wrong. The dispute centers around Java's application programming interfaces, or APIs, which allow two apps to talk to each other and share data.

Do you know Henrique?
The two companies have been embroiled in a legal battle over the issue for six years, with a previous trial in 2012 that led to a judge's ruling that Google did not infringe on Oracle's APIs. Oracle won an appeal, and the two sides are now back in court again.  Google argues that its use of Java APIs should be free, covered under the "fair use" provision.

As for the testimony, according to several transcripts reported from the trial, it sounds like Schmidt bested Oracle's lawyer on multiple occassions.

For instance, there was a bit where Bicks asked Schmidt if he recognized the name Henrique de Castro, the well-known executive who ran Google's mobile business while Schmidt was CEO.

Schmidt kept telling the lawyer that he did not recognize the name. And when Schmidt finally did say he recognized it, he told the lawyer that he had been pronouncing the it wrong. Touché.

The lawyer also asked questions to get Schmidt to admit that Google makes a lot of money on Android, which seemed to work. This will later serve to bolster Oracle's claim that Google owes Oracle billions of dollars.

And finally, Bicks asked Schmidt to talk about one more controversial public statements. "Google policy is to get right up to the creepy line but not cross it."

But that line of questioning was cut off by US District Judge William Alsup, who would not let the testimony continue past the 1 p.m. cutoff.

Alsup promised the jury that the day would end at 1 p.m. and that means, Schmidt is expected to be back in court tomorrow to finish answering Bick's questions.

Pass4sure 1Z0-060 Question Answer

Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved parallel Execution performance
D. Improved Serial Execution performance
E. Reduced physical I/O
F. Reduced CPU utilization

Answer: C

Pass4sure 1Z0-060 Question Answer

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

Answer: E

Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container. The steps to recover the tablespace are as follows:

1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace offline.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.

Which option identifies the correct sequence to recover the SYSAUX tablespace?

A. 6, 5, 4, 7
B. 10, 1, 2, 5, 8
C. 10, 1, 2, 5, 4, 9, 8
D. 10, 1, 5, 8, 10

Answer: C

Pass4sure 1Z0-060 Question Answer

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?

A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

Answer: CEF                                      

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database. You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted. What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?

A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in ACCOUNTS_PDB.
B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATE command.
C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.
D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.

Answer: D

Pass4sure 1Z0-060 Question Answer

Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
B. A single listener can service only one database instance and multiple remote client connections.
C. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
E. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Answer: C

Pass4sure 1Z0-060 Question Answer

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