Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1Z0-034 by Oracle - Page 1 | ExamCademy

Mode Selection

Sort:

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 5 • Questions 1-25 of 103

1 2 3 4 5

→

Know a question that should be here? Contribute to this exam

Which two statements are true about setting the FAST_ START_ MTTR_ TARGET initialization parameter to a nonzero value?

A The MTTR advisor will be disabled.
B Automatic checkpoint tuning will be enabled.
C The value for the LOG_CHECKPIONT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET.
D The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization

Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in
ARCHIEVELOG mode? (Choose all that apply.) (Choose all that apply.)

A setting the FAST_START_MTTR_TARGET to set the mean time to recover
B setting the RECOVERY_PARALLELISM parameter to twice the number of CPUs
C using the DB_RECOVERY_FILE_DEST parameter to set the location for flash recovery area
D using the DB_RECOVERY_FILE_DEST_SIZE parameter to define the disk space limit for the recovery files created in the flash recovery area.

Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which perquisite must be met before accomplishing the backup?

A Provide a password for the encryption.
B Set up an Oracle wallet for the encryption.
C No setup is required as it is a default encryption method.
D Both Oracle wallet and password must be set up for the encryption.

Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.

S expdp system/manager -

Schemas =hr,oe -
directory =EXP_ DIR
include = table
$ impdp system/manager

Schemas = hr1,oe1 -

Directory = EXP_DIR -

Dumpfile = export.dat -

Remap_schema =hr:hr1,oe :oe1 -
What would be achieved by running the above commands?

A expdp will fail because no path has been defined for the dumpfile.
B expdp will succeed but Impdp will fail because users do not exist.
C impdp will create two users called hrl and oe1 and import all objects to the new schemas
D impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.

The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?

A Control files
B Password file
C Inactive online redo log file
D Archived log files required to perform recovery
E Newly created tablespace which is not backed up

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?

A ALTER DATABASE FLASHBACK ON;
B GRANT SELECT ANY TRANSACTION TO scott;
C GRANT EXECUTE ON dbms_flashback TO scott;
D ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?

A The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
B The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self- consistent.
D The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self- consistent.
E The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.
Identify two prerequisites to perform the backups. (Choose two.)

A The database must be opened in restricted mode.
B The database must be configured to run in ARCHIVELOG mode.
C The tablespaces are required to be in backup mode before taking the backup.
D The tablespaces are required to be in read-only mode before taking the backup

You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the
DBMS_NETWORK_ACL_ADMIN package.
Which statement is true regarding the ACL created?

A It is a list of remote database links stored in the XML file that are available to the users of the database.
B It is a list of users and network privileges stored in the XML file according to which a group of users canconnect to one or more hosts.
C It is a list of users and network privileges stored in the data dictionary according to which a group of userscan connect to one or more hosts.
D It is the list of the host names or the IP addresses stored in the data dictionary that can connect to yourdatabase through PL/SQL network utility packages such

View the Exhibit and examine the RMAN commands.

Question Image

Which statement describes the effect of a backup retention policy on the backup of a backup set?

A Either all the copies of a backup set are obsolete or none of them are as per the retention policy.
B The copies of the backup will be reported as obsolete under a redundancy-based backup retention policy.
C The copies of the backup will be reported as obsolete under a recovery window-based backup retentionpolicy.
D All the copies of the backup set are counted as one instance of a backup and will deleted in backup setexceeds the redundancy-based backup retention policy.

Which four resources can directives be specified by using the Oracle Resource Manager?

A CPU usage
B degree of parallelism
C number of open cursors
D number of sorts performed
E idle time for blocking sessions
F number of I/Os requests

You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).
Identify two scenarios in which you must have a recovery catalog.

A To store the backup information of multiple database
B To restrict the amount of space that is used by the backups
C To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.
D To list the data files that were in a target database at a given time by using the AT option of REPORTSCHEMA command.

View the Exhibit to observe the error.

Question Image

You receive this error regularly and have to shutdown the database instance to overcome the error. AutomaticShared Memory Management is configured for the instance.
What can you do to reduce the chance of this error in the future?

A Increase the value of SGA_MAX_SIZE
B Enable automatic memory management
C Set the PRE_PAGE_SGA parameter to true
D Lock the System Global Area (SGA) in memory

Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

A Flash recovery area must be defined
B Undo retention guarantee must be enabled.
C Database must be running in archivelog mode.
D Automatic undo management must be enabled.
E The tablespace in which the Flashback Data Archive is created must have automatic segment spaceManagement (ASSM).

Given below are RMAN commands to enable backup optimization and set the retention policy:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
The USERS tablespace has never been backed up. You take the USERS tablespace offline on Monday. Viewthe Exhibit to examine the operations performed by using RMAN.
Which two statements are true about the backup of the USERS tablespace? (Choose two.)

Question Image

A It will be backed up as a part of database backup on Friday.
B It will be backed up as a part of database backup on Tuesday.
C It will not be backed up as a part of database backup on Wednesday.
D The command on Sunday deletes the backup of the USERS tablespace taken on Tuesday.

View the Exhibit.

Question Image

You must unload data from the ORDERS, ORDER_ITEMS, and products database tables to four files using the External Table Population method.
You execute the command shown on the exhibit, but only two files have been created.
Which parameter must be changed so that four files are created?

A TYPE
B LOCATION
C PARALLEL
D DEFAULT DIRECTORY
E ORGANIZATION EXTERNAL

Which option must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?

A New channels for restore and recovery tasks
B New name for the data files of the tablespace
C Auxiliary name for the data files of the tablespace
D Auxiliary destinations for an auxiliary set of data files

Which three statements are true about windows?

A Only one window can be open at any given time
B Consumer groups are associated with windows
C Windows work with job classes to control resource allocation
D The database service name must be provided during windows creation
E Windows can automatically start job or change resource allocation among jobs for various time periods.

Note the following statements that use flashback technology:

FLASHBACK TABLE <table> TO SCN <scn>;
SELECT * FROM <table> AS OF SCN 123456;
FLASHBACK TABLE <table> TO BEFORE DROP;
FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?

A 1, 2, and 5
B 1, 3, and 4
C 2, 3, 4, and 5
D 1, 2, 3, 4, and 5

View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE). When you tried to start the database instance, you received the following error:

SQL> startup -
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information
Why did the instance fail to start?
Exhibit:

Question Image

A Because the PGA_AGGREGATE_TARGET parameter is not set
B Because the STATISTICS_LEVEL parameter is set to BASIC
C Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D Because both the SGA_TARGET and MEMORY_TARGET parameters are set.

Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

A An ASM instance mounts an ASM control file
B An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly
D An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

1Z0-034Preview

Mode Selection

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

That's the end of the Preview