The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?

• A.The command waits and the user SCOTT can execute data manipulation language (DML) statements only as part of the current transaction.
• B.The command fails as a transaction is still pending.
• C.The transaction in Scott's session is rolled back and the tablespace becomes readonly.
• D.The command hangs until all transactions on the objects in the tablespace commit or rollback, and then the tablespace is placed in readonly mode.

Comment: *

Name: *

Email: *

Verification: *

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute
the following commands in the root container:

Which two statements are true? (Choose two.)

• A.The C # # ROLE1 role is created in the root database and all the PDBs.
• B.The C # # ROLE1 role is created only in the root database because the container clause is not used.
• C.Privileges are granted to the C##A_ADMIN user only in the root database.
• D.Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
• E.The statement for granting a role to a user fails because the CONTAINER clause is not used.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true concerning the multitenant architecture?

• A.Each pluggable database (PDB) has its own set of background processes.
• B.A PDB can have a private temp tablespace.
• C.PDBs can share the sysaux tablespace.
• D.Log switches occur only at the multitenant container database (CDB) level.
• E.Different PDBs can have different default block sizes.
• F.PDBs share a common system tablespace.
• G.Instance recovery is always performed at the CDB level.

Comment: *

Name: *

Email: *

Verification: *

Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

• A.Memory is dynamically re-allocated between the SGA and PGA as needed.
• B.The size of the PGA cannot grow automatically beyond 500 MB.
• C.Only SGA components are sized automatically.
• D.The value of the MEMORY_TARGET parameter cannot be changed dynamically.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about the Pre-Upgrade Information Tool?

• A.The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.
• B.It generates a script to recompile invalid objects post-upgrade.
• C.The preupgrade_fixups.sql script is created to list and describe issues in the source database.
• D.It checks for required tablespaces and if they are not available, creates them automatically.
• E.The portupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.
• F.A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.

Comment: *

Name: *

Email: *

Verification: *