Which three statements are true about the purpose of checkpoints?

• A.They ensure that uncommitted transactions are rolledback in case of an instance failure.
• B.They ensure that all the dirty buffers are written to disk during a normal shutdown.
• C.They ensure that instance recovery starts in the event of an instance failure.
• D.They ensure that dirty buffers in the buffer cache are written to disk regularly.
• E.They reduce the time required for recovery in case of an instance failure.

Comment: *

Name: *

Email: *

Verification: *

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table.
Which statement is true?

• A.The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
• B.The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.
• C.The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.
• D.Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.

Comment: *

Name: *

Email: *

Verification: *

Which users are created and can be used for database and host management of your DBaaS database servers?

• A.root, opc and oracle users
• B.root, oracle and cloud users
• C.opc and oracle users
• D.cloud and oracle users
• E.root and oracle users

Comment: *

Name: *

Email: *

Verification: *

Which two are prerequisites for performing a flashback transaction? (Choose two.)

• A.Flashback Database must be enabled.
• B.Undo retention guarantee for the database must be configured.
• C.EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
• D.Supplemental logging must be enabled.
• E.Recycle bin must be enabled for the database.
• F.Block change tracking must be enabled tor the database.

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the logical storage structure of an Oracle database?

• A.An extent contains data blocks that are always physically contiguous on disk.
• B.An extent can span multiple segments,
• C.Each data block always corresponds to one operating system block.
• D.It is possible to have tablespaces of different block sizes.
• E.A data block is the smallest unit of I/O in data files.

Comment: *

Name: *

Email: *

Verification: *