1Z0_063 questions • Exam prepare

Exam contains 263 questions

Page 24 of 44

Question 139 🔥

Examine the following set of RMAN commands:RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RKAN> RUN{ALLOCATE CHANNEL chl DEVICE TYPE DISK;EXECUTE SCRIPT arc_backup;}Which statement is true about the RMAN run block execution?

Which database solution meets these requirements?

A. The script is executed and both DC1 and chi channels are used for script execution.

B. The execution of the script fails because multiple channels cannot exist simultaneously.

C. The persistent configuration parameter, DC1, is overridden because a new channel is allocated in the RMAN run block.

D. The new channel, chi, is ignored because a channel has been configured already.

Discussion of the question

Question 140 🔥

You create two Resource Manager plans, one for night time workloads, the other for day time.How would you make the plans switch automatically?

Which database solution meets these requirements?

A. Use job classes.

B. Use scheduler windows.

C. Use the mapping rule for the consumer groups.

D. Set the switch_time plan directive for both plans.

E. Use scheduler schedules.

Discussion of the question

Question 141 🔥

Which three statements are true about Consolidated Database Replay?

Which database solution meets these requirements?

A. The workload capture and replay systems must have the same operating system (OS).

B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).

C. A subset of the captured workload can be replayed.

D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Discussion of the question

Question 142 🔥

Which two statements are true about Flashback Version Query?

Which database solution meets these requirements?

A. The result of a query can be used as part of a DML statement.

B. It can be used to create views.

C. It can be used only if Flashback Data Archive is enabled for a table.

D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

Highly voted

E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Highly voted

Discussion of the question

Question 143 🔥

Which three statements are true about unplugging a pluggable database (PDB)?

Which database solution meets these requirements?

A. The PDB must be open in read only mode.

B. The PDB must be dosed.

C. The unplugged PDB becomes a non-CDB.

D. The unplugged PDB can be plugged into the same multitenant container database (CDB)

E. The unplugged PDB can be plugged into another CDB.

F. The PDB data files are automatically removed from disk.

Discussion of the question

Question 144 🔥

You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). You are connected to cdb$root as the sys user.You execute the commands:SQL> CREATE USER C##ADMIN IDENTIFIED BY orcll23;SQL> CREATE ROLE C##CONNECT;SQL> GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;SQL> GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;Which statement is true about the c##connect role?

Which database solution meets these requirements?

A. It is created only in cdb$root and cannot be granted to the c##admin user with the container=all clause.

B. It is granted to the c##admin user only in the CD

C. It is granted to the c##admin user in all PDBs and can be granted only to a local user in a PDB.

D. It is granted to the c##admin user in all PDBs and can be granted object and system privileges for a PDB.

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_063

Exam contains 263 questions

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

Company

Product

Resources

Follow us