Which two statements correctly describe the relationship between data files and logical database structures?
(Choose two.)

• A.A segment cannot span data files.
• B.A data file can belong to only one tablespace.
• C.An extent cannot span data files.
• D.The size of an Oracle data block in a data file should be the same as the size of an OS block.

Comment: *

Name: *

Email: *

Verification: *

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?

• A.running the Memory Advisor for the library cache
• B.running the Memory Advisor for the buffer cache
• C.running the Memory Advisor for the PGA
• D.running the Memory Advisor for the SGA

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about using flashback database in a multitenant container database
(CDB)? (Choose three.) (Choose three.)

• A.The root container can be flashed back without flashing back the pluggable databases (PDBs).
• B.To enable flashback database, the CDB must be mounted.
• C.Individual PDBs can be flashed back without flashing back the entire CDB.
• D.The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
• E.A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore
  point.

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.Only the rows that are deleted in the DEPARTMENTS and EMPLOYEES tables are locked until the transactions on the DEPARTMENTS table is complete.
• B.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.
• C.The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete.
• D.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.

Comment: *

Name: *

Email: *

Verification: *

Examine these two statements:

Which three are true about the MRKT tablespace? (Choose three.)

• A.The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
• B.The MRKT tablespace may be dropped if it has no contents.
• C.Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
• D.No more data files can be added to the tablespace.
• E.The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.

Comment: *

Name: *

Email: *

Verification: *