Free Access to Oracle.1Z0-083.v2023-06-09.q198 with Valid Practice Test (Page 8)

Question 31

Which two are true about common objects? (Choose two.)

A.They can be extended data-linked in CDB$ROOT.
B.They can exist in user-defined schemas only in application containers.
C.They can exist in CDB$ROOT and an application root.
D.They can be created only in an application root.
E.They can be created only in CDB$ROOT.
F.They can be only metadata-linked in an application container.

Question 32

Which three are true about Optimizer Statistics Advisor? (Choose three.)

A.It can be run only manually.
B.It is part of the DBMS_ADVISOR package.
C.It can recommend changes to improve the statistics gathering process.
D.It always analyzes all schemas in the database.
E.It runs automatically every night by default.
F.It is part of the DBMS_STATS package.

Question 33

How do you configure a CDB for local undo mode?

A.Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and create an UNDO tablespace in each PDB, then restart the CDB instance.
B.Open the CDB instance in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.
C.Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.
D.Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.
E.Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

Question 34

Which two are true about automatic block repair?

A.It is not possible for media corrupt blocks.
B.Real-Time Query must be enabled on a primary database for automatic block repair to be done on any of its physical standby databases.
C.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on that physical standby database.
D.Automatic block repair can repair blocks with no standby database if db_block_checking = TRUE.
E.Real-Time Query must be enabled on a physical standby database for automatic block repair to be done on its primary database.

Question 35

Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c? (Choose two.)

A.The response file can specify the path of the sudo program.
B.The response file must contain the root or sudo password.
C.Silent install always runs operating scripts automatically.
D.The installer will prompt for the root or sudo password.
E.The response file can specify the root or sudo password.

Question 31

Question 32

Question 33

Question 34

Question 35

Download PDF File