Online Access Free Oracle.1z0-063.v2021-12-27.q100 Practice Test (Page 6)

1z0-063 Exam Question 21

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?

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

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

C.It is granted to the c##admin user only in the CDB.

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

1z0-063 Exam Question 22

Examine the command:

Which statement is true about the execution of the command?

A.It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations.

B.It fails because the log file parameter is not specified.

C.It fails because no absolute path is specified for the log file and dump file.

D.It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three.

1z0-063 Exam Question 23

In the SPFILE, UNDO TABLESPACE is Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

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

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

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

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

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

1z0-063 Exam Question 24

A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES= '/u01/app/oracle/oradata/cdb1/disk1/control01.ctl,
/u01/app/oracle/oradata/cdb1/disk2/control02, ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'
SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
'/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl,
/u01/app/oracle/oradata/cdb1/disk3/control03.ctl';.
4. Copy the control file from the existing location to '/u01/app/oracle/oradata/cdb1/disk3/control03.ctl'.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.

A.3, 1, 4, 6

B.1, 5, 2, 4, 6

C.3, 4

D.2, 1, 4, 6

E.2, 6

1z0-063 Exam Question 25

You create a new database by using the CREATE DATABASEcommand in SQL *Plus, with the ENABLE PLUGGABLE DATABASEclause specified.
Which statement is true about the database that is created?

A.It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

B.It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

C.It is created as a PDB that must be plugged into an existing CDB.

D.It is created as a CDB with the CDB$ROOTand PDB$SEEDdatabases.

Other Version: 58Oracle.Briandumpsprep.1z0-063.v2022-03-17.by.arthur.218q.pdf; 4720Oracle.1z0-063.v2022-02-06.q218; 66Oracle.Examcollectionpass.1z0-063.v2021-09-28.by.kelly.255q.pdf

Latest Upload: 137SAP.C_ABAPD_2507.v2025-09-12.q56; 120SAP.C_TS452_2022.v2025-09-12.q83; 184ACSM.020-222.v2025-09-11.q48; 158VMware.5V0-31.23.v2025-09-10.q73; 132Oracle.1z0-915-1.v2025-09-10.q24; 162Citrix.1Y0-231.v2025-09-10.q87; 146SAP.C-THR85-2505.v2025-09-09.q29; 178Adobe.AD0-E727.v2025-09-09.q76; 136Oracle.1Z0-1123-25.v2025-09-09.q20; 137SAP.C_SIGPM_2403.v2025-09-08.q20

1z0-063 Exam Question 21

1z0-063 Exam Question 22

1z0-063 Exam Question 23

1z0-063 Exam Question 24

1z0-063 Exam Question 25

Download PDF File