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

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

Comment: *

Name: *

Email: *

Verification: *

Which three true about recovering tables using RMAN? (Choose three.)

• A.RMAN can recover tables in the SYSTEM tablespace.
• B.RMAN can recover a table after a DDL operation has altered the table structure.
• C.RMAN always uses an auxiliary instance.
• D.RMAN can recover tables in the SYSAUX tablespace.
• E.RMAN can recover tables owed by the SYSTEM user.
• F.RMAN can recover tables in a standby database.
• G.RMAN can recover tables owned by the SYS user.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. COMM0N_USER_PREFIX IS C##.
3. PDB1 is a pluggable database contained in CDB1.
4. APP1_ROOT is an application container contained in CDB1.
5. APP1_PDB1 is an application PDB contained in APP1_ROOT.
You execute these commands successfully:

Which two are true?

• A.c##_user1 will have the same privileges and roles granted in all PDBs in cdb1.
• B.c##_app_user1 can be created in cdb1.
• C.app1_user1 can be created in cdb1.
• D.app1_user1 can have different privileges in each Application PDB contained in app1_root.
• E.app1_user1 can be created in pdb1.
• F.p1_user1 can be created in cdb1.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1 is a container database.
2. PDB1 and PDB2 are pluggable databases in CDB1.
3. PDB1 and PDB2 are open in read write mode.
You execute these commands successfully:

Which two are true?

• A.Uncommitted transactions in PDB1 have been rolled back.
• B.CDB1 is in mount state
• C.CDB1 is shut down.
• D.PDB1 is closed.
• E.Uncommitted transactions in CDB1 and pdbi have been rolled back.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about Oracle Optimizer Statistics, their use, and their collection?

• A.The Statistics Advisor generates actions for all recommendations.
• B.The Statistics Advisor can help recommend the best way to gather statistics.
• C.Statistics collected using DBMS_ATATS always yield the best optimizer result.
• D.Index balanced B*Tree height is considered when evaluating the cost of using an index,
• E.The number of table rows is considered when evaluating the cost of accessing a table using an index.

Comment: *

Name: *

Email: *

Verification: *