Free Oracle 1z1-062 Exam Dumps Questions & Answers

You execute this command:

Which two statements are true about segment space management for segments in this tablespace? (Choose two.)

• A.  The PCTUSED storage parameter has no effect on segments created in this tablespace.
• B.  Space utilization inside segments is mapped by bitmaps.
• C.  Segments are automatically shrunk and compressed when rows are deleted.
• D.  The PCTFREE storage parameter has no effect on segments created in this tablespace.

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table? (Choose two.)

• A.  Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• B.  Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• C.  Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
• D.  Data is never redacted for the EMP_V.SAL column.
• E.  Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.

When does a database checkpoint occur?

• A.  When a user session terminates abnormally.
• B.  When a server process terminates abnormally.
• C.  When the SHUTDOWN ABORT command is issued.
• D.  When there is an online redo log switch.

You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

• A.  Set DB_FLASH_CACHE_ZISE = 128G.
• B.  Set DB_FLASH_CACHE_ZISE = 64G.
• C.  DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
• D.  Set DB_FLASH_CACHE_ZISE = 64G, 64G

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

• A.  It will create a CDB with root opened and seed read only.
• B.  It will create a CDB that must be plugged into an existing CDB.
• C.  It will create a multitenant container database (CDB) with only the root opened.
• D.  It will create a CDB with root and seed opened and one PDB mounted.
• E.  It will create a CDB with root opened and seed mounted.