Sunday, 1 March 2020

Oracle 1Z0-062 Questions Answers

Examine the parameters for your database instance:




You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;

Which statement is true in this scenario?

A. Undo data is written to flashback logs after 1200 seconds.
B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
C. You can perform a Flashback Database operation only within the duration of 1200 seconds.
D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.

Answer: D


As a user of the ORCL database, you establish a database link to the remote HQ database such that all users in the ORCL database may access tables only from
the SCOTT schema in the HQ database. SCOTT’s password is TIGER. The service mane “HQ” is used to connect to the remote HQ database.
Which command would you execute to create the database link?

A. CREATE DATABASE LINK HQ USING 'HQ';
B. CREATE DATABASE LINK HQ CONNECT TO CURRENT_USER USING ‘HQ’;
C. CREATE PUBLIC DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';
D. CREATE DATABASE LINK HQ CONNECT TO scott IDENTIFIED BY tiger USING 'HQ';

Answer: C

Wednesday, 2 October 2019

Oracle 1Z0-062 Questions Answers

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload
Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?


A. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.
B. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
C. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.
D. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.

Answer: A

Thursday, 6 December 2018

Oracle 1Z0-062 Questions Answers

You plan to upgrade your Oracle Database 9i to Oracle Database 12c.
Which two methods can you use? (Choose two.)


A. Perform a rolling upgrade.
B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
C. Perform a direct upgrade by manually running thecatctl.plandcatupgrd.sqlscripts before issuing the STARTUPUPGRADE command.
D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.
E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

Answer: C,D

Thursday, 12 July 2018

A $2.7 Billion Rival To Oracle And Microsoft Has Signed On 1 Million Developers To Learn How To Use Its Databases Better


More than 1 million people have enrolled in courses that teach how to use MongoDB, the database company that is gaining adherents with developers even as it gains ground in Oracle and Microsoft.

The company told Business Insider on Thursday that MongoDB University, a series of free online courses that teach users how to use the open source database platform, has surpassed one million records.

The growing popularity of MongoDB University has helped the platform, which was founded in 2007, to take off with developers as an alternative to Oracle and Microsoft's oldest and established database programs, which were originally created to deal with types more rigid data.

According to the annual survey of Stack Overflow developers, MongoDB is the fourth most popular database, behind Oracle's MySQL, Microsoft's SQL server and PostgreSQL. The company says that more than 40 million people have downloaded MongoDB so far.

The company sees success as a sign of its traction with developers, and of how MongoDB is becoming a desirable skill for anyone trying to advance their career.

"We have examples of people in small countries trying to level up to improve their career opportunity, we have large companies that use nothing more than MongoDB University to train their team, and this is why we decided to invest to make it as easy as possible. learn to use MongoDB, "Shannon Bradshaw, Vice President of Education, told Business Insider.
Filming during Hurricane Sandy

MongoDB University was created by a small team of five people in 2012, with some complications.

The first set of courses was scheduled to be filmed and loaded in October 2012. When Hurricane Sandy hit, although the power outages of the storm prevented the New York-based company from doing the rest of the videos.

But the team still wanted to find a way to get the rest of the lessons online, since students from all over the world were expecting courses. To upload videos, the then vice president of education of the company used a generator, his cell phone and a camera team to shoot each video and send the footage to the company's video team. The co-founder of MongoDB went to a nearby Starbucks, the only place with power, and filmed videos there.

Since its first year, the number of employees in the MongoDB University team has increased from five to more than 20.

"I think that's indicative of the way the whole company is really behind the idea of ​​MongoDB University and how far the company was willing to go from the start to take off," Bradshaw said.

Thursday, 1 March 2018

Oracle 1Z0-062 Question Answer

Which two resources might be prioritized between competing pluggable databases when
creating a multitenant container database plan (CDB plan) using Oracle Database
Resource Manager?


A. MaximumUndo per consumer group
B. Maximum Idle time
C. Parallel server limit
D. CPU
E. Exadata I/O
F. Local file system I/O

Answer: C,E



Your database instance is started with a PFILE.



You want to increase the size of the buffer cache. Free memory is available to increase the
size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?


A. Change is applied to the current instance, but does not persist after instance restart.
B. The value is changed only in the PFILE and takes effect at the next instance startup.
C. The value is changed for the current instance and in the PFILE.
D. It fails because the SCOPE clause is missing.

Answer: A

Friday, 29 December 2017

Oracle 1Z0-062 Question Answer

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENTCONTROLFILE SECTION SIZE
100M;
F. BACKUP SPFILE SECTION SIZE 1M;
G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Answer: A,B,E,G



Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container:


Which two statements are true?

A. Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
B. The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
C. The command will, create a common user whose description is contained in the root and each PDB.
D. The schema for the common user C # # A_ADMIN can be different in each container.
E. The command will create a user in the root container only because the container clause is not used.

Answer: C,D

Friday, 27 October 2017

Oracle 1Z0-062 Question Answer

Which three statements are true about a job chain?

A. It can contain a nested chain of jobs.
B. It can be used to implement dependency-based scheduling.
C. It cannot invoke the same program or nested chain in multiple steps in the chain.
D. It cannot have more than one dependency.
E. It can be executed using event-based or time-based schedules.

Answer: A,B,E


Your database instance is started by using a server parameter file (SPFILE). You execute
the following command to change the value of the LOG_BUFFER initialization parameter:
ALTER SYSTEM SET LOG_BUFFER=32 M;
What is the outcome of this command?


A. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.
B. Itreturns an error because the value of this parameter cannot be changed dynamically.
C. The parameter value is changed and it comes into effect at the next instance startup.
D. It returns an error becauseSCOPEshould be set toMEMORY.

Answer: B