1Z0_067 questions • Exam prepare

Exam contains 176 questions

Page 8 of 30

Question 43 🔥

A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.What type of backup do you recommend to improve the performance of the backup?

Which database solution meets these requirements?

A. image copy backup by using RMAN

B. multisection image copy backup by using RMAN

C. multisection parallel backup by using RMAN

D. cold backup after taking the tablespace offline

E. cold backup after placing the tablespace in backup mode

Discussion of the question

Question 44 🔥

Automatic Undo Management is enabled for your database. You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.Which three are prerequisites to fulfill this requirement?

Which database solution meets these requirements?

A. Minimal supplemental logging must be enabled.

B. The database must be running in archivelog mode.

C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

D. The flashback any table privilege must be granted to the user.

E. The select any transaction privilege must be granted to the user.

F. The recycle bin parameter must be set to on.

Discussion of the question

Question 45 🔥

Examine these Data Pump commands to export and import objects from and to the same database.The dba has not yet created users hr1 and oe1.$expdp system/managerschemas = hr.oedirectory = EXP_DIRdumpfile = export.datinclude = table$ impdpsysten/managerschemas = hr1,oe1directory = EXP_DIRdumpfile = export.datremap_schena=hr:hrl, oe:oe1What will happen when running these commands?

Which database solution meets these requirements?

A. expdp will fail because no path has been defined for the dumpfile.

B. expdp will succeed but impdp will fail because the users do not exist.

C. inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

D. impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Discussion of the question

Question 46 🔥

Which two statements are true about a multitenant architecture?

Which database solution meets these requirements?

A. Each pluggable database (PDB) has its own initialization parameter file.

B. A PDB can have a private undo tablespace.

C. Log switches occur only at the container database level.

D. A PDB can have a private temporary tablespace.

E. Each PDB has a private control file.

Discussion of the question

Question 47 🔥

Examine the command to create a pluggable database (PDB):SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/) PATH_PREFIX = '/disk2/oracle/pdb2';Which two statements are true?

Which database solution meets these requirements?

A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.

C. The tablespace specifications of pdb2 are the same as pdb1.

D. All database objects belonging to common users in PD3I are cloned in PD32.

E. pdb2 is created with its own private undo and temp tablespaces.

Discussion of the question

Question 48 🔥

Which two statements are true about scheduling operations in a pluggable database (PDB)?

Which database solution meets these requirements?

A. Scheduler jobs for a PDB can be defined only at the container database (CDB) level.

B. A job defined in a PDB runs only if that PDB is open.

C. Scheduler attribute setting is performed only at the CDB level.

D. Scheduler objects created by users can be exported or imported using Data Pump.

E. Scheduler jobs for a PDB can be created only by common users.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_067

Exam contains 176 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us