Which statement is true in this scenario?

I have not found any cheat to the second part of this exam yet… What really funny is that my friend passed the “Upgrade to 12c OCP” exam, where the questions were the same. Interesting, but if you compare these questions to the 1z0-060 then you can see that the questions almost the same… what should not be so.
I have a theory how it is possible.
First came the 1z0-060.. guys acquired the questions.. then came the 1z0-062 .. they compared the questions and realized that many of the questions are the same… so.. they took these questions to this exam too… what can I say to that… they are not interested to give us the right cheat.. important is for them that you buy a cheat on a cheat site…

yeah i’m waiting for some questions of the second part aswell. So we can search if its close to another 1Z0-xxx cheat. So people that have done the test don’t hold back 🙂

Would be much appreciated 🙂

Anyone done the exam as of late ? Is it now only 1 exam ?

I have 30 question from the 2nd subexam, but i don’t have the answers, anyone can email me and i will send them to him

Hi Gee, could you please send me the 30 questions from the 2nd subexam. my email: [email protected]

Hi everyone,

I just sent an email regarding the 30 questions which I typed in word file. I agree some of the answers are wrong but that’s all I got. I have some more stuffs but I don’t know how could I share. However, please reply to my second email regarding 1Z0-061 if you have any information.

Today i try pass this exam (failed), but i remember some question from the second part: First question about process SMON (what is it and what it do), second question about installing grid infrastructure on the server with two instance, and you must answer about oracle restart in this situation. And one question about two tables with foreign key and CASCADE DELETE, when we deleted record from parent table – what type of lock in parent and child table occurs.

Hi gee, can you please send me the 30 questions that every1 is talking about?

thanks is advance.

Can anyone please send me the 30 questions to [email protected]?
Thanks in advance!!!

Are the new 30 questions posted in this blog?

Can you send the 30 questions please. Email is [email protected]

Hi all,

Can someone please share those 30 questions from the second part? [email protected]
I will take OCA exam this saturday.

Thanks in advance.

I had my exam yesterday – and I scored 72% 🙂

As other people already said:
– you will be presented 95 questions in total – just a few questions come from this dump (roundabout 20%).
– there are no questions about CDB/PDB or RAC (so you can skip all of them in this dump, e.g #25, #33 and so on).
– relevant topics are explained by Dawid in his comment from Nov 4, 2015.

Good luck everybody.

Hi everyone,

Anyone whose kind enough to send me the 30 questions? Please send it to [email protected]

Thanks!!!

I think A.

do you have more questions? can you send me to [email protected]

Thanks

Some Questions that I remember FAINTLY –

Question on when you enable ARCHIVELOG MODE, and db_recovery_file_dest is already set. Does it ask you to set a location for LOG_ARCHIVE_DEST or does it use the db_recovery_file_Dest location for logfiles?

Question on what actions you can perform with the DBCA – Configure DRCP? Configure client connections? Tablespace block sizes? Etc – Open up the DBCA and look at all the options

Question on UNDO Tablespace – 3 undo tablespaces, 1 is set as a default and it has reached its limit. What happens when a transaction is run? Does it fail?

Resumable space allocation stuff – Read a lot into this –

Data Pump – Does it overwrite existing files? – Normally, Data Pump would return an error if you specify a dump file that already exists. The REUSE_DUMPFILES parameter in 11g and up will allow you to overwrite an existing dump.

Server generated Alerts –

2 Recommendations to developers about Locking – Let Oracle handle it? Avoid long running transactions?

Create a user with EXTERNAL authentication

Manual MANAGED TABLESPACES with MIN/MAX Extent (DICTIONARY MANAGED TABLESPACES) – Look into Storage Parameters

I am taking 1z0-062 exam in 2 weeks. Could any1 please send some valid questions to me?

my email: [email protected]

thank you!!!

I have passed this exam 3 weeks ago. If you have any questions, feel free to ask me about anything.

From this site on the exam was only 5 questions.

I think that you should read questions and answers from exam 1z0-060. I am planning to sit for the exam at the end of April.

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMETS .DEPARTMENT_ID column. An index exists on the DEPARTMETS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?
A) The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
B) Only the rows that are deleted in the DEPARTMETS and EMPLOYEES tables are locked until the transaction on the DEPARTMENTS table is complete.
C) The transaction acquires a table lock only on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS is complete.
D) The transaction acquires a table lock only on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS is complete.

They think?

@Ronald
It’s D dude. I am absolutely sure.

4. Which two tools can be used to configure static service information in the listener.ora file?
A) Oracle Net Manager
B) Oracle Enterprise Manager Cloud Control
C) Oracle Net Configuration Assistant
D) Listener Control Utility (LSNRCTL)
E) Oracle Enterprise Manager Database Express

??

Hi All,

I would like to thank anyone who contributed here for your comments/sharing.
Today’s I passed 062 with 83%.

The 30 questions can be found here.
https://www.academia.edu/22421020/Z0-62

Features I remember are: DBCA, DBUA, ASM, Oracle Restart, listner reload, SQL Loader (including express mode), DB block/extent/segment, table / row lock like Ronald posted, ARCHIVELOG, shared server, resource manager/schedule/job, temporary table, Pre-Upgrade Tool just like Dawid & AlucarD mentioned.

My suggestion is, for each question here, check it in the student guide, if you can find the relative information, then it may be covered. If it’s not mentioned in the student guide at all, then it won’t be covered by the exam (just personal thoughts).
Most of the answers can be found in the student guide.

Most important, there is no cdb/pdb question in my exam, so you can skip them I think.

Good luck and best regards,
Shoulian

I just pass my exam recently. Reach me at [email protected] if you want to know more.

Dear All,

Passed the OCA 12c. Make sure that you go through the 30 questions.No PDB/CDB.

Regards,
Suresh

I PASS MY EXAM!!! thanks simple. it’s worth 🙂

Hi Simple, could you please share me some tips for the exam?

SIMPLE!!! I passed my exam! I dont know u did it. But u rock!!

6. Which three file types are stored in the Fast Recovery Area by default in a traditional non-OMF file system?
A) online redo log files
B) parameter file
C) multiplexed copies of the current control file
D) archived log files
E) Flashback Data Archive files
F) Flashback logs

why acd? I think it should be cdf

Also, what’s the answer to the following question?

You have the following entry in the tnsnames.ors file of your hq.us.example.com host machine:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADRESS = (PROTOCOL = TCP)(HOST = hq.us.example.com)(PORT = 1521))
)
CONNECTED_DATA =
(SERVICE_NAME = ORCL.us.example.com)
)
)

You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL

Which statement is true about the connection to the ORCL database instance?

A) The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.
B) The connection fails because the net service name does not have the suffix us.example.com.
C) The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.
D) The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.

Hi all. i failed the exam. 🙁
i have study the dump from philipino yet no luck on the exam.
Any advice?

anybody has the correct questions please email me:
abdyns89@yahoo

i have study all fhe free ques that post online. Can someone pls advise whether those are valid or not? I going to take the exam soon. Please help!

Hey just passed exam today. Need help let me know for help

Hi AA, please help me [email protected]

1. Which three statements are true about the Pre-Upgrade Information Tool?
A) It clears all user recycle bins in a database and releases their storage space.
B) It writes a list of invalid SYS and SYSTEM objects to the registry$sys_inv_objs table.
C) It evaluates the dependencies of network utility packages.
D) It identifies any deprecated and unsupported parameters.
E) It generates fix-up scripts and automatically runs them to resolve issues that are flagged in the source database.

Answer:BCD

2. Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
A) configuration of unified auditing mode
B) Execution of SQL statements by users connected with the SYSDBA privilege
C) Usage of the AUDIT statement
D) Creation of a fine grained audit policy

Answer:B

3. Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c
A) Put all readonly tablespaces in read write mode.
B) Recompile all invalid objects
C) Set the compatible parameter to 12 1 0 1
D) Gather dictionary statistics.
E) Empty all user recycle bins.

Answer:DE

4. Which two tools can be used to configure static service information in the listener.ora file?
A) Oracle Net Manager
B) Oracle Enterprise Manager Cloud Control
C) Oracle Net Configuration Assistant
D) Listener Control Utility (LSNRCTL)
E) Oracle Enterprise Manager Database Express

Answer:AB

5. In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and a Automatic Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
A) It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
B) It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
C) It calls other advisors if required, but does not provide recommendations about the advisors to be used.
D) It always compares the latest snapshot with the baseline snapshot for analysis.
E) It requires at least four AWR snapshots for analysis.

Answer:AB

6. Which three file types are stored in the Fast Recovery Area by default in a traditional nonOMF file system?
A) online redo log files
B) parameter file
C) multiplexed copies of the current control file
D) archived log files
E) Flashback Data Archive files
F) Flashback logs

Answer:CDF

7. You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?
A) A custom database template
B) A Data Warehouse database template
C) Automatic Storage Management (ASM) for storage of data files.
D) A file system for storage of data files

Answer:A

8. Which two statements are true about the Database Configuration Assistant (DBCA)?
A) It can be used to add an new tablespace
B) It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
C) It can configure Automatic Storage Management (ASM) diskgroups.
D) It can be used to create a database template from an existing database
E) It can generate SQL database creation scripts.

Answer:DE

9. Identify two prerequisites for configuring Enterprise Manger Database Express (EM Express).
A) Grant the APEX_PUBLIC_USER role to the SYSMAN user
B) Install Oracle HTTP Server
C) Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server
D) Configure at least one dispatcher for the TCP/IP protocol
E) Create a SYSMAN user with the SYSDBA privilege as an administration for EM Express.

Answer:CD

10. Which three tools or tasks are run by default as part of automated maintenance tasks?
A) SQL Access Advisor
B) Optimizer statistics gathering
C) Segment Advisor
D) Automatic SQL Tuning Advisor
E) Automatic Database Diagnostic Monitor

Answer:BCD

11. Which three statements are true about automated maintenance tasks?
A) Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.
B) A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
C) They run at predefined time intervals that are intended to occur during a period of low system loads
D) An Oracle Scheduler job is created for each maintenance tasks that is scheduled to run in a maintenance window.
E) A maintenance window is automatically extended until all the maintenance tasks defined are completed.

Answer:ACD

12. What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?
A) It generates a log file containing the fixes that can be made to the source database.
B) It recompiles all invalid PLSQL and Java code.
C) It provides parallel upgrade options to finish the upgrade process with a reduced down time.
D) It provides a summary of the upgrade results.
E) It generates fixup scripts to be run on the source database before upgrade.

Answer: C

13. You install Oracle Grid Infrastructure standalone server and issue the following command:
crsctl start has
Which two existing components get automatically added to the Oracle Restart configuration?
A) Oracle CSSD services
B) the database whose instance is running
C) Oracle Notification services
D) Oracle Healthcheck services
E) Oracle Net Listener

Answer:AD

14. Which three statements are true about Oracle Restart?
A) It can be configured to automatically attempt to restart various components after a hardware or software failure
B) It can be used to only start Oracle components
C) While starting any components, it automatically attempts to start all dependencies first and in proper order
D) It runs periodic check operations to monitor the health of Oracle components.
E) It can be configured to automatically restart a database in case of normal shutdown of the database instance.
https://docs.oracle.com/database/121/ADMIN/restart.htm#ADMIN13388

Answer:ACD

15. Which two statements are true about using SQL*Loader?
A) It can load into multiple tables using the same load statement.
B) It can generate unique sequential key values in specified columns.
C) It can load data from external files by using the direct path only.
D) It can load data into one table at a time.
E) It can load data from external files by using the conventional path only.

Answer:AB

16. Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database?
A) The DEGREE_OF_PARALLELISM parameter is set to AUTO
B) You cannot load data into multiple tables.
C) You can selectively load rows into a table based on a filter.
D) If no data file is specified, it assumes the data file to be .dat in the current directory and uses it.
E) You cannot have multiple SQL*Loader data files.

Answer:AD

17. You want the execution of a large database operation to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600
Which two statements are true?
A) Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE Statement must be issued in its session.
B) Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C) A suspended statement will report an error if no corrective action has taken place during timeout period.
D) Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
E) A resumable statement can be suspended and resumed only once during execution.

Answer:AC

18. In your database instance, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:
CREATE PROFILE app_user LIMIT
SESSIONS_PER_USER 5
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL 3000
IDLE_TIME 10
PASSWORD_LIFE_TIME 60
PASWORD_REUSE_TIME 60
PASWORD_REUSE_MAX UNLIMITED
Which two statements are true about users and their sessions that are subject to this profile?
A) The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
B) These users can never reuse a password
C) The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
D) In each user session, the limit for LOGICAL_READS_PER_SESSION is the same as defined in the DEFAULT profile.

Answer:BD

19. You want to reduce fragmentation and reclaim unused space of the SALES table but not its dependent objects. During the operation, you want to ensure the following:
i. Long-running queries are not affected
ii. No extra space is used
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommended?
A) DEALLOCATE UNUSED
B) SHRINK SPACE CASCADE
C) SHRINK SPACE COMPACT
D) ROW STORE COMPRESS BASIC

Answer:C

20. The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
A) Exclusive table-level lock on the EMPLOYEES table
B) Row-exclusive lock on the row being updated
C) Null lock on the EMPLOYEES table
D) Null lock on the row being updated

Answer:B

21. You have the following entry in the tnsnames.ors file of your hq.us.example.com host machine:
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADRESS = (PROTOCOL = TCP)(HOST = hq.us.example.com)(PORT = 1521))
)
CONNECTED_DATA =
(SERVICE_NAME = ORCL.us.example.com)
)
)
You issue the following command at the command prompt:
Sqlplus HR/HR@ORCL
Which statement is true about the connection to the ORCL database instance?
A) The connection succeeds, provided the NAMES.DEFAULT_DOMAIN parameter is set to us.example.com in the sqlnet.ora file on the client side.
B) The connection fails because the net service name does not have the suffix us.example.com.
C) The connection succeeds, provided the SERVICE_NAMES initialization parameter is set to ORCL.
D) The connection succeeds, provided the ORCL.us.example.com database service is registered with a listener, the listener is up, and the database is open.

Answer:D

22. Which statement is true about redo log files during instance recovery?
A) All current, active, and inactive redo logs are required to complete instance recovery.
B) All redo log entries in the current and active logs are applied to the data files to reconstruct changes made after the most recent checkpoint.
C) All redo log entries in the current log are applied to data files until the checkpoint position is reached.
D) All current, online, and archived redo logs are required to complete instance recovery.

Answer:C

23. A database uses Automatic storage Management (ASM) as database storage, which has diskgroup, DATA1, which is created as follows:
SQL> CREATE DISKGROUP data1 NORMAL REDUNDANCY
FAILUREGROUP failuregrp1 DISK ‘/dec/sda1’, ‘/dev/sda2’,
FAILUREGROUP failuregrp2 DISK ‘/dec/sda3’, ‘/dev/sda4’;
What happens when the FAILURGRP1 failure group is corrupted?
A) Mirroring of allocation units occurs within the FAILUREGRP2 failure.
B) Transactions that are using diskgroup fail.
C) ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILUREGRP2 failure group.
D) Data in the FAILUREGRP1 failure group is move to the FAILUREGRP2 failure group and rebalancing is started.

Answer:C

24. Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make –f ins_rdbms.mk uniaud_on ioracle ORACLE_Home=$ORACLE_HOME
Which two steps should you perform before executing this command?
A) Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
B) Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.
C) Shutdown the database instance
D) Drop any existing fine-grained audit (FGA) policies
E) Stop the listener.

Answer:CE

25. Which three factors influences the optimizer’s choice of an execution plan?
A) Cardinality estimates
B) The OPTIMIZER_MODE initialization parameter
C) Fixed baselines
D) Type of connection used to connect to database instance
E) Object statistics in the data dictionary

Answer:ABE

26. Which three statements are true about Oracle Data Pump?
A) IMPDP can be used to change target data file names, schemas, and tablespaces during import.
B) Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
C) IMPDP always use the conventional path insert method to import data.
D) The DBMS_DATAPUMPS Pl/SQl Packages can be used independently of Data Pump clients to perform export and import operations.
E) EXPDP and E IMPDP are the client components of Oracle Data Pump.

Answer:ADE

27. The DEFERRED_SEGMENT_CREATION parameter is set TRUE in your database instance. (erfasst)
You execute the following command to create a table:
SQL> CREATE TABLE acctl
(ac_no NUMBER,
ac_desc varchar2(25),
amount number(10,2));
Which two statements are true?
A) A segment is allocated when an index is created for any column in the table.
B) The table is created without segment because the storage clause is missing
C) A segment is allocated when the first row is inserted table.
D) A segment is allocated for the table if the ALTER TABLE …..ALLOCATE EXTENT command is issued.
E) The table is created and extents are immediately allocated as per default storage defined for its tablespace.

Answer:AC

28. The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMETS .DEPARTMENT_ID column. An index exists on the DEPARTMETS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?
A) The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
B) Only the rows that are deleted in the DEPARTMETS and EMPLOYEES tables are locked until the transaction on the DEPARTMENTS table is complete.
C) The transaction acquires a table lock only on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS is complete.
D) The transaction acquires a table lock only on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS is complete.

Answer:D

29. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)?
A) It runs automatically after each AWR snapshot is created and it requires at least two snapshots for analysis.
B) Its results are stored in AWR.
C) It calls SQL advisors automatically if required.
D) It provide recommendations only for poorly performing SQL statements.
E) It requires at least one AWR snapshot for analysis.

Answer:AC

30. Which set of statements is true about data dictionary views?
1) They are stored in the SYSTEM tablespace.
2) They are based on virtual tables
3) They are owned by the SYS user
4) They can be queried by a normal user only of the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.
5) The V$FIXED_TABLE view can be queried to list the names of these views
6) They are owned by the SYSTEM user.
A) 2, 5 and 6
B) 2, 3, 4, and 5
C) 1 and 3
D) 1, 2 and 3

Answer:C

WHAT DO YOU THINK ?

I am planning to take 062 next week any help or tips are greatlly appreciated. please email me with any helpful information or dumps to pass at [email protected]

What can be used in a different steps by a job chain (choose four):
another chain
program
lightweight job
file watcher
job array
event
job class

Answer: another chain, program, event and ???

Thanks RJAF, I passed the exam last satauday. Your dumps was very helpfull.

Thanks a lot, Now I,m OCA 12c.