Examine the details of the uncompressed, non-partitioned heap table CITIES.

Examine the command:
SQL> ALTER TABLE cities SHRINK SPACE COMPACT;
What must you do before executing it?

• A.Disable all indexes on the table.
• B.Enable row movement is enabled.
• C.Ensure there are no pending transactions on the table.
• D.Ensure free space that is approximately equal to the space used by the table should be available.

Comment: *

Name: *

Email: *

Verification: *

You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.
Which is true about the result?

• A.It creates the table successfully but does not encrypt any inserted data in the
  EMPNAME column because the wallet must be opened to encrypt columns with SALT.
• B.It generates an error when creating the table because the wallet is closed.
• C.It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
• D.It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about the Log Writer process?

• A.It writes when it receives a signal from the checkpoint process (CKPT).
• B.It writes concurrently to all members of multiplexed redo log groups.
• C.It writes after the Database Writer process writes dirty buffers to disk.
• D.It writes when a user commits a transaction.

Comment: *

Name: *

Email: *

Verification: *

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged.
Which command must you execute before starting the recovery of this tablespace?

• A.STARTUP FORCE
• B.STARTUP FORCE NOMOUNT
• C.ALTER TABELSPACE users OFFLINE
• D.SWITCH DATAFILE ALL

Comment: *

Name: *

Email: *

Verification: *

In your database, USERSis the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

• A.The MYTABtable is created in the SYSTEMtablespace but no rows can be inserted into the table by USER02.
• B.The MYTABtable is created in the SYSTEMtablespace and rows can be inserted into the table by USER02.
• C.The MYTAB table is created in the USERStablespace but no rows can be inserted into the table by USER02.
• D.The CREATE TABLE statement generates an error because the SYSDBAprivilege does not provide any space quota on the SYSTEMtablespace by default.
• E.The MYTABtable is owned by the SYSuser.

Comment: *

Name: *

Email: *

Verification: *