1z0-063 Exam Question 146
You are connected to a pluggable database (PDB) as a common user with the SYSDBAprivilege. The PDB is open and you issue the SHUTDOWN IMMEDIATEcommand.
What is the outcome?
What is the outcome?
1z0-063 Exam Question 147
Which two statements are true regarding the Oracle Data Pump export and import operations?
1z0-063 Exam Question 148
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
1z0-063 Exam Question 149
Users report this error message when inserting rows into the orders table:
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)
ERROR at line1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries? (Choose two.)
1z0-063 Exam Question 150
A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, /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.

You plan to multiplex the control file to a new location, /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.