Exam2pass
0 items Sign In or Register
  • Home
  • IT Exams
  • Guarantee
  • FAQs
  • Reviews
  • Contact Us
  • Demo
Exam2pass > Oracle > Oracle Certifications > 1Z0-067 > 1Z0-067 Online Practice Questions and Answers

1Z0-067 Online Practice Questions and Answers

Questions 4

For which three pieces of information can you use the RMAN list command?

A. stored scripts in the recovery catalog

B. available archived redo log files

C. backup sets and image copies that are obsolete

D. backups of tablespaces

E. backups that are marked obsolete according to the current retention policy

Buy Now

Correct Answer: ABD

Explanation: About the LIST Command: The primary purpose of the LIST command is to list backup and copies. For example, you can list: -Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file - Backups that have expired -Backups restricted by time, path name, device type, tag, or recoverability -Archived redo log files and disk copies Reference:http://docs.oracle.com/cd/ B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585

Questions 5

In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.

You rename the undotbs undo tablespace:

ALTER TABLESPACE undotbs RENAME TO undotbs_old;

Which statement is true?

A. The tablespace will be renamed but the data file headers will not be updated.

B. The statement will fail because you cannot rename an undo tablespace.

C. The tablespace will be renamed and all the changes will be logged in the alert log.

D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Buy Now

Correct Answer: C

Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm

Questions 6

Which three statements are true about the SQL*Loader utility?

A. It can be used to load data from multiple external files into multiple tables.

B. It can be used to extract and reorganize data from external files, and then load it into a table.

C. It can be used to load data from external files using direct path only.

D. It can be used to create tables using data that is stored in external files.

E. It can be used to generate unique sequential values in specified columns while loading data.

Buy Now

Correct Answer: ABE

Questions 7

Which three statements correctly describe the relationship amongst jobs, programs, and schedules within the Oracle Job Scheduler?

A. A job is specified as part of a program definition.

B. A program can be used in the definition of multiple jobs.

C. A program and job can be specified as part of a schedule definition.

D. A program and schedule can be specified as part of a job definition.

E. A program and window can be specified as part of a job definition.

Buy Now

Correct Answer: BDE

References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN13371

Questions 8

LDAP_DIRECTORY_SYSAUTH is set to YES.

Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID).

SSL has been configure for the database and OLD and the password file has been configured for the database.

User scott with sysdba privilege tries to connect remotely using this command:

$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name.

Which authentication method will be attempted first?

A. authentication by password file

B. authentication by using certificates over SSL

C. authentication by using the Oracle Internet Directory D. authentication by using the local OS of the database server

Buy Now

Correct Answer: A

If the database is configured to use a password file for remote authentication, Oracle Database checks the

password file first.

Reference:

http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authentication.htm

Questions 9

Your database supports an OLTP workload. Examine the output of the query:

SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery Target_mttr estimated_mttr

0 76

To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30.

What is the effect of this setting on the database?

A. Automatic checkpoint tuning is disabled.

B. The frequency of log switches is increased.

C. The overhead on database performance is increased because of frequent writes to disk.

D. The MTTR advisor is disabled.

Buy Now

Correct Answer: C

Reference: http://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

Questions 10

Which three statements are true about persistent lightweight jobs?

A. A user cannot set privileges on them.

B. They generate large amounts of metadata.

C. They may be created as fully self-contained jobs.

D. They must reference an existing Scheduler Program.

E. The are useful when users need to create a large number of jobs quickly.

Buy Now

Correct Answer: ADE

Unlike regular jobs, they are not schema objects. Because lightweight jobs are not schema objects, you cannot grant privileges on them. A lightweight job inherits privileges from its specified program. Thus, any user who has a certain set of privileges on the program has corresponding privileges on the lightweight job. Use lightweight jobs when you have many short-duration jobs that run frequently. Under certain circumstances, using lightweight jobs can deliver a small performance gain. A lightweight job must reference a program object (program) to specify a job action. The program must be already enabled when the lightweight job is created, and the program type must be either `PLSQL_BLOCK' or `STORED_PROCEDURE'. References: http://docs.oracle.com/database/121/ADMIN/schedover.htm#ADMIN12668

Questions 11

Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

A. A base recovery catalog should exist.

B. The owner of VPC cannot own recovery catalog.

C. At least one target database should be registered in the recovery catalog.

D. The register database privilege should be granted to the virtual catalog owner.

E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

Buy Now

Correct Answer: ADE

References: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm

Questions 12

You are installing Oracle Database 12c with the Oracle Universal Installer (OUI). You select the option to create a database by using file system storage but you do not explicitly set ORACLE_BASE. What is the effect on the installation?

A. The installation proceeds with the default value but a message is generated in the alert log file

B. The installation terminates with an error

C. The installation proceeds with the default value but the database creation is not attempted

D. The software installation proceeds with the default value but database creation fails

Buy Now

Correct Answer: A

Questions 13

Which three statements are true about Flashback Data Archieve? (Choose three.)

A. A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first

B. While enabling Flashback Data Archieve for a table, if no name is provided for Flashback Data Archieve, it is enabled using the default Flashback Data Archieve

C. To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace

D. Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error

E. To enable Flashback Data Archieve for a table, it is mandatory to have a default Flashback Data Archieve for a database

Buy Now

Correct Answer: ACD

Exam Code: 1Z0-067
Exam Name: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Last Update: Jun 13, 2025
Questions: 264

PDF (Q&A)

$45.99
ADD TO CART

VCE

$49.99
ADD TO CART

PDF + VCE

$59.99
ADD TO CART

Exam2Pass----The Most Reliable Exam Preparation Assistance

There are tens of thousands of certification exam dumps provided on the internet. And how to choose the most reliable one among them is the first problem one certification candidate should face. Exam2Pass provide a shot cut to pass the exam and get the certification. If you need help on any questions or any Exam2Pass exam PDF and VCE simulators, customer support team is ready to help at any time when required.

Home | Guarantee & Policy |  Privacy & Policy |  Terms & Conditions |  How to buy |  FAQs |  About Us |  Contact Us |  Demo |  Reviews

2025 Copyright @ exam2pass.com All trademarks are the property of their respective vendors. We are not associated with any of them.