Monday, 10 February 2020

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

Monday, 30 September 2019

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

Friday, 28 December 2018

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

Tuesday, 14 August 2018

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

Monday, 26 February 2018

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

Tuesday, 26 December 2017

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

Thursday, 9 November 2017

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